Hi,
Using Cisco 11.6
calculate there are differences in some interval on Termination_Call_Detail , Skill_Group_Interval and Agent_Skill_Group_Interval.Mostly matching these tables for Handled calls.But some days are different. Anybody knows why ? How can i match these tables?
--Result 160
SELECT COUNT(*)
FROM dbo.Termination_Call_Detail
WHERE
CallTypeReportingDateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND
SkillGroupSkillTargetID = 5016 AND CallDispositionFlag = 1 AND PeripheralCallType = 2
--Result 156
SELECT SUM(CallsHandled)
FROM dbo.Skill_Group_Interval
WHERE
DateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND
SkillTargetID = 5016
--Result 156
SELECT SUM(CallsHandled)
FROM dbo.Agent_Skill_Group_Interval
WHERE
DateTime BETWEEN '2019-12-12 13:30:00' AND '2019-12-12 13:59:00' AND
SkillGroupSkillTargetID = 5016
