Agent "Total Online Time" reporting. | Community
Skip to main content
Accepted

Agent "Total Online Time" reporting.

Related products:Reporting and analytics (Explore)
  • January 23, 2019
  • 127 replies
  • 0 views

Show first post

127 replies

Kelli12
  • October 27, 2023

First, THANK YOU @tom12. That's exactly what I needed. The way my gmail works, I didn't scroll down far enough to realize there is a second separate email with another zip file. When you provided the name of the zip file, that is what made me realize this! I was only ever seeing the first zip file chat_analytics.

Second, sharing a bit of hopefully helpful info. I saw what you mean about the date and time being a string instead of datetime in Excel. I found that if you copy/paste the data into Google Sheets, it reads it correctly and makes it a usable datetime field without formulas and whatnot. Then you just need to add or subtract your timezone difference. For me, we are currently 5 hours different, so I needed to subtract by 5hr/24hr = 0.2083 of a day. Basically this is just saying 5 hours is 0.2083 of a day so sheets knows to take that from the time. (If you just -5, you'll subtract from the days instead of the time.)


Karen13
  • February 1, 2024

Hello everyone! I am thrilled to announce that agent state historical reporting has reached GA! Please see this announcement for more information. 

If you have any product feedback about this feature, or another area on Explore, we would love to hear from you! Please create a new post in our Explore forum using this template to share your thoughts; our product feedback team will log and review every piece of feedback that comes through.