A query is a request for information from your Zendesk data. For example, you might want to ask "How many open support tickets do I have?"
In Explore, users with the Admin or Editor role can create and store multiple queries in the queries library. You can then arrange these queries on dashboards, which you can share with others.
Related articles
Creating a query
In Explore, you can create a query from three different places: the queries library, a dataset, and a dashboard.
Creating a query 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 Explore dashboards).
To create a query
- Click the Queries icon (
).
- Click the New query button.
- Choose the dataset containing the information you want to use in your report.
For help choosing a dataset, see Working with datasets.
- Click New query.
Query builder opens a new query using the dataset you chose.
Creating a query from a dataset
You can create new, blank queries from a dataset. To add queries from a dataset, you must connect to a Zendesk Support dataset (see Working with datasets or Cloning Explore dashboards).
- Click the Dataset library icon (
).
- Hover over the dataset you want to create a query from.
- Click the Settings icon to the right of the dataset name.
- Select New query from this... from the drop-down list.
Query builder opens with a blank query using the dataset you chose.
Creating a query from a dashboard
While you're 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
- Make sure that the dashboard you have opened is in edit mode. In the dashboard customization menu of the dashboard builder, click Add
- From the drop-down list, select Add query.
- On the Add query page, click New query.
- Choose the dataset containing the information you want to use in your report.
For help choosing a dataset, see Working with datasets.
- Click New query.
If you need help creating a query, follow the articles in the Building queries section.
Adding metrics to your query
Metrics are quantifiable values, such as the number of tickets, replies to tickets, and agent or customer wait times. You must add at least one metric to your query.
To add a metric
- In the Metrics panel, click Add.
- From the list, select the metric you want to add. You can expand or collapse the
folders to show or hide specific metrics.
- Click Apply. Your metric results automatically appear in your query.
Explore automatically uses the most suitable aggregator for the metric. However, you can change the aggregator by clicking the metric and selecting a new aggregator. See Changing metric aggregators.
You can also select whether the metric results are measured in different sizes or colors, on a separate axis, or as datatips. See Using metrics and attributes in queries.
Adding attributes to your query
Attributes slice your data by non-quantifiable values, such as ticket ID, ticket tags, and assignee names. They can also be used to select or exclude results from your chart. You can add one or multiple attributes to a query, or none at all.
-
Columns renders your results in one chart. See Adding attributes to columns.
-
Rows renders your results into individual charts or tables for each of your attribute values by using a row selector. See Adding attributes to rows.
-
Explosions renders your results into multiple charts, each representing a different value for the added attributes. Charts are shown side-by-side in one query. See Adding attributes to explosions.
- Filters restricts which results are shown without the attribute appearing on your query. See Adding attributes as filters.
To add an attribute
- In the Columns, Rows, Explosions, or Filters panel, click Add.
- From the list, select the attribute you want to add. You can expand or collapse the
folders to show or hide specific attributes.
- Click Apply. Your attribute results automatically appear in your query.
Saving your query
When you finish building your query, make sure to save it. Queries don't save automatically. If you navigate away from your query without saving, all changes will be lost.
To save a query
- In the query builder, make sure you've given your query a descriptive name. If you don't, Explore automatically names your query according to the metrics and attributes you've added.
- Click Save in the top-right corner.
8 Comments
Is there a way to create a query with how long the article views were?
Hi Laura Mirto, that's not currently possible with Explore, but you might be able to use Google Analytics to get a reasonable approximation of this.
It's also a great suggestion to add to our product feedback section (see link in the post above).
Thanks!
Is there a way to build a query of the number of end-users at a specific date? I can see a count of users under People, but I can not choose a date. Example: I want to know how many end-users we had on May 1st. I pulled a report for user data to use the created date, however, the number of users currently is a few hundred off from the count under People, so now I do not trust the report.
Any ideas?
Hi Melody,
Are you trying to create a query to show the number of end-users created on your account or the number of end-user tickets created for a specific date?
Unfortunately, there is no native way to capture the number of end-users created iin Explore. However, if you would like to capture the end-user created tickets, you can use the recipe: Explore recipe: Reporting on created and solved tickets and use the filter>ticket requester and requested date to see the list of end-users
All the best
hi @..., I was looking for the total number of end-users, completely independent of the ticket data. As we are growing our self-service support, it is important for us to know the number of new end-user accounts each month.
Hi Melody,
The possible workaround is to use the Filter: Requester Created - Date on your report, so you can view the list of created users on a specific date.
We understand your need for this functionality so I am marking this conversation as Product Feedback. We truly value customer feedback and your voice and votes in the forums help influence future Zendesk functionality.
Hi ZenDesk Support Team,
Is it possible to export metadata of tickets from ZD and import this data into another API dashboard thats not ZD?
-Mike
Hi Michael –
Zendesk integrates with several third-party dashboard products, such as Geckoboard, ClicData, Cyfe, Slemma, and more -- here's a search in the Marketplace for "dashboard": Zendesk Apps Marketplace.
Is that what you're looking for?
Please sign in to leave a comment.