Outbound Calling Stats AVG Wait time query question

[omarrodriguezt]

Hello,

In the Outbound Calling report there is an "Average Wait time between calls" and this information come from this query:

select avg(wait_sec) from vicidial_agent_log where event_time >= '2010-11-22 00:00:00' and event_time <= '2010-11-23 23:59:59' and campaign_id IN('campaign_id');


Why you don't use it here also these filters:

"and pause_sec<36000 and wait_sec<36000 and talk_sec<36000 and dispo_sec<36000 and lead_id is not null"

like you do for others reports?

Thank you in advance

[mflorell]

Good idea, please post this to the issue tracker.

[omarrodriguezt]

http://www.vicidial.org/VICIDIALmantis/view.php?id=409