Zendesk does not officially support or guarantee custom formulas, but you can seek help in the community.
While the article provides a formula to exclude 0 values, it's meant for instructional purposes only. If you encounter issues, consider posting in the comments section of the article or searching online for solutions.
To exclude 0 values from a median aggregator in Zendesk, you need to create a calculated attribute. When using time metrics, 0 values can appear if the times are close to 0, affecting the median calculation. For instance, if your data set is [0, 0,…
0 values can appear in median calculations when using time metrics in Zendesk because these times might be close to 0. The median aggregator separates the higher half of a set from the lower half, and if your data set includes several 0 values, the…
To filter out 0 values in Zendesk reports, use a calculated attribute formula. The formula you need is:IF (VALUE(Requester wait time (min)) = 0) THEN "0" ENDIF
This formula helps you create a filter that excludes 0 values from your report,…