Get all Stories from under a specific list of Epics

Questions & Answers
,
1

Hello,

I’ve trying to get all Stories that are under a specific list of Epic Links, but I don’t quite understand how it should work…

Now, after few minutes, I could create the following report which is a timeline representation of all Stories grouped by status:

image
image1881×732 44.3 KB

This report is good, but what I want to do now, is to exclude all Stories that are not part of a specific list of Epics, that are defined by this measure (Specific Epics):

([Measures].[Issues created],
[Issue Type].[Epic],
[Resolution].[Unresolved],
[Label].[Label1])
+
([Measures].[Issues created],
[Issue Type].[Epic],
[Resolution].[Unresolved],
[Label].[Label2])
+
([Measures].[Issues created],
[Issue Type].[Epic],
[Resolution].[Unresolved],
[Label].[Label3])

After hours of trials and researching, I could make this measure in order to be able to include only Epic Links that are part of the [Specific Epics] measure, but it does not work:

Aggregate(
Filter(
[Epic Link].[Epic].Members,
([Measures].[Specific Epics],
[Issue].[Issue].GetMemberByKey([Epic Link].CurrentMember.key),
[Epic Link].DefaultMember) > 0
)
)

Could someone please tell me how I can show only the Stories that are under the Epics specified by the [Specific Epics] measure?

Thank you!

2

Hi @Flavius225
Thanks for posting your question!
In this case the easiest solution would be importing link field dimensions (learn more here Issue link field dimensions or in a similar community post here - Filter Epic by Label - #3 by hroch)

Update your eazyBI advanced setting (Advanced settings for custom fields) with the following definitions:

[[jira.issue_link_field_dimensions]]
name = "Epic Label"
source_dimension = "Label"
issue_key_column = "epic_key"
group = "Linked issue dimensions"

[[jira.issue_link_field_dimensions]]
name = "Epic Resolution"
source_dimension = "Resolution"
issue_key_column = "epic_key"
group = "Linked issue dimensions"

Once you have imported the dimensions (you will find the dimensions in import options → Additional options → section “Issue link field dimensions”, you can add them in Pages and use to filter the necessary Epic labels and resolution.

Best wishes,

Elita from support@eazybi.com

3

Hi @Elita.Kalane ,

It’s the first time when I create such Custom Fields, but I’ve tried your proposed solution, and everything works as expected!

Thank you very much for your help!

I wish you a nice day ahead and a nice weekend! :slight_smile:

1 Like