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
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive