Filter epics by name

Questions & Answers
1

Hi,
I want to filter epics by name. I use:
Count(
Filter(
Descendants([Issue.Epic].CurrentMember, [Issue.Epic].[Epic]),
[Issue.Epic].Name matches ‘._G.’

AND
[Measures].[Issues created]>0
)
)

BUT, it returns 0. What is wrong?

2

Hi @Annette

The [Issue.Epic].Name will return the name of the hierarchy → “Issue.Epic”.

What you want to do here is to retrieve the name of each Epic member.
You can do that like this:

[Issue.Epic].CurrentMember.Name MATCHES '._G.'

Also, this regular expression will match names that are exactly four letters long, with the first and last letter being any character and the middle being exactly “_G”.

Please check if this is the expected regular expression.

If you wish to match for any Epic name that contains the “_G” at any point, you can use a formula like this:

Count(
  Filter(
    Descendants([Issue.Epic].CurrentMember, [Issue.Epic].[Epic]),
    [Issue.Epic].CurrentMember.Name MATCHES '.*_G.*'
    AND
    [Measures].[Issues created]>0
  )
)

​Best regards,

Nauris

3

Yes, the * have been removed by the system.
I discovered that epic name is not like epic name.

I modified to case WHEN

[Issue.Epic].CurrentHierarchyMember.Get(‘Epic Name’) matches ‘._G.’ (** are removed by the system)

THEN

100 - ([Measures].[Issues due]/[Measures].[Issues created]*100)

End

BUT, this counts only the issues from 1 project, not from all.
I do not have a different filter set

4

Got it!

In the Community, you can use the Preformatted text ( </> button) option to share code; this way, no symbols will be lost.

The standard Epic hierarchy does indeed include children from the same project for the Epics.

If you have children from other projects associated with the Epic, I’d recommend defining an additional hierarchy in the Advanced settings - “Epic hierarchy without projects”.

We’ve described here how to set this up: Additional Issue hierarchies

This will allow you to count all children issues of an Epic, no matter which project they are in.

Let me know if this works as expected or if you need help setting this up!

​Best regards,

Nauris

5

Hi,
No, we have different projects with epics. The epics are not linked cross project.
I have 4 projects with similar structure.
I want to pick those epics with _G in the name.
All project have 4 of those epics.
BUT, when I set the create the measure, it calculates only for one of the projects, not the others.
I do not see a difference in the name:

  • Concept_G0_P682-34
  • Concept_G0_P772_N

EasyBI should calculate for both, but I only receive a result for the last one

6

Hi @Annette

Thanks for the details!

Did you test with this formula first?

Count(
  Filter(
    Descendants([Issue.Epic].CurrentMember, [Issue.Epic].[Epic]),
    [Issue.Epic].CurrentMember.Name MATCHES '.*_G.*'
    AND
    [Measures].[Issues created] > 0
  )
)

Could there be anything in the Page filters that selects only the relevant Epics from one Project and not the others? For example, filtered by a specific Label that is used only in one project.

Also, in the Source Data tab, have you selected all four projects to be imported into this account?

Thanks!
Nauris