Epics by Key or Name

Questions & Answers
1

Hi team
Needs some help with selecting multiple issues in EazyBI by “Key” or by Epic name. We have a list (50+) of epics that need to be represented on a pie chart.
For e.g:
[Measures].[Issue Epic Name] = “POI Receipting” OR
[Measures].[Issue Epic Name] = “Trial STP - Payment Strip Issues”

2

Not following the question. Can you elaborate?

3

Hi Steve - im trying to filter out a bunch of selected issues to produce a chart, so i have been trying a few things. The below filter works with Epic name, but im trying to find way to use the “Issue Key” instead which would be a unique data set.
Aggregate (
Filter (
[Issue].[Issue].Members,
[Issue].CurrentHierarchyMember.Name MATCHES ‘.*Test issue one’ OR
[Issue].CurrentHierarchyMember.Name MATCHES ‘.*Test issue two’
))

4

Hi @hsb,

You might want to use dimension “Epic Link” on pages to filter issues by epic name.
In the report, you can select epics one by one on which you would like to see data. Or you can create a calculated member in the "Epic Link " dimension (not Issues) to Aggregate() specific epics of interest (Calculated members in other dimensions - eazyBI for Jira).

We do not recommend creating calculated members that filter and group issues by some proeprties in the “Issue” dimension, as those might impact report performance. For more details, please see the documentation on Best practices for report creation - eazyBI for Jira.

Best,
Zane / supporte@eazyBI.com