Exclude 0 Values from Median Aggregator in Zendesk
How can I exclude 0 values from a median aggregator in Zendesk?
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, 3, 5], the median would be 0. To filter out these 0 values, create a standard calculated attribute with the formula:
IF (VALUE(Requester wait time (min)) = 0) THEN "0" ENDIFAdd this attribute as a filter to your report and set it to exclude 0 values. For more details, check out the originalZendesk article.
More related questions
Why do 0 values appear in median calculations in Zendesk?
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…
What formula can I use to filter out 0 values in Zendesk reports?
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" ENDIFThis formula helps you create a filter that excludes 0 values from your report,…
Can I get support for custom formulas in Zendesk?
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…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
