Blogs

Showing 8 results.
Items per Page 20
of 1
First Previous Next Last

Forums

« Back to Contact Center Reporting

Formula to calculate Calls Offered from Call_Type_Skill_Group_Interval tbl

Combination View Flat View Tree View
Threads [ Previous | Next ]
Formula to calculate Calls Offered from Call_Type_Skill_Group_Interval tbl
cuic
Answer
10/10/12 6:16 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.
Flag

Re: New Message from Daniel Jebakumar in Contact Center Reporting (CCR) - C
Answer
10/10/12 6:12 AM as a reply to Daniel Jebakumar.
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.
Flag

RE: Formula to calculate Calls Handled from Call_Type_Skill_Group_Interval
Answer
10/10/12 6:15 AM as a reply to Nathan Luk.
Sorry. The needed metric is Calls Offered. Not handled.. My mistake
Flag

RE: Formula to calculate Calls Handled from Call_Type_Skill_Group_Interval
Answer
12/14/12 3:51 PM as a reply to Daniel Jebakumar.
Skill_Group_Interval.CallsOffered
 
Daniel Jebakumar:
Sorry. The needed metric is Calls Offered. Not handled.. My mistake
Flag

Collateral


No files available