Good afternoon,
I'm trying to retrieve individual call information for an agent group, and created this custom report with this query:
Select
CALLID, ANSLOGIN, SUM(ACWTIME), SUM(ANSHOLDTIME), SUM(TALKTIME), ROW_TIME, ROW_DATE FROM call_rec
Where
ACD=$acd AND ANSLOGIN IN (select value from agroups where acd_no=$acd and item_name = [Agent Groups:] ) AND ROW_DATE = [Dates:] AND ROW_TIME = [Time:] GROUP BY ANSLOGIN, ROW_DATE, ROW_TIME, CALLID
When I run this report, it comes up blank. The date is correct and Group Name as well Any thoughts?
I'm trying to retrieve individual call information for an agent group, and created this custom report with this query:
Select
CALLID, ANSLOGIN, SUM(ACWTIME), SUM(ANSHOLDTIME), SUM(TALKTIME), ROW_TIME, ROW_DATE FROM call_rec
Where
ACD=$acd AND ANSLOGIN IN (select value from agroups where acd_no=$acd and item_name = [Agent Groups:] ) AND ROW_DATE = [Dates:] AND ROW_TIME = [Time:] GROUP BY ANSLOGIN, ROW_DATE, ROW_TIME, CALLID
When I run this report, it comes up blank. The date is correct and Group Name as well Any thoughts?