Creating queries

A query is a request for information from your Zendesk data. For example, you might want to ask "How many support tickets do I have that are in an open state?". With Explore, you can create and store multiple queries in the queries library. You can then arrange these queries on dashboards which you can share with others.

This topic shows you how to create a new, blank query using two different methods. For help performing other operations with queries like cloning, deleting, and renaming them, see Working with queries.

This article contains the following sections:

• Creating queries from the queries library
• Creating queries from datasets
• Creating queries from dashboards
• Next steps

Creating queries from the queries library

You can create a new query directly from the Queries library. The queries library includes all of your created and cloned reports. You must have added a dataset or duplicated a dashboard to add a query from the queries library (see Working with datasets or Cloning pre-built and shared dashboards).

To create a query

1. Click the Queries icon ().
2. Click the New query button.

   

3. Choose the dataset containing the information you want to use in your report.

   For help choosing a dataset, see Working with datasets.

   

4. Click New query.

Query Builder opens a new query using the dataset you chose.

Creating queries from datasets

You can create new, blank queries from a dataset. To add queries from a dataset, you must connect to a Zendesk Support dataset (see Choosing and creating datasets or Cloning pre-built and shared dashboards).

To create a new query from a dataset

1. Click the Dataset library icon ().
2. Hover over the dataset you want to create a query from.
3. Click the Settings icon to the right of the dataset name.
4. Select New query from this... from the drop-down list.

   

   Query Builder opens with a blank query using the dataset you chose.

Creating queries from dashboards

While you are creating a dashboard, you can start a new query directly from the dashboard builder. For help creating dashboards, see Creating dashboards and Adding queries to dashboards.

To create a query from a dashboard

1. Make sure that the dashboard you have opened is in edit mode. In the dashboard customization menu of Dashboard builder, click Add
2. From the drop-down list, select Add query.

   

3. On the Add query page, click New query.
4. Choose the dataset containing the information you want to use in your report.

   For help choosing a dataset, see Working with datasets.

   

5. Click New query.

If you need help creating a query, follow the articles in the Building queries section.

Next steps

• Adding metrics and attributes
• Customizing queries