Report Discrepancy

[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

[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.

[ruben23]

@Matt,

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

[mflorell]

For status summaries I'd say the Agent Status detail report, because it is pulling from a single table.