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?
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.
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 2
WHEN `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.
@michaelscott, great! Please let us know ?1
@michaelscott, hope you were able to work it out!2
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 78 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive