image for site

Resolving Null Value Issues in Zendesk Explore

Learn how to fix null value issues in Zendesk Explore by adjusting NULL handling settings to avoid drill-in errors.

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 'Replace NULL by' setting to NULL. This adjustment should help you handle null values effectively and avoid errors when using 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,…

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

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