I want to create a new calculated measure in easybi such that: #1 It does summation of the story points of all EPICs under an initiative #2 Does summation of all story points of only completed EPICs under the initiative #3 It then divides the value we get in #2 with #1 and should shows result in percentage.
PS-
This calculation should be done only at Initiative level, the cells corresponding to the Epics and Stories should remain blank under this calculated measure.
Story Points assigned to stories shouldn’t be considered
When you have the hierarchy set up, you can select the Issue dimension in Rows and select the Initiative level to show the Initiatives in rows.
For measure #1, use this formula:
CASE WHEN
[Issue].CurrentHierarchyMember.Level.Name = "Initiative"
THEN
Sum(
ChildrenSet(
[Issue].CurrentHierarchyMember
),
(
[Measures].[Story Points created],
[Issue Type].[Epic]
)
)
END
For measure #2 this formula (it will check if the Epic is in one of the statuses that are in the status category “Done” in your Jira):
CASE WHEN
[Issue].CurrentHierarchyMember.Level.Name = "Initiative"
THEN
Sum(
ChildrenSet(
[Issue].CurrentHierarchyMember
),
(
[Measures].[Story Points created],
[Issue Type].[Epic],
[Status.Category].[Done]
)
)
END
I created Measure1(formatting as integer), Measure2(formatting as integer) & Measure3(formatting as integer percentage) with the MDX Code you provided in your last reply.
I then imported Measure1, Measure2 & Measure3 in my report
Alas ! I am not getting any data under Measure1, Measure2 & Measure3 column in my report.
The code that @nauris.malitis shared works for scenario if story points are entered directly at the epic level in Jira project, which can be the case.
In some other scenarios, the story point value is entered at the story level, and then a different approach is required to calculate results in eazyBI reports.
