Concurrency at Interval Level
I'm having some trouble getting concurrency to calculate correctly at an interval level. If I use the out of the box Chat Concurrency Factor calculation for concurrency and I found the interval calculation searching for help building this report here.
concat(date_format(chats.requested,'HH24:'), if(date_format(chats.requested,'MI') < '30','00','30'))
I am able to get concurrency at the daily level. However, when I add in a time interval it gives me wildly different numbers. Has anyone been able to successfully get Chat Concurrency at the interval level or is this not possible?