Explore recipe: Calculate the percentage of inbound abandoned calls within a time frame

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: Intermediate

Time required: 10 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving agents access to Explore)
• Call data in Zendesk Talk

How to create the report in Explore

1. In 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. In the Calculations menu (), click Standard calculated metric.
5. On the Standard calculated metric page, enter or paste the following formula:

   IF ([Call direction]="Inbound" 
   AND [Call completion status]="Abandoned in queue") 
   AND (VALUE(Call duration (sec))>0 
   AND VALUE(Call duration (sec))<=20) 
   THEN [Call ID] ENDIF

6. 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. 
   
   Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language.
7. 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.
   
8. In the Metrics panel, click Add, and then choose the default metric "Inbound Calls".
   
9. In the Result manipulation panel, click Result metric calculation, then click Add new metric.
10. 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)

11. Check the box Clear used metrics, and then click Apply.
    

12. In the Chart configuration menu, click Display format and select % for the metric created in Percentage of abandoned calls in queue within 20 sec.
    

13. Make sure the visualization type is either Auto or KPI, then save the query.