image for site

Understanding 'No Data Available' in Zendesk Explore

Discover what causes the 'No data available' error in Zendesk Explore and how to fix it by adjusting NULL settings.

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, adjust the NULL handling logic in your report. Go to Result Manipulation > SQL options and set 'Replace NULL by' to NULL. This change should help you avoid the error and successfully use drill-in.


More related questions

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

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