Hi EazyBI Community,
We have a custom field which is a Issue Picker from ScriptRunner.
Is there a way to pull in the linked issues in this field via a Heirachy?
Example:
(Issues in the picker)
Objective 1
Objective 2
Objective 3
Objective 4
Objective 5
Initiative 1 - Issue Picker: Objective 1 Objective 2
Initiative 2 - Issue Picker: Objective 3
Initiative 3 - Issue Picker: Objective 5
Initiative 4 - Issue Picker: Objective 3 Objective 5
Would like to report on:
Objective1:
Initiative 1
Objective2:
Initiative 1
Objective3:
Initiative 2
Initiative 4
Objective4:
Objective5:
Initiative 4
Hi,
It is possible to create the hierarchy from the issue picker fields in eazyBI with specific advanced settings. The limitation is that eazyBI cannot build a hierarchy if the child can have several parents. In other words, the issue picker field must be of single-issue picker type at the child issue, which seems not to be your case.
The approach with the multiple user picker field is to create a multiple value dimension from this field with advanced settings like this:
[jira.customfield_NNNNN]
data_type="string"
dimension=true
multiple_values= true
separate_table=true
NNNNN is the ID of the issue picker field. Once you import this field as a dimension, you can combine the new dimension with Issues and see the report like this:
Kindly,
Janis, eazyBI support
1 Like
