Tickets created per time of the day

This should really be available out of the box. However, I found a workaround that works with Operations Hub.

I created a dataset and added a derived field using a formula:

Formula: DATEPART(‘HOUR’, [Ticket Create date])

This allows me to count how many tickets are created per hour.