Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Kevin on January 01, 1970, 12:00:00 AM
-
Hopefully someone can provide insight:
For one of our clients, I need to provide the following statistics:
P5 the wait time of 5% of our callers
Median the wait time of 50% of our callers
P95 the wait time of 95% of our callers
Span the value P95 P5
We only have CC Analyzer to work with. I'm thinking that I need Call Concentrator to make this happen, but I wanted to see if anyone had suggestions.
I appreciate any input. Thanks in advance.
-
You can do that with CCA assuming 1 s. precision (or less if it is OK for your customer and you want to avoid some work) and putting a lot of boring work into it. To do that you need
1) define Time Ranges from 1 s. to max time allowed in your environment for a call to wait in a queue
2) Define in DMA report layout to monitor number of calls with associated TimeRanges defined in 1)
This would give you tables/views in your database with columns having number of calls waiting for 1s., 2 s., 3 s., ...
Then some database work ahead of you ...
I would do:
3) transposition of your view 'storing' stat values (e.g. in Oracle you can use 'union all' statement to do that) and adding column with sum of all calls
After 3) you would get DB view like that (view1):
time_key time_range calls_in_range calls_sum
---------------------
20030101 1 15 1055
20030101 2 3 1055
20030101 3 14 1055
.....
Then to get P5 you can
5) define a view like that (view2) Oracle syntax
create or replace view view2 as
select time_key, min(time_range)
where calls_in_range/calls_sum>=0.05
group by time_range
and finally you need to
6) Build Brio report based on your view
Similary you can do Median and P95 then span is no problem. Probably you would need to customize this 6 steps if you need e.g. to differentiate between queues etc..