image for site

Exclude 0 Values from Median Aggregator in Zendesk

Learn how to exclude 0 values from a median aggregator in Zendesk by creating a calculated attribute.

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" ENDIF

Add 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?

Our AI customer support agent is here to help. Trained on all your help docs, installed directly into your Zendesk account, it can be used to automate customer replies for tickets or live chat. Learn more below.
Zendesk logo

Zendesk Support Tickets

Receive new tickets by email or a support form? This integration is for you.
My AskAI integrated within Zendesk to deflect support tickets
Learn about our Zendesk ticket integration
Zendesk logo

Zendesk Messaging (live chat)

Using Zendesk's Messaging widget on your site for live chat? This integration is for you.
My AskAI integrated within Zendesk to deflect customer support live chat conversations
Learn about our Zendesk Messaging integration

Join1,000+ companies reducing their support costs and freeing up support agents for more important work

Vestd company logo — Customer of My AskAI's AI customer support agents
Genesis company logo — Customer of My AskAI's AI customer support agents
Zinc company logo — Customer of My AskAI's AI customer support agents
Customer.io company logo — Customer of My AskAI's AI customer support agents
Zeffy company logo — Customer of My AskAI's AI customer support agents
NHS company logo — Customer of My AskAI's AI customer support agents
Kontakt.io company logo — Customer of My AskAI's AI customer support agents

Reduce support costs.Spend more time on customer success.

Our AI customer support agents are already used by 👇
Companies using AI assistants on their websites