Question
Can 0 values be filtered when using time metrics and MED (median) as an aggregator?
Answer
A time metric could return 0 values for an account if these times are close to 0. As a numeric value, this aggregator separates the higher half of a set from the lower half, and can result in a 0 value.
For example, if the values show [ 0, 0, 0, 3, 5 ] and the median value is 0, a time metric filter wouldn't be suitable. Instead, create a standard calculated attribute using this formula:
IF (VALUE(Requester wait time (min)) = 0)
THEN "0"
ENDIF
After this formula is created, add it as a filter to your report and set it to exclude 0 values.
Disclaimer: This article is provided for instructional purposes only. Zendesk does not support or guarantee custom formulas. Post any issues you have in the comments section or try searching for a solution online.
For more information, see the following articles: