So, I’ve created a report with “Fix Version” (Rows) and “Measures” (Columns). I’ve created a calculated member to aggregate a number of Fix Versions (e.g. APRIL-SAP, APRIL-SFDC, etc). I achieved this using the following:
For the Measures, I have some custom measures as well, to aggregate all Story points with certain Statuses (and the same for the number of Stories). Achieved this way:
Now…some Stories have more than one Fix Version populated and so I’m getting a double count. Is there a way to just could to avoid this (by somehow looking at the Story ID or something and de-dup)?
Since “Fix Version” is dimension created from Jira releases (which is a multi-value field in Jira) there could be double counting in your specific report layout if one issue is assigned to more than 1 version from the Aggregated Fix Version set.
You could quite easily fix the calculation for “Issues created” by replacing it with a distinct measure “Issues created count”, however, there is no such substitute for “Story points created”.
This calculation would become more complex but it is possible to calculate your expected results anyway.
Try these codes instead:
Aggregate({
[Status].[Done],
[Status].[In Release Preparation],
[Status].[Ready for Deployment],
[Status].[Closed]},
[Measures].[Issues created count])
Hello, I’d like to create a similar hours spent measure that removes the double counting if there are issues with multiple fixed versions. Currently, when I would like to report the number of hours spent specific fixedVersions, but due to some issues with multiple fixed versions, those issues are double counted so the hours spent are actually more than they should be. Can you please help me with the code for this?