You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Adjusted chat_agent_performance_intervals

Question
6
Views
0
Comments

Summary

Needing to cut off the times.

Content

I am having trouble cutting off interval times. I am trying to measure our agents using live chat. The functions work if both the start and end time are within a certain timeframe but when I shorten it to anything less, some agents are getting NULL values simply because the end times are not within the range. This would be fine since I could measure from min(start time) to max(start time) normally but this doesn't work with availability. Since I am trying to measure utilization, is there a way to break up these times so instead of completely all or nothing

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!