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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide