UCCE: Difference between CallsAnswered and CallsHandled

[Fragstuff]

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

[Ramamoorthy Shanmugam]

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

[Fragstuff]

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

[Ramamoorthy Shanmugam]

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

[Fragstuff]

Hey ... we only work from 8:00  AM to 9:00 PM.

We don't work beyond midnight.

#

Kind Regards

Pascal H.