Blogs

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

Forums

« Back to Contact Center Reporting

Service level percentage, does it include Error calls

Combination View Flat View Tree View
Threads [ Previous | Next ]
Service level percentage, does it include Error calls
Answer
11/11/12 3:23 PM
Im working with the Call Type Historical All Fields report and I've been asked to remove the Error Calls from the SL Percentage column.  The thing is, I'm not even sure is included it there.
 
thanks
Flag

Automatic reply: New Message from Luis Yrigoyen in Contact Center Reporting
Answer
11/11/12 3:25 PM as a reply to Luis Yrigoyen.
I will be out of the office on 11-09-12. If you need phone assistance please contact the helpdesk.
Flag

RE: Service level percentage, does it include Error calls
Answer
11/11/12 5:05 PM as a reply to Luis Yrigoyen.
Luis Yrigoyen:
Im working with the Call Type Historical All Fields report and I've been asked to remove the Error Calls from the SL Percentage column.  The thing is, I'm not even sure is included it there.
 
thanks

 
According to the Reporting Gude on page 222:
"Tasks that abandon before the short calls timer, as defined in the Unified ICM configuration, do not count towards the service level offered or service level abandoned call counters. Also, calls that encounter an error condition or are sent to non-monitored devices (using the label node) within the service-level threshold, do not affect the service level."
Based on this, I would say 'Calls Error' is NOT included in the SL% calculation.
 
 
Flag

RE: Service level percentage, does it include Error calls
Answer
1/16/13 3:47 PM as a reply to Stephan Hartman.
I guess I should had been more specific.  I was talking about the footer formulas on the summary reports. 
I found that error calls, incomplete calls and SL error calls are not being excluded from the SL footer formulas.
 
These are the formulas I used:
I like to add SLAbanIgnore, SLAbanPositive and SLAbanNegative columns to my reports:
SLAbanIgnored =     CASE when (sum(isnull(CTHH.ServiceLevelCallsOfferedHalf,0)) - sum(isnull(CTHH.ServiceLevelAbandHalf,0))) = 0 then 0             ELSE (sum(isnull(CTHH.ServiceLevelCallsHalf,0)) * 1.0) / (sum(isnull(CTHH.ServiceLevelCallsOfferedHalf,0))              - sum(isnull(CTHH.ServiceLevelAbandHalf,0)))             END,
 
SLAbanPositive =     CASE when sum(isnull(CTHH.ServiceLevelCallsOfferedHalf,0)) = 0 then 0             ELSE (sum(isnull(CTHH.ServiceLevelCallsHalf,0)) + sum(isnull(CTHH.ServiceLevelAbandHalf,0)) * 1.0)             / sum(isnull(CTHH.ServiceLevelCallsOfferedHalf,0))     END,
 
SLAbanNegative =     CASE when sum(isnull(CTHH.ServiceLevelCallsOfferedHalf,0)) = 0 then 0             ELSE (sum(isnull(CTHH.ServiceLevelCallsHalf,0)) * 1.0) / sum(isnull(CTHH.ServiceLevelCallsOfferedHalf,0))             END
 
You need to modify the "totalerrorcount" field in the definition's query:
totalerrorcount= sum(isnull(CTHH.ErrorCountToHalf,0))             + sum(isnull(CTHH.IncompleteCallsHalf,0)) + sum(isnull(CTHH.AgentErrorCountToHalf,0)) + sum(isnull(CTHH.ServiceLevelErrorToHalf ,0))
 
SL Footer Formula (if SLA Negative): SUM(${ServiceLevelCalls}) / SUM(${ServiceLevelCallsOffered}) SL Footer Formula (if SLA Ignore): SUM(${ServiceLevelCalls}) / (SUM(${ServiceLevelCallsOffered}) - SUM(${ServiceLevelAband}))
 
SL Footer Formula (if SLA Positive): (SUM(${ServiceLevelCalls}) + SUM(${ServiceLevelAband})) / SUM(${ServiceLevelCallsOffered})  
 
SL Footer Formula (if SLA Ignore and ERRORS excluded): SUM(${ServiceLevelCalls}) / (SUM(${ServiceLevelCallsOffered}) - SUM(${ServiceLevelAband}) - SUM(${totalerrorcount}))
 
SL Footer Formula (if SLA Positive and ERRORS included): (SUM(${ServiceLevelCalls}) + SUM(${ServiceLevelAband}) + SUM(${totalerrorcount})) / SUM(${ServiceLevelCallsOffered})    
Flag

Collateral


No files available