report -data definitions

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

report -data definitions

Postby lvish » Fri May 24, 2013 12:28 am

Hi

Am comparing total no. of calls in agent performance detail report , team performance report , agent stats & out bound calling report. Each report gives a different figure for total no. of calls, Sale calls etc.

Is there any where we can find out definition of each data point like from where the value is fetched , includes /excludes what type of calls, if it is time data -start trigger event and end trigger event.

thanks in advance

lvish

------------------------------------------------------------------------------------------------------------------------

DB ,Web ,Asterisks-- Dell R720 -Hexa core 32GB, -- 60 Agents --64Bit version
Asterisks ,Web -- ML110 , 1 X Quad core 8GB RAM -- 25 Agents --- 4 PRis 32 bit
Asterisks ,Web -- ML110 , 1 X Quad core 8GB RAM -- 25 Agents -- 2 Pri's 32bit

VERSION: 2.6-375a
BUILD: 120831-1523

Dahdi 2.6 -PRI trunks X 6 no.s
Vicibox 4.0.1,
Balance dialing -- Yes in all servers.
lvish
lvish
 
Posts: 103
Joined: Tue Jan 25, 2011 4:56 am

Re: report -data definitions

Postby mflorell » Fri May 24, 2013 5:38 am

The Manager Manual goes over some of this, but if you want the queries you'll have to look at the source code.

Each of those reports are measuring different things, so it is normal that the totals can be different.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: report -data definitions

Postby lvish » Fri May 24, 2013 8:29 pm

thanks,

lvish
lvish
lvish
 
Posts: 103
Joined: Tue Jan 25, 2011 4:56 am

Re: report -data definitions

Postby williamconley » Sun May 26, 2013 7:45 pm

often executing the page on which the report is generated with &DB=1 at the end of the URL will show the SQL used to generate reports. but some of the SQL commands do not have this feature, depending on who created that section.

in which case: You have to take matt's suggestion and check the source code of the report page to get the sql code used to build the report.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: report -data definitions

Postby lvish » Thu May 30, 2013 10:00 pm

Thank you , was tracking outbound calling report & agent performance report ...majority of difference is caused by calls with disposition DISPO, INCALL, QUEUE & ERI.

I understand DISPO status is cos of agent closed the browser in dispo screen. Will it be same for INCALL? like agent closed/switched off the desktop/ network disconnected when on call? or is there any other reason for INCALL status.

Not sure another issue noticed is ....Calls disposed by system as QUEUE is not tagged to any campaign ( not figured in individual campaign outbound calling report) . But if I pull the out bound calling report by selecting all campaign we will get the calls with QUEUE disposition.
lvish
lvish
 
Posts: 103
Joined: Tue Jan 25, 2011 4:56 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 131 guests