How do I sort my time of day ranges on a card so it is in chronological order?

I created a time of day beast mode below which works successfully. I am using a bubble chart to show the time od day most events occur. This also works successfully however, I would like to be able to sport my time of day in chronological order. I have tried to use the beast mode created below in the sort as both assending and decending but it is not giving me the times in chronoolocal order on the chart.
CASE
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('6:00 am') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('7:00 am') THEN '6:00am-7:00am'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('7:01 am') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('8:00 am') THEN '7:00am-8:00am'
WHEN TIMESTAMP(`EVENTTIME`)>= TIMESTAMP('8:01 am') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('9:00 am') THEN '8:00am-9:00am'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('9:01 am') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('10:00 am') THEN '9:00am-10:00am'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('10:01 am') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('11:00 am') THEN '10:00am-11:00am'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('11:01 am') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('12:00 pm') THEN '11:00am-12:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('12:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('1:00 pm') THEN '12:00pm-1:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('1:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('2:00 pm') THEN '1:00pm-2:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('2:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('3:00 pm') THEN '2:00pm-3:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('3:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('4:00 pm') THEN '3:00pm-4:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('4:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('5:00 pm') THEN '4:00pm-5:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('5:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('6:00 pm') THEN '5:00pm-6:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('6:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('7:00 pm') THEN '6:00pm-7:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('7:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('8:00 pm') THEN '7:00pm-8:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('8:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('9:00 pm') THEN '8:00pm-9:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('9:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('10:00 pm') THEN '9:00pm-10:00pm'
WHEN TIMESTAMP(`EVENTTIME`)> TIMESTAMP('10:01 pm') AND TIMESTAMP(`EVENTTIME`)<= TIMESTAMP('11:00 pm') THEN '10:00pm-11:00pm'
ELSE 'Overnight (11:01pm-5:59am)' END
Not in Chronological Order:
Answers
-
@user028582 I recommend adding the beast mode below as a sort field in your card to order all these times chronologically:
HOUR(`EVENTTIME`)
2 -
Thank you!
0 -
That worked thanks again!😀
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive