Calculated member on issues

Questions & Answers
1

hello,
I’m trying to get all the issues (from a project, but it’s not relevant cause I’ll calculate it at issue level) that have an empty “Sprint” field.
I noticed the empty value is replaced with (no Sprint), so I can’t make up my mind on what to filter on.
I tried this but it doesn’t seem to work.

aggregate (
     filter(
       [issue].[issue].Members,
     [Issue].CurrentHierarchyMember.Get('Sprint') matches '(no Sprint)')
)
2

What about if you look for the descendants of the issue? and instead of a regex look for the exact match

 Aggregate( Filter(
     Descendants([Issue].CurrentMember, [Issue].[Issue]),
     [Measures].[Issue Sprint] = '(no sprint)'
 ) )
3

I get an error because of the excessive amount of aggregated objects. Thanks for the response anyway.

4

Hi @Mauro_Bennici,

To see all issues not assigned to any Sprint, you can simply add a Sprint dimension to Pages, open the dropdown menu of Pages, expand “no board,” and select the “(no sprint)” option.

In my example below, I have added Sprint to Rows & Pages to return the number of issues that haven’t been assigned to any Sprint.

1674×510 40.8 KB

Best,
Marita support@eazybi.com