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 toany 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 toany 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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 507 Automate
- 113 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 25 Predict
- 9 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 39 Getting Started
- 25 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive