I have a task to create a chart that will show agents and their activity throughout the day from an ACD system. There are multiple agents but you can see below a snapshot of the data and how it flows for one agent. Any assistance would be appreciated. I have attached the sample report as well.
Agent Name ActionDateTime Action
Agent 1 5:49:00 User logged in
Agent 1 5:50:00 LOGGEDOUT to LOGGINGIN
Agent 1 5:50:00 LOGGINGIN to NOTREADY
Agent 1 5:50:00 NOTREADY to NOTREADY
Agent 1 5:50:00 NOTREADY to READY - Work
Agent 1 6:02:00 READY to TALKING
Agent 1 6:45:00 TALKING to WRAPPING
Agent 1 6:46:00 WRAPPING to READY
Agent 1 6:46:00 READY to TALKING
Agent 1 6:47:00 Dashboards page was opened
Agent 1 6:53:00 TALKING to WRAPPING
Agent 1 6:55:00 WRAPPING to READY
Agent 1 6:56:00 READY to NOTREADY
Agent 1 8:12:00 NOTREADY to TALKING
Agent 1 8:13:00 TALKING to WRAPPING
Agent 1 8:13:00 WRAPPING to READY
Bookmarks