Hello,

I'm trying to create a Custom Query Report to show how many calls we receive during specific time periods of the day.

For example:

How many calls we receive:

From 8-9 a.m.

From 9-10 a.m.

From 11-12 noon, etc.

I'm also trying to group it by Category to know what type of calls come in during those times. 

For example, Are they all password resets, or logon failures, etc.?

I can only seem to create a report to show how many calls per DAY we receive but I need to know the times these calls are coming in. I've had to resort to manual extraction which is way to time consuming and leaves too much room for error.

Any help at all would be appreciated. 

I had a query posted for this that worked briefly but now isn't working. This is very important to our reporting statistics, we need to know what types of calls were getting and what times of the day they are coming in.

Thank you,