I am trying to create a group of pie charts that show the number of stories vs the number of bugs by specific labels. The caveat is that the labels are only applied at the epic level, and not to any of the stories or bugs. I’m using the labels to group related epics together.
My issue is with the labels. I’ve only been able to display the labels at the story / bug level and not the epic level. Here is my sample I made in excel to show what I’m trying to do. Can anyone help?
Thanks in advance!
Hi @anewbury
You can define the Epic Label dimension, which will pass down the Epic Label to the children of the Epic:
- Add the following code to your Advanced settings and save the settings:
[[jira.issue_link_field_dimensions]]
name = "Epic Label"
source_dimension = "Label"
issue_key_column = "epic_key"
group = "Linked issue dimensions"
-
Go to the Source Data tab, click Edit for your Jira source and select the Additional options section; there, in the Issue link field dimensions select the Epic Label dimension and run the import.
-
After the import finishes, you can create a chart like this:
Best regards,
Nauris / eazyBI support
Appreciate the help. Unfortunately I cannot access the Advanced settings. Any other options for resolving this using the existing functionality? I also don’t want to go update the advanced settings every time I create a new label assigned to an epic.
Hi @anewbury
The added “Epic Label” dimension would truly be the best option, as these values would be passed down during the import process, “precalculated” for issues, and readily available in the report.
This is a one-time addition to the Advanced settings, and you can then choose in each account separately - if you wish to import this issue link field dimension.
When new labels are added to Epics, they will automatically be imported, no additional changes will be necessary.
If possible, please ask your Jira or eazyBI admin to add this to the Advanced settings. If not, let me know, and I’ll try to figure out if there is a feasible workaround using MDX calculations.
Best regards,
Nauris / eazyBI support