I am trying to put together a report that will show percentage of parent issues (ie not including sub-tasks) that were in the sprint when it was started (ie not added at a later date) and that were completed by the end of the sprint. So, if I had tickets FOO-1, FOO-2, and FOO-3 in a sprint at the time it was started, but only FOO-1 and FOO-2 were moved to “Done” by the end of the sprint, the calculated measure would display “66%”.
Hi @dave ,
Try defining a new calculated measure that iterates through all committed parent issues and sum the number of the completed ones. See the formula below:
Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
-- issue doesn't have a parent issue (is not a sub-task)
IsEmpty([Issue].CurrentHierarchyMember.Get('Parent issue key'))
AND
-- was committed to the Sprint
[Measures].[Sprint issues committed] > 0
),[Measures].[Sprint issues completed]
)
The report then could look similar to the one below:
See the eazyBI documentation page for more details on defining calculated measures - Calculated measures and members - eazyBI for Jira.
Best,
Roberts // support@eazybi.com