I am trying to find a way to show a count of issues in a given sprint that are children of epics that hold a specific value in an epic-level custom field.
For example:
Sprint 5 has 14 issues, 3 of which are children of epics where the epic-level custom field “Work Stream” is equal to “Tech Debt.” The parent epics of the other 11 issues have a different value in the “Work Stream” field.
Can you please help me create that calculated measure?
Hi @bill.armstrong,
The parameter update_from_issue_key = "epic_key"
in the advanced settings for the custom field “Work Stream” will help with that. Please head to the eazyBI advanced settings and add the parameters defining the custom field. Please have a look at an example below:
[jira.customfield_NNNNN]
data_type = "string"
dimension = true
update_from_issue_key = "epic_key"
After that, the issues with epic links will inherit the custom fields value in eazyBI. Please have a look at the picture below:
Without the parameter, the report would only display “Epic” level issues. As you can see in the picture, now it retrieves all the issues from a particular Sprint that have an Epic link with the custom field “Epic Direction” value “East”.
Best,
Roberts // support@eazybi.com