In this simple Explore recipe, you'll learn how to create an Explore query that displays your top ten Talk numbers in order of how often they have been used this week.
For more information about adding Talk numbers, see Adding Zendesk Talk numbers.
What you'll need
Skill level: Easy
Time required: 15 minutes
- Zendesk Explore Professional
- Editor or Admin permissions (see Adding users to Explore)
- A subscription to Zendesk Talk
Creating the query
To create the query
- In Zendesk Explore, click the query ( ) icon.
- In the Queries Library, click New Query.
- Now, select a dataset containing the Talk data you'll need to build the query.
Select Zendesk Talk.
Query Builder opens.
- Next, add a metric. A metric is the thing you want to measure, in this case, the number of tickets.
In the Metrics panel, click Add.
- In the metric list that appears, expand Calls, click Calls, and then click Apply.
- Next, add the call Talk numbers attribute that will break down the number of calls by phone number.
In the Rows section, click Add.
- In the attribute list that appears, expand Call, click Call Talk number, and then click Apply.
This generates a table of all Talk calls sorted by phone number.
- Now, add a date filter to show only results from this week. In the Filters panel, click Add.
- Expand Time - Call started, click Call - Date, and then click Apply.
- In the Filters panel, click the Call - Date filter.
- On the Call - Date page, click Edit date ranges.
- On the Date range page, click This week, then click Apply.
You'll now see a list of all of your Talk numbers, and the number of calls for each. In the next steps, you'll learn how to display only the top ten numbers.
- From the result manipulation menu (), click Top/bottom.
- On the Top/bottom page, select Top.
- In the Top field, enter 10, then click Apply.
You're done! Explore now displays a table showing your top ten Talk numbers based on calls they have handled.
You can click the column headings to sort the results into order.