image for site

Using SQL to Filter Reports - Frequently asked questions

Discover how to effectively use SQL to filter reports in Zendesk. This page answers common questions and provides insights into optimizing your report filtering process.

Frequently asked questions

How can I use SQL to filter reports in Zendesk Explore?

You can use SQL to filter reports in Zendesk Explore for more advanced data manipulation. Instead of using the standard Metrics, Columns, Rows, and Filters panels, you can access the SQL options panel for fine-grained control. To use SQL, create…

What are the benefits of using SQL options in Zendesk Explore?

Using SQL options in Zendesk Explore offers advanced users more control over their reports. It allows for specific data manipulation that goes beyond the capabilities of the standard interface. With SQL options, you can apply custom filters, sort…

How do I construct a SQL query in Zendesk Explore?

Constructing a SQL query in Zendesk Explore involves using the SQL options panel to define specific clauses. This process allows for detailed customization of your report data. To construct a query, access the SQL options from the Result…

Can I replace NULL values in Zendesk Explore reports using SQL?

Yes, you can replace NULL values in Zendesk Explore reports using the SQL options panel. This feature helps improve the readability of your reports. When constructing your SQL query, you have the option to replace NULL values with a specified…

What is an example of using SQL options for agent performance analysis?

Using SQL options for agent performance analysis in Zendesk Explore allows you to create detailed reports based on specific criteria. For instance, you can analyze agents based on their average resolution time. To do this, create a report using…

When should I use SQL options in Zendesk Explore?

SQL options in Zendesk Explore should be used when you need advanced filtering, sorting, or limiting capabilities that the standard interface cannot provide. This feature is particularly useful for custom filtering, complex sorting requirements,…

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