Create story point completion progress percentage

Questions & Answers
1

I have imported JIRA in easyBI for reporting
I want to create a report based on this hierarchy

image
image1002×351 18.6 KB

The last column should be

(Story Points resolved for this label / Total story point created for that label) * 100

Any tips are appreciated to fix this last column:

Aggregate(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
([Measures].[Story points created],
[Label].[pi-sensitivity])>0
),
[Measures].[Story Points created]
)

2

Any help is appreciated!

3

Hi @pbaweja
Welcome to eazyBI community!

I recommend using the CASE statement (CASE statement) with Tuples (Tuple) and see if it works for you? If you’d like to see this as in percentages, please choose the correct formatting (Calculated measures) before saving the calculated measure.

CASE
WHEN
(
[Measures].[Story Points created],
[Label].[pi-sensitivity]
)>0
THEN
CoalesceEmpty(
(
[Measures].[Story Points resolved],
[Label].[pi-sensitivity]
),
0)/
(
[Measures].[Story Points created],
[Label].[pi-sensitivity]
)
END

Best wishes,

Elita from support@eazybi.com