In this recipe, you'll learn how to create a report that shows the percentage of inbound calls that were abandoned during a time frame you specify.
What you'll need
Skill level: Easy
Time required: 5 minutes
- Zendesk Explore Professional
- Editor or Admin permissions (see Adding users to Explore)
- Call data in Zendesk Talk
How to create the report in Explore
- In Explore, click the query () icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Talk > Calls > Talk: Calls, then click Apply.
Query Builder opens.
- In the Calculations menu (), click Standard calculated metric.
- On the Standard calculated metric page, enter or paste the following formula:
IF ([Call direction]="Inbound"You could also use "Call raw wait time" instead of "Call raw talk time" to categorize the calls based on the time that end-users spend waiting during a call.
AND [Call completion status]="Abandoned In Queue"
AND VALUE(Call raw talk time (sec)) >0
AND VALUE(Call raw talk time (sec))<=20)
THEN [Call ID]
- Name the calculated metric "Calls abandoned in queue within 20 sec" and save it. The metric returns the [Call ID] for: Inbound calls that were Abandoned in queue with a Call talk time that is 20 sec or less.
- In the Metrics panel, click Add, and then choose "Calls abandoned in queue within 20 sec". Make sure to select the D_COUNT aggregator and then click Apply.
- In the Metrics panel, click Add, and then choose the default metric "Inbound Calls".
- In the Result manipulation panel, click Result metric calculation, then click Add new metric.
- Name the metric Percentage of abandoned calls in queue within 20 sec and using the Insert metric drop down menu, select both metrics from step 5 and 6 to obtain the following one:
D_COUNT(Calls abandoned in queue within 20 sec)/D_COUNT(Inbound calls)
Check the box Clear used metrics, and then click Apply.
In the Chart configuration menu, click Display format and select % for the metric created in Percentage of abandoned calls in queue within 20 sec.
Make sure the visualization type is either Auto or KPI, then save the query.