EazyBI From sub-task to parent, then count sub-tasks of certain type

[Jason Dopson]

Hi,

I would like to go from a sub-task that has a certain Summary 'XYZ', to the parent issue, then count all of the sub-tasks matching a certain issue type 'Defect'.  I have the two queries independently but cannot figure out how to combine them into one.

This gives me the sub-tasks matching Summary of 'XYZ':

Aggregate({
Generate(Filter(NonEmptyCrossJoin(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].DefaultMember),
[Issue].CurrentMember.Name matches '.* [A-Z]+-[0-9]+ (?i)xyz.*'),
[Issue].[Issue].CurrentMember )
})

This gives me all issue types of 'Defect':

Aggregate({
Generate(Filter(NonEmptyCrossJoin(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].DefaultMember),
[Measures].[Issue type] = 'Defect'),
[Issue].[Issue].CurrentMember )
})

But obviously since they aren't combined it doesn't give me the relationship I'm looking for.  I only want to count the Defects when there is also a sub-task with 'XYZ' in the Summary.  I hope this explanation is clear enough.  Thanks!

[Liu.Jinming]

Don't use filter，it will make your server very slowly.

First, Use JQL to Import parent issues and sub tasks.

Then use sub-task measure.

Sub-tasks created
Sub-tasks due
Sub-tasks resolved

https://docs.eazybi.com/eazybijira/getting-started/measures-and-dimensions