Report Discrepancy

All installation and configuration problems and questions

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

Report Discrepancy

Postby ruben23 » Mon Oct 02, 2017 11:29 am

VERSION: 2.14-627a
BUILD: 170828-2105
© 2017 ViciDial Group
Asterisk 1.8
Ubuntu Server 12.04.5 LTS 64bit
1Large Sole Database
1 Web Server
4 Vicidial/asterisk

We have some discrepancy on our reports regarding Individual Report and Group Report, the values of the output are different i highlighted a sample difference. Any idea how to Solved this issue somehow.?
Rudolph Sally have like :

Have SALE: 29 on the Group report (Agent Status Detail) and have SALE: 30 on the user stats Report of Rodulph itself

Including:

Total Number of calls: Group Report: 736 and on user stat Total: 739

sample PHOTO

Image

Image
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: Report Discrepancy

Postby mflorell » Mon Oct 02, 2017 11:39 am

Those two reports pull that data from different log tables with different queries.

The Agent Status Detail report is pulling from the vicidial_agent_log

The User Stats page pulls that first data table from the vicidial_log and vicidial_closer_log table


Since the User Stats table is pulling data from two tables and adding them together, it's possible there are duplicates in there depending on how the call was handled.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Report Discrepancy

Postby ruben23 » Mon Oct 02, 2017 11:57 am

@Matt,

Which is the most accurate Report we ca get the individual Userstats.? or the Agent Status Detail
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: Report Discrepancy

Postby mflorell » Mon Oct 02, 2017 4:46 pm

For status summaries I'd say the Agent Status detail report, because it is pulling from a single table.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 74 guests