Problem with column sorting
Hi All,
I am sorting a dataset in the visualizer...I am sorting by the dealer name and whether the item got shipped or not and then by the order date all in the ascending order...
The beast mode that I am using for the shipped or not beast mode is the following:
CASE WHEN TRIM(`order_status`) = 'order shipped' then '1'
ELSE '2' END
The problem that I am facing is that if I remove the shipped or not from the columns (I am table chart) then the sorting get messed up meaning (dealer name ,shipped, not shipped,shipped appear as jumbled when the beast mode field is removed from the columns and just kept in the sorting in the left...
Do you have any suggestions..
Best Answer
-
Not 100% sure on how to fix the sorting when you don't have the column, but if you just don't want the column to show on the card, you can just hide it using Hide Columns under General chart properties.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2
Answers
-
Not 100% sure on how to fix the sorting when you don't have the column, but if you just don't want the column to show on the card, you can just hide it using Hide Columns under General chart properties.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2 -
Thank you so much @RobSomers !..Really appreciate your help!
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 435 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive