Custom report data mismatch

Any and all non-support discussions

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

Custom report data mismatch

Postby dreedy » Tue Oct 24, 2017 11:02 am

Hello everyone,
I am trying to create a custom report based off the data that would be done off the agent performance detail report. I have started off with a single day to look at for reference data points to make sure i am getting correct numbers.

when i pull the report form the test dialer. this is the numbers i am getting.

Pause 2:31:47
Wait 3:17:56
Talk 8:40:11

Here is the sql statement that i am using to grab the detail of the agents stats for that day. I have split out the times in 2 ways first way is a converted to h:m:s and the second way is just in base seconds.

select SEC_TO_TIME(SUM(pause_sec)) as pause ,SUM(pause_sec) as p,SEC_TO_TIME(SUM(wait_sec)) as wait ,SUM(wait_sec) as w,SEC_TO_TIME(SUM(talk_sec)) as talk ,SUM(talk_sec) as t from asterisk.vicidial_agent_log where event_time between '2017-10-02 00:00:00' and '2017-10-03 23:59:00' and user = '*****'

I have * the user name but it is based of real stats of a user.

here are the results of the data pull from this query.

pause 04:39:22
p 16762
wait 03:41:02
w 13262
talk 08:41:03
t 31263


I have pull several other users and am getting variations of how this looks sometimes the number get close to matching. But more often that not they are not agreeing with data provided from the Agent Performance. I have double checked my math and it is right. Am i missing a data point to pull the correct information?
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Web (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici | VERSION: 2.14-924a | BUILD: 240716-1453 | svn 3856|dbschema 1717
dreedy
 
Posts: 182
Joined: Tue Nov 24, 2015 10:16 pm

Re: Custom report data mismatch

Postby mflorell » Tue Oct 24, 2017 12:06 pm

The Performance report shows only time related to handling of phone calls(as it says on the report). This means any pause or wait time that is not before the handling of a call is ignored and not part of the reported time. This report has always operated this way and it was written that way by request of the customer who commissioned us to create the report.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Custom report data mismatch

Postby dreedy » Wed Mar 07, 2018 4:26 pm

Thanks for getting back with me on this. I took another crack at it and solved my issue i was having. I also add the ability through the sql querry to include the yesterdays calls into the data pull. Thanks again for the information.
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Web (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici | VERSION: 2.14-924a | BUILD: 240716-1453 | svn 3856|dbschema 1717
dreedy
 
Posts: 182
Joined: Tue Nov 24, 2015 10:16 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 64 guests