Time spent per agent during a specific time period
I am trying to create a recipe that will allow me to see how much time agents have spent on ticket updates during a specific timeframe, regardless of whether or not the ticket was created or solved during that timeframe.
Currently, for metrics I have SUM(Total time spent((hr)), which is a custom metric made to convert [Total time spent (sec)] into a more digestible format.
For columns I have updater name. I am using this rather than assignee name because people can spend time on updates as an assist rather than as an assignee, so using updater name should capture all updates made by agents whether they are the assignee or not.
Finally, for filters I am using a time filter for "Update - Date" to get my relevant time frame.
The issue that I am running into is that I think this recipe captures any time spent ever on tickets that are updated within the time frame, not just the time spent on updates during the time frame.
Is there a better way to create this query such that it will actually work to capture agent productivity during a specific timeframe?
-
Hi Micah,
I am interesting by your request. Did you find a way?
Thank you
-
Hi Micah,
I'm afraid there is currently no option to filter your data to only show updates that were made within a specified date range. There's no attribute that can list the time stamp of each update on a ticket, so it wouldn't be possible to define a date range filter based on the each event timestamp. Sorry about this.
Thank you!
Iniciar sesión para dejar un comentario.
2 Comentarios