Fix Drill-In Issues in Zendesk Explore Reports
Learn why drill-in might not work in Zendesk Explore reports and how to fix it by adjusting NULL handling settings.
Why is drill-in not working in my Explore report?
Drill-in might not work if you're dealing with null values. By default, drill-in doesn't function on any custom attribute value of null. So, if you're trying to drill into a null value or a combination of values that includes at least one null, you'll encounter the 'No data available' error.
To fix this issue, you need to update the NULL handling logic in your report. Navigate to Result Manipulation > SQL options and change the 'Replace NULL by' setting to NULL. This should resolve the error and allow you to use drill-in effectively. For more details, check out the originalZendesk article.
More related questions
What does the 'No data available' error mean in Zendesk Explore?
The 'No data available' error usually means you're trying to drill into a null value. In Zendesk Explore, drill-in doesn't work on custom attribute values that are null. If your drill-in includes a null value, you'll see this error. To resolve it,…
How can I resolve null value issues in Zendesk Explore reports?
To resolve null value issues in Zendesk Explore, you need to adjust the NULL handling logic. Drill-in doesn't work on null values, which can cause errors. To fix this, go to Result Manipulation > SQL options in your report settings. Change the…
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 👇
