How can I exclude 0 values from a median aggregator?

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. TyrellCorp 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:

• Using average or median aggregators
• Creating standard calculated metrics and attributes: Hands-on tutorial