07-12-2012 02:11 AM - edited 03-14-2019 10:12 AM
Hi Team,
I am looking for the exact SQL formula to calculate the Average Speed of Answer (ASA) for an agent.
The "Reporting Guide for Cisco Unified ICM/Contact Center Enterprise & Hosted 8.5(3) - March 2012" mention the following on page 87
The ASA is calculated for the agent at the PG level. The internal queuing time is sent to the PG by Unified ICM when an agent becomes available for the call. The PG adds up the internal queue time, ring time and network time and adds that into AnswerWaitTime in the agent skill group table. AnswerWaitTime is then divided by the CallsAnswered for the agent.
If anyone knows the formula and share it with me I would appreciate
Thanks & Regards
Nick
Solved! Go to Solution.
07-12-2012 01:59 PM
ASA = AnswerWaitTime / calls Answered.
07-12-2012 01:59 PM
ASA = AnswerWaitTime / calls Answered.
05-02-2013 12:26 PM
Can anyone help us find out where the AnswerWaitTime column is?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide