Hi Marco,
1) Can I create (save as and then edit, I know) the ability to use the 'Contact Service Queue Activity Report by CSQ' reporting on the previous week broken down by 'weekday’ and the CSQ.
Ans)
Step 1: Create a new report definition with the required data.
SELECT CONVERT(VarChar(10), DateTime, 114) AS Interval, SUM(Offered) AS OFFERED, SUM(Handled) AS Handled
FROM TableName
WHERE (1=1)
GROUP BY CONVERT(VarChar(10), DateTime, 114)
ORDER BY CONVERT(VarChar(10), DateTime, 114) ASC
Note: the specific names for offered and handled change based upon which interval you are using.
Set 2: Create a new report
Reference- CSQ Activity Report by Interval
For the next three questions request to refer the attachments in this URL - Agent inbound/oubound call detail report
Thanks and Regards,
Geevarghese