Replace Empty Cells with 0 in Zendesk Reports
How do I replace empty cells with 0 values in Zendesk Explore reports?
You can replace empty cells with 0 values by using the Result metric calculation feature. This is particularly useful for reports with attributes on both columns and rows.
To create a result metric calculation, go to the report builder, click on Result Manipulation, select Result metric calculation, and then click Add a new metric. Enter a name for your metric, and in the Formula box, select the metric you need and add "+0" to it. For example, use COUNT(Tickets)+0. When finished, click Clear used metric checkbox and then +Add.
More related questions
How can I include 0 values in time-based reports in Zendesk Explore?
To include 0 values in time-based reports, you can use the Time axis result manipulation feature. This feature helps fill in NULL value dates that exist between the earliest and latest non-NULL value dates. To enable the Time axis, go to the report…
Why are some columns not showing in my Zendesk Explore report?
Columns with all NULL values will not show by default in Zendesk Explore. This is because Explore handles NULL values and zeros (0) differently. If you want to display columns with 0 values, ensure that the cells have zero as their value rather…
Can I show all hours in a time-based report even if some have 0 values?
To show all hours in a time-based report, you can use the Time axis feature, but it only works with date fields and not with custom attributes like 'Days of Week'. If you want every hour from 0-23 to display, ensure that you are using a default…
Is there a way to display rows with all 0 values in Zendesk Explore?
Currently, there is no native way to display rows with all 0 values in Zendesk Explore. If a row has all NULL values, it will not be shown by default. While you can use the Result metric calculation to replace NULL values with 0, this will not work…
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.
