Heatmap Tables & Column Sorting

And probably for just regular "Tables" as well..
Not that im exciting to jump into looking at an Excel card within DOMO, but, how come there isnt a way to sort the column headers? or am i missing it?
Example:
I am creating a heatmap table with with 4 columns - Month, Requests, Leads, Cost
That is how i want them sorted - but the Table card automatically sorts the Column Headers in alpha. order so its Cost, Leads, Month, Request - this i dont want, but I cannot seem to find a way to sort them the first way and how I want them to be displayed.
Ideas?
Comments
-
When you Edit the card, on the bottom left side where the columns are listed, you can click on the little square icon in front of each field name and re-arrange the fields by dragging them up or down.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
I've run into this issue as well and have used a Beast Mode calculation as a workaround by assigning numbers to the text values in the field in the order I want them to sort. In your example:
CASE WHEN `field name` = "Month" THEN 1
WHEN `field name` = "Requests" THEN 2WHEN `field name` = "Leads" THEN 3
WHEN `field name` = "Cost" THEN 4
ELSE 5 END
Field name in the back ticks is whatever the name of the field you are pulling in. Once you save this it will became a field available that you can bring into your report in the sort and will sort numerically in the order you assigned them.
1 -
@michaelscott, did any of the above replies help address your question?
0 -
thanks for the replies!
will check them out this week and post back.
thank you
2 -
@michaelscott, great! Please let us know ?
1 -
0
-
@michaelscott, hope you were able to work it out!
2
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 650 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 752 Automate
- 187 Apps
- 477 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 140 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive