Count Issues in Sprint Where Parent Epic's Custom Field = x

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