report -data definitions

[lvish]

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.

[mflorell]

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.

[lvish]

thanks,

lvish

[williamconley]

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.

[lvish]

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.