Custom Sort in bar charts
I followed Domo tutorial to create a custom sorting https://www.youtube.com/watch?v=QAKgsoRweQM but mine it's not working as I expect
Firts I created a beast mode to transform my column like this:
DATE_FORMAT(`Snapshot`,'%b')
and then I needed to sorting by month
so I try to create another beast mode like this:
(CASE
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Jan' THEN 1
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Feb' THEN 2
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Mar' THEN 3
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Apr' THEN 4
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Mai' THEN 5
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Jun' THEN 6
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Jul' THEN 7
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Aug' THEN 8
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Sep' THEN 9
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Oct' THEN 10
WHEN DATE_FORMAT(`Snapshot`,'%b') = 'Nov' THEN 11
else 12
end )
But when I use the filter the sequence it's not in the right timeline
Best Answer
-
@Cintia Is `Snapshot` already being used on the X-axis of your bar chart? If so, you shouldn't need to sort by date since Domo should already know to sort dates chronologically. If you are sorting by other fields as well, that could potentially mess with your date sorting.
1
Answers
-
@Cintia Is `Snapshot` already being used on the X-axis of your bar chart? If so, you shouldn't need to sort by date since Domo should already know to sort dates chronologically. If you are sorting by other fields as well, that could potentially mess with your date sorting.
1 -
@MichelleH Yes, I need it to be "implemented" then "firm" and "potential" how can I use both sorting?
0 -
@MichelleH When I do this the sorting by month keeps not working
0 -
0
-
@MichelleH both of them in MIN? or one in count and the other in MIN?
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 508 Automate
- 114 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive