Formula to calculate Calls Offered from Call_Type_Skill_Group_Interval tbl

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode
This document was generated from CDN thread

Created by: Daniel Jebakumar on 10-10-2012 01:06:04 AM
Hi,
 
i need to show the calls handled in a report which uses Call_Type_Skill_Group_Interval table. Is there a formula to obtain the same. 
 
Currently I use sum(isnull(CallsOfferedRouted,0)+isnull(CallsOfferedNotRouted,0)+isnull(CallsHandledNotRouted,0)). But the value doesn't match with those from other reports.
 
Can someone help me please. Thanks in advance.

Subject: Re: New Message from Daniel Jebakumar in Contact Center Reporting (CCR) - C
Replied by: Nathan Luk on 10-10-2012 01:12:42 AM
Hi Daniel,

Am I missing something here? Why aren't you just using Call_Type_Skill_Group_Interval.CallsHandled?

Cheers,

Nathan Luk
From: Cisco Developer Community Forums <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Reply-To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Date: Wednesday, 10 October 2012 4:06 PM
To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Subject: New Message from Daniel Jebakumar in Contact Center Reporting (CCR) - Contact Center Reporting: Formula to calculate Calls Handled from Call_Type_Skill_Group_Interval tbl

Daniel Jebakumar has created a new message in the forum "Contact Center Reporting": -------------------------------------------------------------- Hi,

i need to show the calls handled in a report which uses Call_Type_Skill_Group_Interval table. Is there a formula to obtain the same.

Currently I use sum(isnull(CallsOfferedRouted,0)+isnull(CallsOfferedNotRouted,0)+isnull(CallsHandledNotRouted,0)). But the value doesn't match with those from other reports.

Can someone help me please. Thanks in advance.
--
To respond to this post, please click the following link: http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/7481518 or simply reply to this email.

Subject: RE: Formula to calculate Calls Handled from Call_Type_Skill_Group_Interval
Replied by: Daniel Jebakumar on 10-10-2012 01:15:05 AM
Sorry. The needed metric is Calls Offered. Not handled.. My mistake

Subject: RE: Formula to calculate Calls Handled from Call_Type_Skill_Group_Interval
Replied by: ED VILLARREAL on 14-12-2012 09:51:20 AM
Skill_Group_Interval.CallsOffered
 
Daniel Jebakumar:
Sorry. The needed metric is Calls Offered. Not handled.. My mistake

Attachments

    Outcomes