Hey, I've looked around online but I'm having trouble finding a certain query I would like to run against the SQL database. This is within a View 4.6 environment. Hopefully someone here has an idea. I'm trying to figure out how many users are logged into each pool by each hour. Right now I'm just checking it on the hour and taking note but I'm sure there's an easier way. Here's an example of what results I am trying to achieve:
Pool 1
07:00 - 10 sessions
08:00 - 18 sessions
09:00 - 52 sessions
Pool 2
07:00 - 4 sessions
--
--
Well, you get the point. Any help would be greatly appreciated.
