08-18-2015 09:15 AM
Hi,
I'm trying to run a report for a single Agent over time an have values grouped by Month. I don't see any examples of this. The Report Def is using a Stored Procedure. This is the output I'm hoping for (mockup), focus on Month column. Any help would be appreciated.
Agent Name | Total Inbound | Inbound ACD | ||||
Month | Total | Avg Talk Time | Avg Hold Time | Avg Work Time | ||
Damon Gaylor | Jan | 1 | 1 | 0:00:01 | 0:00:00 | 0:00:00 |
Feb | 7 | 5 | 0:00:08 | 0:00:00 | 0:00:02 | |
Mar | 5 | 5 | 0:01:27 | 0:00:00 | 0:00:00 | |
Apr | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | |
May | 1 | 1 | 0:00:29 | 0:00:00 | 0:00:10 | |
Jun | 2 | 1 | 0:00:10 | 0:00:00 | 0:00:10 | |
Jul | 9 | 8 | 0:02:07 | 0:00:00 | 0:00:03 | |
Aug | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | |
Sep | 6 | 3 | 0:01:04 | 0:00:00 | 0:00:00 | |
31 | 0:00:36 | 0:00:00 |
08-19-2015 09:42 AM
Do you have access to the stored procedure?
08-19-2015 01:37 PM
Yes. I was hoping to not have to modify that, but it sounds like that is exactly what is needed.
08-19-2015 01:41 PM
Yes. If that doesn't work. Let me know.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: