Formula to calculate Calls Offered from Call_Type_Skill_Group_Interval tbl

Version 1
    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