I am creating a report to surface any Story that is tagged with more than 1 sprint. I am using the measure as shown here:
The report returns all stories and lists the Sprint ID for each one in a row, based on my configuration. I want to hide any story that has sprint EMPTY (easy enough) and also any story that has 1 Sprint ID. This is the part I need help with. I only want to show rows where Sprint count > 1
Can you provide some guidance?
Please see screenshots.
Since you already have the Issue dimension on rows, you can access the issue property “Sprint IDs”.
You can look at that property as a list of references to the sprints, or you can look at it as a comma-separated list of numbers.
If you look for the issues with multiple sprints - you are looking for the lists with more than on entry. Since a coma separates multiple entries, you are actually looking for a comma in the property “Sprint IDs”.
Therefore, the expression to determine if the issue was related to multiple sprints might look as follows.
CoalesceEmpty([Issue].CurrentHierarchyMember.Get('Sprint IDs'),'') MATCHES '.*,.*'
--put here the actual calculation for the relevant issues
Since the “(no sprint)” has the ID of ‘-1’ and it is the only entry, this will also be excluded.
You might use this expression to filter rows based on measure values as described here - Create reports.
Alternatively, you might wrap other calculations within this condition to optimize the server load.
Oskars / support@eazyBI.com
This was very helpful. Thank you!