Beast Mode- SQL code to count how many updates in 6 hour intervals

Abe

Hello,

I'm in need of assistance please of creating a beast mode but can't seem to write it correctly.

I have a table named updates with a column time_start that stores the timestamp of each update.

the Rows will be the ticket numbers

And I want to group the updates by 6-hour intervals, and count how many updates fall into each interval.

Here is what I have curently-
DATE_ADD(Hours, time_start) - INTERVAL '1 hour' * (EXTRACT(Hours FROM time_start) % 6) AS time_start,
COUNT(*) AS TicketNbr

Any assistance is greatly appreciated.

Abe

@DashboardDude thank you for assisting me in the previous post and while the new ETL data set worked, we are not allowed to create new data sets so I have to create a beast mode for this request.

I was hoping you can assist on a beast mode to get this working, or if this is even possible to create?

DashboardDude

Hi @Abe ,

Feel free to book some time and we can see what we can do: https://www.dashboarddudes.com/domo-help