Adjusted chat_agent_performance_intervals

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