I have Epics with following workflow: New- Defined- In Dev- In Test- Approved
I have User Stories in the following workflow: New- Defined- In Dev- In Test- Approved
I have following scenario: I have 2 Epics:
Epic A- (In Dev State) has 4 User Stories. 2 of the User Stories are at Approved and 2 at Defined state. Approved User Stories are 10 points combined (5 each) and Defined user Stories are 8 points combined (5 & 3 each).
Epic B (In Test State) has 2 User Stories. 1 of User Story is In Test & 1 In Approved state. User story in test is 5 points and Approved state story point is 13 points
Note that anything at Approved state is Done & any other state such as New, defined, In dev, in test are In Progress
In the example above:
Epic A is 56% (10/18) Done & 44% (8/10) In Progress
Epic B is 72 % (13/18) Done & 28% (5/18) In Progress
I am trying to see a view of my epics in the following way under 1 view for the executive team:
||Epic % of Done
||Epic % of in Progress
||Epic Done Story Points
||Epic In Progress Story Points
welcome to eazyBI community!
You can use the Epic hierarchy from Issue dimension. Using this hierarchy, totals of issues per selected epic, including from the issue sub-tasks, are calculated in the report.
This means you can use predefined measure Story Points created to see total story point count per Epic.
Then create a measure for your approved stories using tuple in Measure dimension (in my example I am using status “Done”).
[Measures].[Story Points created],
Then for issues still in progress use this formula:
[Measures].[Story Points created]-[Measures].[Story Points Done]
To check the result I added also Issue properties to the report. As you can see issue DEMO-155 is an Epic in status Done and have 20 Story points, also it has with 2 stories from which one is in Done status and other in To do. The formula aggregates the result at Epic level from the Epic itself and the Story in Done status:
If you want to create a percentage, you can create a new measure that refers to the previous ones (on a similar base you can create % for story points in progress):
CASE WHEN [Measures].[Story Points created] > 0
[Measures].[Story Points Done] / [Measures].[Story Points created]
The result would be like this:
Gerda // firstname.lastname@example.org