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 | ||||
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Do you have access to the stored procedure?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yes. I was hoping to not have to modify that, but it sounds like that is exactly what is needed.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yes. If that doesn't work. Let me know.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Comments
0 comments
Please sign in to leave a comment.