Heat map tables - Ranges per column
Hi,
I have a table with multiple columns and different sets of numeric data and would like each column to have a heat map applied to identify the quintiles.
I have tried a heat map table but it seems to apply a single range across all of the columns. Therefore the range spans the columns with the highest values down to the lowest values in other columns. What I'm looking for is to have a range specific to the values in each column.
For example
Column A is a name
Column B might have values from 500 to 2000
Column C might have values from 1 to 10
Column D might have values from 1,000 to 10,000
It looks like the heat map is applied across all of the columns with a range of 1 to 10,000 rather than rendering the colours within the range of each column.
I can't do this with a normal table as I don't have the specific numeric thresholds for the colours, I just need them to be applied automatically based on the range of data within the columns.
Hope this makes sense.
Many thanks,
Tim
Best Answers
-
If you are using the Heatmap Table card under the Tables and Textboxes, you can set the heatmap to be on an individual column basis. Under Chart Properties, go to Scale and select Independent Column Ranges.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.4 -
Thanks Mark, much appreciated!
0
Answers
-
If you are using the Heatmap Table card under the Tables and Textboxes, you can set the heatmap to be on an individual column basis. Under Chart Properties, go to Scale and select Independent Column Ranges.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.4 -
Thanks Mark, much appreciated!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive