image for site

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