Page 1 of 1

Service Level Report

PostPosted: Wed May 07, 2008 8:05 am
by seaq
Hi all,

i've got to generate an INBOUND Service Level report from vicidial.

What i'm being asked for is a report that shows in 15min frames:

- number of calls received, answered and dropped
- % of calls answered on the first 20, 40, 60, 80 and 100 seconds
- avrg waiting time before call is answered.


I'm looking for some help and hints for doing this.

Thanks

PostPosted: Sat May 10, 2008 4:27 am
by heinz
Hi seaq,

all the infos you need you'll find in the database. Your problem is to calculate the differences for the 15min frames. I had a similar problem and my solution was to create a cronjob(phpscript) which sends a query to the database every 15mins. The results are stored in a new table. With this data you can calculate your 15min reports easily.

Hope that helps somehow...
heinz

PostPosted: Sat May 10, 2008 4:29 am
by mflorell
I am actually working on this right now for seaq. Check SVN next week for a new report.