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

Abe
Abe Member

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.

Tagged:

Best Answer

  • DashboardDude
    Answer ✓

    Hi @Abe ,

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

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

Answers

  • Abe
    Abe Member

    @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
    Answer ✓

    Hi @Abe ,

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

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

  • Abe
    Abe Member

    Thank you @DashboardDude .
    after constant talks with that department, this was not needed.

    Thank you again for all the assistant!

  • @Abe well glad to help out

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter