cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
573
Views
0
Helpful
1
Replies

Agent_Skill_Group_Half_Hour and Termination_Call_Detail

aliparvez
Level 1
Level 1

When I take the calls answered per agent from Termination_Call_Detail and match it with calls answered per agent from Agent_Skill-Group_half_Hour tabe, the total dont match. The column I am taking from Agent_Skill-Group_half_Hour tabe is CallsHandledToHalf. Can someone pls comment on this. And also any explanations as to how cisco does the accumulation in Agent_Skill_Group_half_Hour tabe will be very helpful.

Many thanks,

Ali

1 Reply 1

dreich
Cisco Employee
Cisco Employee

There are likely to be a couple of different reasons here for the delta.

The Termination_Call_Detail record is cut when the call ends. The call is pegged as answered in the half hour when the call was answered. If the call bridges the half hour boundary, then some calls will be counted as answered in one half hour, but the TCD will be in the next half hour.

The other thing to look at is how are you counting a call as answered in the TCD? It may be you are ignoring some CallDispositions or attributes where the call was really answered. The more reliable method is to use a where clause that checks TalkTime > 0 and AgentSkillTargetID > 0.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: