Include 0 Values in Reports - Frequently asked questions
Discover how to include 0 values in Zendesk reports. This page answers common questions and provides guidance on handling zero values in your data reports.
Frequently asked 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…
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…
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…
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 Support Tickets
Receive new tickets by email or a support form? This integration is for you.
Learn about our Zendesk ticket integration
Zendesk Messaging (live chat)
Using Zendesk's Messaging widget on your site for live chat? This integration is for you.
Learn about our Zendesk Messaging integration
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.”
“Our company is growing very rapidly, and we were receiving a lot of support requests. And our team was spending a huge amount of time on them. Now, our AI agent is resolving 84% of customer support conversations.”
Ella Roy Customer Success Manager
Zeffy
Zeffy
Read Zeffy's case study
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
“Since implementing My AskAI, the AI agent has deflected at least 68% of all customer queries. This has allowed us to get our average human response time down to under 60 seconds. A goal we've had for the last 6 months and finally achieved now with My AskAI.”
Conrad Jones CX and Service Leader
Zinc
Zinc
Read Zinc's case study
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
"My AskAI’s Zendesk integration is saving our support agents over 35 hours per week. A massive win for the team and mitigating hundreds of hours of combined waiting time for customers. We are very pleased with the results — which have allowed us to reinvest bandwidth into other strategic areas."
Natalie Onions VP of Customer Experience
Customer.io($50M+ ARR)
Customer.io($50M+ ARR)
Read Customer.io's case study
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
"My AskAI's Intercom integration stood out not only because of its impressive answer accuracy but also because of how well it worked within our existing Intercom setup. The combination of precision and effortless setup made it invaluable."
Howard Blick Customer Service Team Lead
Freecash
Freecash
Read FreeCash's case study
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
“Our company is growing very rapidly, and we were receiving a lot of support requests. And our team was spending a huge amount of time on them. Now, our AI agent is resolving 84% of customer support conversations.”
Ella Roy Customer Success Manager
Zeffy
Zeffy
Read Zeffy's case study
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
“Since implementing My AskAI, the AI agent has deflected at least 68% of all customer queries. This has allowed us to get our average human response time down to under 60 seconds. A goal we've had for the last 6 months and finally achieved now with My AskAI.”
Conrad Jones CX and Service Leader
Zinc
Zinc
Read Zinc's case study
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
"My AskAI’s Zendesk integration is saving our support agents over 35 hours per week. A massive win for the team and mitigating hundreds of hours of combined waiting time for customers. We are very pleased with the results — which have allowed us to reinvest bandwidth into other strategic areas."
Natalie Onions VP of Customer Experience
Customer.io($50M+ ARR)
Customer.io($50M+ ARR)
Read Customer.io's case study
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
"My AskAI's Intercom integration stood out not only because of its impressive answer accuracy but also because of how well it worked within our existing Intercom setup. The combination of precision and effortless setup made it invaluable."
Howard Blick Customer Service Team Lead
Freecash
Freecash
Read FreeCash's case study
Reduce support costs.Spend more time on customer success.
Our AI customer support agents are already used by 👇
