Median of issues

Tomasz_Smolinski · November 20, 2018, 12:24pm

Hello,
We would like to get median in such calculation

We have issues and column that calculates what is time between status transition from backlog till done. Question is how to calculate median of it. Tried to follow few cases with same question but without success.

Thanks in advance for help.

martins.vanags · November 23, 2018, 4:32pm

Hi,

I guess the median should be calculated to higher (not issue) level - perhaps on Project level

To calculate the median value from your given measure, you could try creating a new calculated member in “Measures” dimension using the following code (assuming that Done-Backlog is a measure in your case):

NonZero(
Median(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Done-Backlog]>0
),
[Measures].[Done-Backlog]
)
)

Martins / eazyBI support