I’m trying to create a report that lists the counts of issues that do not link to a story issue type.
I am having trouble creating a measure that will sum all empty squares in a column for the given hierarchy, see image.
I’ve created a simple measure to set all of the empty squares to 1, though this does not sum correctly
Any help on this would be greatly appreciated, thank you!
I recommend defining a calculated measure that determines the Issue dimension current level in such a case. In the “Issue” level, it should return the measure “Issues created” when it is not linked. At a “Project” or “All” level, it should sum up all the issues without the link. The formula could look similar to the one below:
CASE WHEN [Issue].CurrentHierarchyMember.Level.Name = "Issue"
I used the issue link “Caused Bugs”. Update the formula to fit your use case. After that, the report could look similar to the one below:
I also recommend using the “Drill into measure by another dimension” functionality to have only the relevant measures distributed across columns - Create reports.
Roberts // email@example.com