Page 1 of 1

Report Discrepancy

PostPosted: Mon Oct 02, 2017 11:29 am
by ruben23
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

Re: Report Discrepancy

PostPosted: Mon Oct 02, 2017 11:39 am
by mflorell
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.

Re: Report Discrepancy

PostPosted: Mon Oct 02, 2017 11:57 am
by ruben23
@Matt,

Which is the most accurate Report we ca get the individual Userstats.? or the Agent Status Detail

Re: Report Discrepancy

PostPosted: Mon Oct 02, 2017 4:46 pm
by mflorell
For status summaries I'd say the Agent Status detail report, because it is pulling from a single table.