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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive