Filter Epic Link

FredG · May 19, 2021, 9:36am

Hello, i want filter Epic Link with all value begins P0090-3*

Epic Link is a section on my report.
I test this calculated member :

Aggregate(
Filter(
[Epic Link].[Epic].Members,
[Epic Link].CurrentHierarchyMember.Name MATCHES ‘P0090-3*’
)
)

I have no value on my formula

Anyone have idea ?

Thanks

Fred

Miguel_Silva · May 19, 2021, 2:06pm

Hi!

I also have this questions, although in a slightly different way. I wanted to filter all Epic that ahve a certain field as true (for example)

Thanks!

martins.vanags · May 20, 2021, 7:08am

Hi,

The syntax is very important. You are missing the dot symbol before the star symbol.
Then regular expression won’t work as you expect.

Aggregate(
Filter(
[Epic Link].[Epic].Members,
[Epic Link].CurrentHierarchyMember.Name MATCHES 'P0090-3.*'
)
)

Martins / eazyBI

martins.vanags · May 20, 2021, 7:15am

@Miguel_Silva

You could filter epics using the imported field if field is imported as property:

Aggregate(
Filter(
[Epic Link].[Epic].Members,
[Measures].[Issue custom field] = "Value1"
)
)

Martins / eazyBI

FredG · May 21, 2021, 12:10pm

Thanks martins
expression work

Csenge_Csalga · August 11, 2022, 3:16pm

HI Martin,

I tried the expression using the Issue status (as custom field) and

I got a warning message: Do not use the other dimension Epic link when defining a calculated member in Issue . Create complex calculations in Measures
If I click ignore and use the filter (page) nothing hapens.

Could you give me any hints what might be the problem?

Thanks!

martins.vanags · August 16, 2022, 6:24am

@Csenge_Csalga

What code exactly did you use to create a calculated member in “Epic Link” dimension?

Martins / eazyBI

Csenge_Csalga · August 16, 2022, 11:51am

Hi Martins,

This is the code I used:
Aggregate(
Filter(
[Epic link].[Epic].Members,
[Measures].[Issue resolution] = “unresolved”
)
)

I also tried:
Aggregate(
Filter(
[Epic link].[Epic].Members,
[Issue].CurrentHierarchyMember.get(‘Epic Status’) MATCHES ‘Analyzed’
)
)

I would like to see all Epics in GIVEN status, with all of the stories in ANY status.
If I filer for the status of the issues, it filters out also to resolved stories of the epic, not just the epic.

Thank you,
Csenge

martins.vanags · August 16, 2022, 3:28pm

Try importing “Epic Status” as a separate dimension and filter the report (all issues) by the epic’s status.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/issue-link-field-dimensions

Epic link dimension members should not be filtered by “Status” dimension members.

One other way would be uising this code in your example:

Aggregate(
Filter(
[Epic link].[Epic].Members,
[Epic].CurrentHierarchyMember.get('Status ID') = 10001
)
)

Where you should use the ID for the status Analyzed instead of 10001
To find the ID, you can create one new separate report with “Status” dimension in rows expanded and new calculated measure in columns (using this formula:
[Status].Currenthierarchymember.Key
)

Martins