Hello all
I’m trying to replicate the attached graph in EazyBI that shows mean and median cycle time.
We already have a calculated field that shows Cycle Time in seconds, so I just need to calculate the Mean & Mode.
Any help would be greatly appreciated, thanks!
Hi,
There are dedicated standard functions in the MDX language for the calculation of the average and median.
The functions require the issue set over which to calculate the result. For instance, if we wish to have the calculation for the issues having non-zero cycle time in the period, the formulas are the following:
Avg(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Cycle time measure]>0),
[Measures].[Cycle time measure]
)
Median(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Cycle time measure]>0),
[Measures].[Cycle time measure]
)
Kindly,
Janis, eazyBI support