SUMO CARD - Column Order
Comments
-
Can anyone help with this request?
0 -
In a sumo card, you can rearrange columns by dragging the columns up and down in the field list on the left (where the fields/columns are green).
0 -
thanks for your response user 07995
To clarify, I am trying to change the order of the Values that exist in a particular field/column.
The recommended solutions does not work for the above.
0 -
On a Sumo Card, you can select the "..." next to the name of the field on the Sumo Table and you will be able to sort the data in the column that you choose.
0 -
Was anyone able to fix this?
I have my columns sorted by FY (fiscal year), then broken down by Qtr (quarter), then broken down by Cal_Month (calendar month).The months don't always appear in the "natural" order: Q1 covers Oct-Nov-Dec. If I sort for Q1 by Descending order, it sorts them descending alphabetically (O-N-D), which is OK.
But this logic doesn't work for Q2 (Jan-Feb-March), in which I can choose Ascending (Feb-Jan-March) or Descending (March-Jan-Feb). Obviously, neither one of these is good.
Any ideas?
Thanks!
0 -
Hi user02412,
You can do this by making a new calculated field using an anlayzer card. Make sure to share the field to the dataset. The easy way to get a number for each month is to use CASE `Cal_Month` WHEN 'Oct' THEN 1 WHEN 'Nov' THEN 2 ... ELSE END. Adjust as required for your situation. Now you can sort on fiscal year and the new month number and it should sort as you need.
Let me know if you have any questions.
0 -
Thanks. I'm sure that will work.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive