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

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.
Best Answer
-
Hi @Abe ,
Feel free to book some time and we can see what we can do: https://www.dashboarddudes.com/domo-help
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:
2
Answers
-
@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?
0 -
Hi @Abe ,
Feel free to book some time and we can see what we can do: https://www.dashboarddudes.com/domo-help
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:
2 -
Thank you @DashboardDude .
after constant talks with that department, this was not needed.Thank you again for all the assistant!
0 -
@Abe well glad to help out
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:
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive