Percentile for Cycle Time per Sprint

Questions & Answers
, , ,
1

I am trying to calculate 50th Percentile for Cycle Time for Sprint based on Transitions

For Cycle Time per Sprint using below measure
CASE WHEN
[Measures].[IssuesCountAllTransitionStatus] > 0 THEN
[Measures].[days in transition status]/
[Measures].[IssuesCountAllTransitionStatus]
END

For calculating 50th Percentile for Cycle Time per Sprint using below formula but not getting the values
Cache(NonZero(Percentile(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue resolution date],
[Time].CurrentHierarchyMember
)),
CASE WHEN
[Measures].[IssuesCountAllTransitionStatus] > 0 THEN
[Measures].[days in transition status]/
[Measures].[IssuesCountAllTransitionStatus]
END
, 50 )
))

Please Suggest.
Thanks & Regards
Raju

2

Hi @Nagaraju_T

The formula for the Percentile seems correct.

You can check out a similar report here in our demo account: Control chart (Cycle Time) - Issues - Jira Demo - eazyBI

You should try selecting individual issues in Rows together with the “Cycle Time per Sprint” to see if this measure returns results for individual issues. I can’t comment on the results of this measure as it seems to reference two other custom measures that may have formulas that are not properly working in your context.

Start by troubleshooting the custom measures themselves and understanding if they return values in all cases. The Percentile formula looks good, so the issue here is with the underlying formulas.

​Best regards,
​Nauris