Calculate median without 0-values

Hi,

Thanks for the response. I actually tried that already but it didnt work for me. 

I tried it first with data sorted by ticket ID, it worked good. This is result without filtering:

This is result after filtering:

So there it goes well. But when using median without filter it gives me 0

With Filter I'm expecting to see around 2 minutes and 23 seconds but what I see is just blanc white report

Hi, 

I have the same problem. I want to display a KPI of a median for "Requester wait time" excluding 0 from calculation but it's seems impossible... 

Hi @... and @...,

I can confirm this flow won't work for time metrics. 

For those metric, you will need to create a calculated attribute using this formula 

IF (VALUE(Requester wait time (min)) =0)
     THEN "0"
ELSE IF (VALUE(Requester wait time (min)) =NULL )
     THEN "NULL"
     ELSE "OK"
ENDIF ENDIF

Then add this new attribute to Filters in your query and filter out "0" and "null"

It will return the result you expect. If you don't intend to filter out zeros, you can edit that part of the formula and only leaves the Null part of it.

Please feel free to ask any questions you may have.

Hope you have a great week,

Thanks Daniel, this works great for me!

I've noticed the approach of making a calculated attribute works well if your report only has one metric, but doesn't work as well if you have multiple metrics since excluding the 0 values will exclude the entire ticket and therefore exclude it from other metrics. Another approach is to just return a null value for that particular metric by using a calculated metric as shown here: 

IF (VALUE(On-hold time - Business hours (min)) = 0)
THEN 
  NULL 
ELSE 
 (VALUE(On-hold time - Business hours (min)))
ENDIF