beast mode for total active tickets per hour

Abe

Hi Everyone,

I was hoping to get some assistance on writing a beast mode for getting a table to show total number of tickets per hour. Something like the one below:

I have something like this so far-

DATE_FORMAT(Date_Entered_UTC, '%Y-%m-%d %H:00:00'), COUNT(TicketNbr)

but getting an error when trying to submit it.

Any assistance is greatly appreciated.