Customize Color Theme / Reverse Order
I recently built a heatmap table where I want the lowest numbers up top. These start around -25 and end at -10 currently, but the numbers will change each time the chart is updated. I also only want to show 10 rows of data, so the table has been limited to the 10 top results.
I want the heatmap to display negative numbers as 'bad' thus using the light pink to red scale. Unfortunately, -25 is showing as light pink and -10 as dark red, but these should be the opposite as the darker color should annotate the worse number. I just want to reverse the way these colors are displayed, but I don't see that option.
Individual color rules won't necessarily work because next month the top number could be -50 and the bottom -1 for all I know and it makes much more sense to let the program do those calculations for color density.
I tried doing this in a normal table with heatmap settings and still have the same problem.
Best Answer
-
Try using a beast mode to multiply your value by -1 to flip the ordering and thus the color scheme. You can then also use the tooltip 1 for the actual value and display that in the tool tip / data value properties.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Try using a beast mode to multiply your value by -1 to flip the ordering and thus the color scheme. You can then also use the tooltip 1 for the actual value and display that in the tool tip / data value properties.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Or even simpler you could try and check the General > Reverse Color Direction option in the settings.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi @GrantSmith,
I don't see anywhere for a reverse color direction in the general options for either a standard table or heatmap table. I did use the -1 trick to reverse the order and the color is the correct now, but now I'm getting positive values (obviously). I annotated in the column heading that this was now an amount decrease. The 'tooltip' box is greyed out for me and doesn't seem to be an option?0 -
Hi @nshively,
If you're open to it, I would suggest using the heat map table instead of the table with heat map options. I know sounds confusing. It's like hearing "a rectangle is a square, but a square is not a rectangle"
Anyway, I made you a video to show you how to do so:
John Le
You're only one dashboard away.
Click here for more video solutions:
0 -
Thanks for the suggestion @DashboardDude. I will check out your website later for additional tips.
The problem you demonstrated is exactly my issue. Unfortunately, my internal customer did request multiple columns and only 1 of them be colored. However, they were fine with the numbers being positive (as long as the column header annotated this), so multiplying the values by -1 and flipping the table seemed to be the best solution in this case.0 -
Ah okay @nshively then yeah your best bet is to do the heatmap as a table. You can also choose "Diverging" and make numbers above zero green or something and below 0 red.
John Le
You're only one dashboard away.
Click here for more video solutions:
0 -
I was just trying to do this same thing and I think I figured it out. I'm showing # days until a payment is due and wanted the lower numbers to be the darker colors.
I changed my settings to "show diverging" then manually set the midpoint range to a number far higher than I'd ever see. Then I chose the same color theme for the upper and lower ranges.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive