How can I change the order of columns in chart?

Hi guys, I have been trying to reorder my chart chronologically backwards. I have 3 columns that I want from left to right, Current Year, 3 years ago, 5 years ago.
The table is transposed. Every column header on the left (transposed) is a beast mode. I have tried clicking the arrows next to 'Year of Tour' and it never gets it in the right order. I have also tried dragging the column into the sorting section in analyzer and have tried every aggregation/ascending/descending combination.
Is there something in the 'Year of Tour' beast mode I need to add to get it in the right order? Is there a function in beast mode that can sort chronologically?
Best Answer
-
Create a new beast mode to return an integer based on the order and then use that in the sort of the card:
CASE WHEN `Year of Tour` = '5 Years Ago' THEN 3 WHEN `Year of Tour` = '3 Years Ago' THEN 2 WHEN `Year of Tour` = 'Current' THEN 1 END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Create a new beast mode to return an integer based on the order and then use that in the sort of the card:
CASE WHEN `Year of Tour` = '5 Years Ago' THEN 3 WHEN `Year of Tour` = '3 Years Ago' THEN 2 WHEN `Year of Tour` = 'Current' THEN 1 END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Yes, that's it. Not sure why I didn't think of that. Thanks Grant.
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive