How can I sort by half hour intervals?
Hi there,
I'm unable to figure out how to sort my card by half hour intervals. It seemed to be fine at first, but when changing date ranges, the intervals shift in seemingly random ways. I have a date field, `contactStart`, that's formatted as YYYY-MM-DD HH:MM:SS (example: 2018-06-18 14:41:28). I've tried the following sorting options with no success:
'contactStart' - minimum and no aggregation
HOUR('contactStart') - minimum and no aggregation
FLOOR('contactStart') - minimum and no aggregation
Please note, my X-Axis must be sorted in half hour intervals, so I've applied the following Beast Mode:
CONCAT(Hour(`contactStart`),':',CASE WHEN MINUTE(`contactStart`)>=30 THEN '30' ELSE '00' END)
Any solution or guidance would be greatly appreciated!
Thanks.
Best Answer
-
I think the issue has to do when using CONCAT, this is converting your time to a text field and so time sorting won't work.
You might try creating a second beastmode:TIME(CONCAT(Hour(`contactStart`),':',CASE WHEN MINUTE(`contactStart`)>=30 THEN '30' ELSE '00' END))
And use that in your sorting section. That should order your times appropriately.
Let me know if you still have issues,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Answers
-
I think the issue has to do when using CONCAT, this is converting your time to a text field and so time sorting won't work.
You might try creating a second beastmode:TIME(CONCAT(Hour(`contactStart`),':',CASE WHEN MINUTE(`contactStart`)>=30 THEN '30' ELSE '00' END))
And use that in your sorting section. That should order your times appropriately.
Let me know if you still have issues,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Thank you very much! This worked like a charm.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive