Outbound Calling Stats AVG Wait time query question
Posted: Tue Nov 23, 2010 8:45 amHello,
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
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