I'm developing a report that displays calls per hour. I'm having trouble creating the query to get the results. Help form anyone would be greatly appreciated.
The output I'm looking for is something like this:
Two column report, one with Hour of the Day and other is the Average Calls.
Hour of the day | Average Calls
-------------------------------------
8am--------------| 11
9am--------------| 11
10am------------| 11
11am------------| 11
Thank you.