All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by seaq » Wed May 07, 2008 8:05 am
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
-
seaq
-
- Posts: 86
- Joined: Tue Jul 04, 2006 8:27 pm
-
by heinz » Sat May 10, 2008 4:27 am
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
-
heinz
-
- Posts: 106
- Joined: Mon Oct 08, 2007 1:30 am
- Location: South Africa
by mflorell » Sat May 10, 2008 4:29 am
I am actually working on this right now for seaq. Check SVN next week for a new report.
-
mflorell
- Site Admin
-
- Posts: 18387
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
-
Return to Support
Who is online
Users browsing this forum: Google [Bot] and 143 guests