I have a use case where users want a report that shows each Parent, the number of total points, the number of resolved points, and a percentage. But they want it broken down by Sprint to show the number of points completed in the sprint / the total number of points in the parent.
Hi @briantaylor,
You can start off with the Issue dimension “Parent” hierarchy in the report rows. There, select the desired level members to display in the report rows. Add the “Story Points created” and “Story Points resolved” measures to view the total numbers. For the percentage, define a new calculated measure with the following formula:
CASE WHEN ([Measures].[Story Points created],[Sprint].CurrentHierarchy.DefaultMember) > 0
THEN
[Measures].[Story Points resolved]
/
([Measures].[Story Points created],[Sprint].CurrentHierarchy.DefaultMember)
END
Drill this calculated measure into the Sprint dimension “Sprint” level - Create reports. Add other dimensions into pages to filter the desired view. I created another calculated measure with the same formula to view the total percentage. The report could look similar to the one below:
Best,
Roberts // support@eazybi.com