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.

ArborRose

Create a beast mode formula (calculated field) using something like Hour Bucket as

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

Then you want to create a card with a table that aggregates using COUNT. Drop Hour Bucket on the card and then TicketNbr on the card and set it to COUNT.

COUNT(`TicketNbr`)

This will count the number of tickets for each hour bucket. Let me know if you need actual screenshots and I'll build a sample.