Customize Color Theme / Reverse Order

nshively
nshively Member
in Charting

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.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    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!**
  • GrantSmith
    GrantSmith Coach

    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!**
  • nshively
    nshively Member

    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?

  • DashboardDude
    DashboardDude Coach

    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:

    https://www.loom.com/share/f5a0f1a3793d4c1eaee1835d3b565561

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

  • nshively
    nshively Member
    edited May 2023

    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.

  • DashboardDude
    DashboardDude Coach

    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.

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

  • Mary_Moilanen
    Mary_Moilanen Member

    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.

    Heatmap filpped.png

Categories