cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2082
Views
25
Helpful
23
Replies

Service Level calculation on UCCE 10.0

Lazar Obradovic
Beginner
Beginner

Hi guys,

I have been asked by one customer to calculate their SL for 20 seconds threshold for number of skill groups, for last 11 months,

without changing their current (default) measuring value (30 sec)!

 

Is this possible somehow?

Can anybody point me in the direction to resolve this?

 

P.S. I tried to revert SL value for one skill group, and than to execute one CUIC report but without success (I recived same SL % as before).

 

Thanks,

Lazar

1 Accepted Solution

Accepted Solutions

Hi,

this might be a good start:

DECLARE @dateFrom DATETIME, @dateTo DATETIME, @SLLimit INT
SET @dateFrom   = '2014-11-12 00:00:00'
SET @dateTo     = '2014-11-13 00:00:00'
SET @SLLimit    = 20
SELECT SUM(1) AS AllCalls,
SUM(CASE WHEN tcd.NetQTime <= @SLLimit THEN 1 ELSE 0 END) AS SLMet
FROM Termination_Call_Detail tcd
WHERE tcd.DateTime >= @dateFrom AND
tcd.DateTime < @dateTo AND
tcd.AgentSkillTargetID IS NOT NULL AND
tcd.SkillGroupSkillTargetID IS NOT NULL AND
tcd.RouterCallKeyDay > 0 AND
tcd.TalkTime > 0

The result of this query is actually two numbers: AllCalls gives you the number of calls (explained bellow) and the SLMet is the number of calls where the length of time spent in the Router Queue (NetQTime) is less than or equal to 20 seconds.

The input parameters are

@dateFrom, @dateTo: the start and the end of the observed period;

@SLLimit: the upper bound of the interval for one call's queue time, if it is not passed then the call is considered answered within this "service level" interval.

Please note there are multiple conditions in the WHERE clause: the AgentSkillTargetID and the SkillGroupSkillTargetID cannot be NULL (this ensures we only take a look at calls handled by agents and skill groups) also the RouterCallKeyDay > 0 ensures we count ACD calls only and the TalkTime > 0 filters out answered calls only.

You can sort of enhance this with for instance

SUM(CASE WHEN (tcd.NetQTime + tcd.RingTime) <= @SLLimit THEN 1 ELSE 0 END) AS SLMet

That would also count with RingTime.

G.

View solution in original post

23 Replies 23

Gergely Szabo
Advocate
Advocate

Hi,

yes, this is possible, although it's not going to be that easy.

Could you do the following for me (just to check whether we have available data) on the <instancename>_hds database?

SELECT TOP 1 tcd.DateTime FROM Termination_Call_Detail tcd ORDER BY tcd.DateTime ASC

Is the datetime value returned in this query older than the start of the above mentioned 11 month period?

G.