How to calculate Median Days in Transition Status

Questions & Answers
1

Hello Community,

I am new to eazyBI and would appreciate your past experience to help me with

How to calculate Median Days in Transition Status for Issues

I did notice eazyBI provides a Measure of Average Days in Transition Status but looking for Median Days.

Thank Youi

2

Hi,

There is a standard function of the median in the MDX language, and you can create your custom measure for median calculation.

The following formula would do that:

Median(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Transitions from status]>0
  ),
  [Measures].[Days in transition status]
)

Kindly,
Janis, eazyBI support

1 Like
3

thank you… we are continuously learning. the eazyBI community is a great site for sharing and collaboration

1 Like
4

Hi
I am trying to use the Median formula above but the query times out (after 60 seconds).
I am filtering issues of a specific team in the last 6 months.

5

Hi,

Please, send the report definition to our support email. We will check if there could be options for the optimisation.

Kindly,
Janis, eazyBI support

6

Hi Janis, thank you and I have sent an email to support@eazyBI with the report definition.