Median of Time to resolution / Time to first response

[strojna.ewa]

Hi,
i need to find a median for TTR and TTFR for every month (i keep month as Current member almost everytime).

I found a median() function, but it doesn’t work at all. I would really apprieciate two things:

1. Solution to write in measurement
2. Explanation

I’ve tried to use other topics to find a solution, but i just don’t get MDX

[roberts.cacus]

Hi @strojna.ewa,

The Median() function needs a numeric value and a set on witch the numeric value will be evaluated over. Use the Descendants() function to create a set of all the issues that were resolved in the current Time dimension period. Then you can define the numeric value. Please have a look at the example below:

Median(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
      [Issue].CurrentHierarchyMember.get('Resolved at'),
      [Time].CurrentHierarchyMember)
    AND 
      ([Measures].[Issues created],
      [Time].CurrentHierarchy.DefaultMember) > 0
  ),
-- time till resolution in minutes
 ([Measures].[Time to resolution Elapsed hours])
 * 60
)

This measure will display the median value of time till resolution for all the issues resolved in the time period currently selected in the Time dimension. I multiplied the measure “Time to resolution Elapsed hours” by 60, so you can use it with the Hours: Minutes formatting option. You can similarly create a calculated measure for TTFR.

Please have a look at the picture below on how it would look in a sample report:

Kind regards,
Roberts // eazyBI support

[strojna.ewa]

Thank you @roberts.cacus !