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"1 -
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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 468 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive