Average Talk Time calculation

Unanswered Question
jsokell Wed, 02/21/2007 - 05:20

Sorry to be pedantic but what version of IPCC Enterprise are you using?

The database schemas can vary from version to version.

jsokell Wed, 02/21/2007 - 05:53

This is the way that I see it... There are two types of information about the call:

- Agent Oriented data includes items such as talk time and so on, since this indicates what the agent actually did. This data answers the question: what did the agents do?

- Call Oriented Data includes items such as the features of the call itself, such as abandoned time, service level met or not. This data answers the question: what were the defining features of the call?

The tricky thing with Call Type is that calls can inherit new Call Types as they go through the system, which could make overall talk time more difficult to track.

That said, the only thing I could find was in the Call Type Real Time Table, which is a field called 'TalkTimeToday' and can be found in the caltyp24 webview report. Perhaps you could manipulate that?

I hope that you have better luck and I will look forward to other people's opinions...

Zin.Karzazi Wed, 02/21/2007 - 07:10


Avg Talk Time :TalkTimeToHalf / CallsHandledToHalf.

Select: caltyp23: Call Type Historical All Fields and do the Math (TalkTimeToHalf / CallsHandledToHalf) that s would be your AVg TT (i didnt test that).

There is another Methode described by Cisco here (using SQL Analyzer). I suggest you do both methode and compare the results.


Tell us if it worked.


Rate all helpful posts.

Zin-Elabidine Karzazi


This Discussion