Explore recipe: Displaying the number of calls transferred to a group

In this Explore recipe, you'll learn how to create a query that displays the number of Talk calls that were transferred to a group.

What you'll need

Skill level: Easy

Time Required: 15 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Adding users to Explore)
• A subscription to Zendesk Talk

How to create the report in Explore

1. In Zendesk Explore, click the query ( ) icon.
2. In the Queries library, click New query.
3. On the Choose a dataset page, click Talk > Calls > Talk: Calls, then click New query. Query builder opens.
4. 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.
5. From the list of metrics, choose Calls > Calls, then click Apply.
6. Next, add the attribute that will specify the consultation type. In the Columns section, click Add.
7. From the list of attributes, choose Call leg > Leg consultation type, then click Apply. Explore generates a table of all Talk calls sorted by phone number. Unattended transferred calls are the number of calls that were transferred to another agent without the consultation phase. For more information about transferring calls, see the article: Transferring calls (Talk Team, Professional, and Enterprise).
8. Next, add the attribute that will break down the number of transferred calls by group. In the Rows section, click Add.
9. From the list of attributes, choose Call > Call group, then click Apply. Explore generates a table of all Talk calls sorted by phone number.
10. By default, Explore chose a table chart to best display the data. To change this, click the Visualization type () icon.
11. The query was, by default named New query. Click the New query text and replace it with a title of your own.
12. Finally, click Save.