This recipe will help you create a report to measure inbound or answered calls by associated wait time or SLA purposes.
Skill Level: Advanced
Time Required: 10-20 minutes
Ingredients:
- Three custom metrics
- Three additional percentage custom metrics
- One custom report
This article contains the following sections:
- Creating your custom metrics
- Creating and customizing your report
- Adding percentage calculations (Optional)
- Reordering and relabeling metrics
Creating your custom metrics
The first step for analyzing your inbound calls by wait time data is to create custom metrics that show the number of calls falling into each SLA bucket. You will need to create three custom metrics, based on your different SLA times.
To create your custom metrics
- Click the Reporting icon (
) in the agent interface, then open the Insights tab.
- Click the GoodData link in the top right corner.
- Click Reports > Create Report.
- In the What panel, click the (advanced) link next to Add new metric.
- Select Custom metric.
- Name your first custom metric Inbound Wait Time < 10, then type the formula listed below:
Note: You cannot directly enter the formula. You must select the colored elements from the Elements panel, then click Add selected.
SELECT COUNT(Call, Records of Calls) WHERE Call Direction = inbound AND (SELECT SUM (Call Wait Time) BY Call) < 10
- Call, Records of Calls, and Call Direction are located in Attributes under Calls.
- inbound is located in Attribute Values > Calls, then select Call Direction.
- Call Wait Time is located in Facts under Calls.
- Click Add when finished.
- Create your second custom metric, Inbound 10 <= Wait Time <=30, using the formula below:
SELECT COUNT(Call, Records of Calls) WHERE Call Direction = inbound AND (SELECT SUM (Call Wait Time) BY Call) BETWEEN 10 AND 30
- Click Add.
- Create your third custom metric, Inbound Wait Time>30, using the formula below:
SELECT COUNT(Call, Records of Calls) WHERE Call Direction = inbound AND (SELECT SUM (Call Wait Time) BY Call) > 30
- Click Add.
Creating and customizing your report
After you create your custom metrics, you can then add them to your report. To analyze the percentage for each time bucket, you will need to customize your report. For more information on building custom Insights reports, see Building custom reports in Insights.
Creating your report
This section will instruct you on how to add your custom metrics to your report.
To add metrics to your report
- In your report, click the What panel.
- Select your metrics.
- Open the How panel, and select any attributes to slice your results.
- Click Done. Your report will resemble the image below:
Adding data labels
This section will instruct you on how to add data labels to your report, so you can view the exact results for each section. If you want to view the results as percentages, you will need to change the chart type to a pie chart or create new custom metrics for calculating percentages (see Adding percentage calculations).
To add data labels to your report
- Click Show Configuration in the upper-right.
- Click the + button next to Global Settings under Advanced Configuration.
- Check the Data Labels box.
- Click Apply.
To add percentage data labels
- Select the pie chart option from the chart list at the top of the page. It is not possible to show percentages with a bar chart without creating custom percentage metrics.
- Under Show Configuration > Advanced Configuration > Global Settings, check the Data Labels box.
- Under the Size drop-down list, check the As % box.
- Click Apply.
Adding percentage calculations (Optional)
If you would like to view your results as percentages in different chart type than pie, you will need to create additional custom metrics. You will need to create the custom metrics described in the Creating custom metrics section above before creating these metrics.
Additionally, you will need to edit the metric format to include the percentage symbol. This section will instruct you on how to perform both steps.
To create your percentage calculation metrics
- Follow the steps from the Creating your custom metrics section to navigate to the Custom metric editor.
- Enter the formula below for your first custom metric:
SELECT Inbound Wait Time < 10 / # inbound Calls
- Inbound Wait Time < 10 is a custom metric you previously created and can be found in Metrics under Unsorted, unless you have selected another folder for your custom metrics.
- # inbound Calls can be found in Metrics under Calls.
- Click Add, then create your second custom metric, using the formula below: SELECT Inbound 10 <= Wait Time <= 30 / # inbound Calls
- Click Add, then create your third custom metric, using the formula below:
SELECT Inbound Wait Time > 30 / # inbound Calls - Click Apply.
These metrics will not automatically render as percentages. You will need to follow the steps below to change the format to percentage.
To change the metric format
- Select one of your custom metrics created above.
- In the Details panel, click the Edit button in the Metric format box.
- Replace the current number format with "##0%".
- Click Apply.
You can use these metrics to view percentage results on any chart type. If you want to show the percentage number, check the Data labels box under Show Configuration > Advanced Configuration > Data Labels.
Your report should resemble the image below:

Reordering and relabeling metrics
There are additional steps you can take to increase the readability of your report. While names like "% Inbound 10 <=Wait <=30" are descriptive in your metrics page, it could be difficult to interpret when looking at the report.
To change a metric label
- Select the table chart type.
- Double click the metric header you want to relabel.
- Type the new metric name, then press enter.
- Select your original chart type.
Before finishing your report, you'll want to ensure the metrics are displaying in the correct order.
To change the order of your metrics
- Select the table chart type.
- Drag-and-drop the metric headers into their new order.
- Select your original chart type.
8 Comments
Does this include callback requests (i.e. how long customer waited for a callback)?
Hi Michelle! Welcome to the Community!
This metric only applies to the amount of time that a user waited in the queue. The amount of time the user waits for a callback after they hang up is not included.
Are these wait times in minutes or seconds (the custom ones from above)?
Hi Kelly,
All Talk-related durations are going to be in seconds by default. You can include division within the metric definition typing "/60" directly into the metric editor to convert to minutes.
I hope this helps! Happy reporting!
Nice article, thank you!
Is wait time counted as a sum for transferred calls here or they will have multiple wait times for each transfer? Thanks!
This is more of a general wait time related question and not specific just for this report - how is exactly the wait time calculated in case an IVR is in place? For example - if someone calls, and just waits on the first greeting for 2minutes, repeatedly listening to it before choosing an option and getting to an agent, are those 2min calculated in that person's total wait time?
Thanks!
Hey there Dragan,
This metric calculates all calls that have passed the initial greeting, so in your example this wait time would be calculated after the first initial greeting. Even though they're replaying this greeting, the timer should not start until this greeting is completed and moved on from.
I hope this helps!
Please sign in to leave a comment.