12-06-2019 02:16 AM
Hello lovely CiscoMembers,
so this is my first post and i hope i will share every information you need to clarify my question :)
I work at the reporting department and i use sql querys to create reports directly from .hds or .awdb tables in QlikView.
And now i got some problem...i cant describe the difference between CallsAnswered and CallsHandled;
I have a Call type that redirects to only one PrecisionQueue and there is no other way to OverflowOut of this CallType.
The CallType is a Voice Only CallType MR.DomainID 1 and Agents have to pick up to handle the tasks.
I cumulated everything for a whole day for this one CallType (Only Call Columns for you: ) from "msslg_hds.dbo.Call_Type_Intervall"
I only used a calculation on the "Calls_Offered_Real"-Field (CallsOffered-ShortCalls-ServiceLevelAband)
CallTypeID | 6.226 |
CallsRouted | 6.197 |
RouterQueueCalls | 4.475 |
RouterCallsAbandQ | 96 |
RouterCallsAbandToAgent | 95 |
CallsRoutedNonAgent | 0 |
AgentErrorCount | 0 |
TotalCallsAband | 191 |
CallsRONA | 3 |
CallsRequeried | 16 |
ReturnRelease | 0 |
ErrorCount | 0 |
ReturnBusy | 0 |
ReturnRing | 0 |
CallsOffered | 6.338 |
CallsOffered_Real | 6.209 |
CallsAnswered | 6.197 |
CallsQHandled | 1.773 |
CallsHandled | 6.143 |
ServiceLevelAband | 129 |
ServiceLevelError | 0 |
ServiceLevelRONA | 2 |
ServiceLevelCallsOffered | 6.392 |
OverflowOut | 0 |
IncompleteCalls | 1 |
ShortCalls | 0 |
Columns with "VRU" are complety empty and are not shown in the table above.
So i got a difference of "54" Calls between Answered and Handled and i cant determine through the columns where they are.
Please Community, can you help me ?
Kind regards
Pascal
12-07-2019 01:16 AM - edited 12-11-2019 01:29 PM
Hi
Answer call count is taking from Agent_Skill_Group_Interval ( 30 Minutes) and handled call count will consider Last 30 minutes interval continuations call + Present calls counts.
Ex: if the call is answered on 11-12-2019 at 11:59:00 PM and the call is handled on 12-12-2019 at 00:03:00 AM.
If you calculate CallsAnswered+ CallsHandled counts for 30 intervals you will find the difference.
Ram.S
12-08-2019 10:12 PM
Hi Ram S.,
thanks for your post.
Like you said "Technically speaking calls answered and calls handled is same" but in this example it's not.
And i can't figure out where the difference of "54 Calls" come from.
There must be a Column which will populate so that we can substract this "new?" field from the Calls Answered.
Let's say...you got an contract with an Partner in which you have agreed to pay for each answered Call...but you report only handled calls (because only handled calls will generate HandlingTime)...and now the Partner want to know why there is an difference...it could be that this "54" Calls Difference are only Shortcalls of 5 Sec or even less. But in the Cal_Type_Interval is no Column who can explain the Difference...
Kind regard
Pascal
12-11-2019 01:46 PM
Hi
Answer call count is taking from Agent_Skill_Group_Interval ( 30 Minutes) and handled call count will consider Last 30 minutes interval continuations call + Present calls counts.
Ex: if the call is answered on 11-12-2019 at 11:59:00 PM and the call is handled on 12-12-2019 at 00:03:00 AM.
If you calculate CallsAnswered+ CallsHandled counts for 30 intervals you will find the difference.
Ram.S
12-12-2019 07:40 AM
Hey ... we only work from 8:00 AM to 9:00 PM.
We don't work beyond midnight.
#
Kind Regards
Pascal H.
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