Is there a way to calculate the average handle time across multiple CSQ's?
Is there a way to calculate the average handle time across multiple CSQ's? I have a customer who has multiple CSQ's and they want a report that displays the average handle time across all of their CSQ's.
In UCCX CUIC Reports -> Stock -> Unified CCX Historical -> CSQ All Fields Report is available,
This report will show CSQ based Summary report that contains Avg. Handle Time of each CSQ. If you run this report for all CSQ and Export to Excel you can see the Avg. Handle Time across all CSQs (Below the image for the same).
This is one of the easiest ways without customization (Mathematical Avg. Calculation).
Actual Avg. Handle Time:
Handle time of a call is calculated as (ACD.talkTime + ACD.holdTime + ACD.workTime). Determine the sum of handle times for all calls handled by this CSQ, then divide by Calls Handled—Total, if calls handled is not zero. If it is zero, this field is set to zero.
ACD refers to the alias of the database table AgentConnectionDetail.
The Cisco documentation basically says that for a given time period. The AHT = (Total Talk Time + Total Hold Time + Total Work Time) / Total Handled Calls.
So you have to calculate the Handled Time of all the CSQs and Total Calls Handled by all the CSQs and use the formula Total Handled Time/ Total Calls Handled.
Hope this clarifies you.
Thanks and Regards, Sathiya Kumar V M Senior Database Developer
Goal: Provide a simple User Interface to control, modify and customize your Webex Desk Video device.Install time: around 5 minutes (upload the UI and macro)
What can you do?
Camera ExposurePan/tiltSelf-view on/off + small/full ...
Okay, guilty as charged for creating a click bait subject. I love Python. But there are some things about Python that can be annoying if you're just starting out as a Python programmer. Let's tackle a few of them so you don't suffer from the mistakes I ha...
Demo - Webex Video device Virtual Lamp integration
Show how easy it is to create a virtual lamp and integrate it with a Webex Video device or bot. Create your own lamp using the virtual lamp bot make it create a ...
Team,As I'm using a lot of virtual environments with PIPENV, it became harder to keep track of the environments that I have setup. And that was the reason to create this script which:
List all of your (pipenv) virtual environments