Bug #7807
closed
mismatch data of agent time detail and export call report on total calls
100%
Description
Hi,
Please look into why the total calls on the agent time detail do not match the total calls on export call report. I've tried generating a report from Dec 16 2019 12am to Dec 16 2019 11:59pm. My Agent time detail tells me my agent had 685 total calls while on the Export call report using the same time and date range it only displays 683 calls.
Agent Time Detail
Export Call Report
Files
| exportcallreporttotalcalls.jpg (239 KB) exportcallreporttotalcalls.jpg | |||
| timedetailtotalcalls.jpg (173 KB) timedetailtotalcalls.jpg | |||
| rep1.png (55 KB) rep1.png | |||
| rep2.png (41 KB) rep2.png |
Updated by Wittie Manansala over 5 years ago
- Due date set to 12/24/2019
- Assignee changed from Wittie Manansala to Thom Bernarth Patacsil
Hi Thom,
Please try to check the query, it seems that its something to do with STATUS=NULL in vicidial_agent_log.
Thanks
Updated by Thom Bernarth Patacsil over 5 years ago
- Status changed from New to In Progress
Updated by Jackie Alfonso over 5 years ago
Hi Thom,
Thanks for the update. the data on agent time detail and export call report are now tallied.
Updated by Thom Bernarth Patacsil over 5 years ago
- Status changed from In Progress to Closed
- % Done changed from 0 to 100
Mismatch in total number of calls in agent time detail and export call report was caused by some status such as "NULL" is being included and "DISPO" aren't found in the vicidial_agent_log. Used the table being used in the export call report which is vicidial_log to get the total number of calls in the agent time detail.