I’m trying to get median of closed tickets. I want to use IM Issues Closed, a calculated member, with the formula:
NonZero([Measures].[Issues resolved count]
- [Measures].[IM Issues Resolved - dupe]
- [Measures].[IM Issues Resolved - test_tkt])
Hi @Timi,
For the median of closed issues in the context of the dimension members in rows, use the standard calculation “Statistical” option - Add standard calculations.
If you require median closed days in each month, then a more complex calculation will be necessary. Please review the Median()function documentation for an insight - Median. Let me know if that is the case.
Best,
Roberts // support@eazybi.com
I’ve tried everything in the documentation for median for each month and it all doesn’t work. I have a measure [Measures].[IM Total closing days] that works in my mean calculation:
[Measures].[IM Total closing days] / [Measures].[IM Issues Closed]
But when I try to use it in a Median function, I get either:
-
Date format output (mmm dd yyyy) instead of numbers, OR
-
Error: “Expected value of type NUMERIC; got value DATETIME”
How do I access the individual issue’s resolution days (as a number) to use in the Median function?
Hi @Timi ,
Share the formula you tried for the Median() calculation. In the case you retrieve (mmm dd yyyy) in the result, specify the calculated measure formatting to explicitly tell it to use decimal - Calculated measures.
This happens because eazyBI tries to guess the correct formatting based on the measures and properties used in the calculation. Sometimes, when using date properties, eazyBI makes the wrong guess and uses the date formatting instead of a numeric one.
Best,
Roberts // support@eazybi.com