Formatting Heatmap and Table card
On a heatmap, is there a way to add titles to the top (instead of the bottom, or both) and have totals at the end of the column or rows?
For a table card, is there a way to add a blank column in the middle? I have six columns, but want a blank column in the middle.
I would also like to be able to shade a column a different color. Is there a way to do this?
Best Answer
-
For the Beast Mode, that is correct. If would essentially look like this:
It will need a label, and I don't think it will support just a space character " ". So you will have to consider what the label should look like, whatever makes sense for your use case.
For setting the color of a column, I do not believe it is a column-specific setting, rather you set the theme for the entire table like this:
-----
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"1
Answers
-
Hi @tleong - I do not believe titles are supported at the top of Heatmap cards (although if you are creative enough, you can do pixel art with them, as one colleague did!)
The closest I can suggest for getting a title on top of your Heatmap is to leverage the Summary Number label.
If you are looking to get more details out of a "Heatmap-like" card, I would recommend using a Sumo Card, where you can turn on subtotals/totals and use conditional formatting on columns that behaves similarly to a heatmap.
Depending on what your end-goal is, a "Heatmap Table" card will let you have column labels, but does not support totals.
As for showing a blank column in the middle, you can do a Beast Mode where the formula is simply an empty text string (i.e. '').
As for using multiple colors, you can see with the Mario pixel art above that you have flexibility in which colors are used for different number ranges, but as for controlling the colors used in different columns, I am not sure if that can be done.
-----
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"2 -
For the blank column beast mode, I'm assuming I need a title. If I want the title to be inconspicuous, can I name the beast mode "." or "_"? Also, the text of the beast mode would just be ""?
If I want the entire column in a table card to be a certain color, what would the command be to execute this?
0 -
For the Beast Mode, that is correct. If would essentially look like this:
It will need a label, and I don't think it will support just a space character " ". So you will have to consider what the label should look like, whatever makes sense for your use case.
For setting the color of a column, I do not believe it is a column-specific setting, rather you set the theme for the entire table like this:
-----
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"1
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