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
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive