Build report on issue for all issue under a specific type if Epic

Questions & Answers
1

Hi,
I am trying to create a specific reporter and I am a little block.
I would like to be able to have all issue under a certain type of epic.
We have created a custom field call epic type and will would like to have the list of issue under an epic with a specific type.
For exemple, we would like to have all issue under an epic with a type at Run for exemple.
Thank you in advance for your help.
Regards,
Mickaël

2

Hi @Mickael :waving_hand:

To see all Epics of a specific type (like "Run") and also include all their child issues, here’s a simple approach:

1. Create a new calculated measure called Epic Filter:

CASE WHEN
  [Measures].[Issue type] = 'Epic'
THEN
  [Measures].[Issues created]
ELSE
  1
END

This Filters out the Epics that match your page filter (and their child issues) are included in the report no matter what.

2. Set up your report like this:

3. Add this Epic Filter measure to your report

  • Then filter it by > 0 — that way, you’ll only get the correct Epics and all of their children
1 Like
3

Hi Amit,
I don’t really understand what you send me. We have a custom field Called Epic Type and by this field we did the filter. We would like to have all issue under epics on a specific epic type. For exemple, We have epic type = A we want all issue under all epic type = A.

4

Hi @Mickael,

If I understand you right, you have a customfield on the Epic level but want to see the stories and other children of that Epic filtered by the field of Epic.

Generally, the page filter applies to measures, and the measures come from the lowest levels of the hierarchy.
In order to apply a filter to fields at higher hierarchy levels, you need to inherit the values of those fields also to the child issues.
Some standard fields could be inherited as isuse link field dimensions. Please read more about that here -Issue link field dimensions.

However, customfields require a slightly different approach. They should be “inherited” during the data import using JavaScript-calculated fields.
Please read more about that here - Epic level custom field.

Regards,
Oskars / support@eazyBI.com