" /> Reporting Need - Genesys CTI User Forum

Author Topic: Reporting Need  (Read 2839 times)

Kevin

  • Guest
Reporting Need
« on: January 01, 1970, 12:00:00 AM »
Advertisement
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.

Grzegorz Ostrowski

  • Guest
Reporting Need
« Reply #1 on: January 01, 1970, 12:00:00 AM »
  • Best Answer
  • 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..