Heatmap Table Colors Not Working

I am trying to use the HeatMap Table (please note that I am not trying to use the 'Heat Map', but rather the 'Heatmap Table' under tables), but unfortunately I am not having any luck getting the colors to reflect the variances between the numbers. Any assistance on this would be great! Thanks.

 

Attached is an image of the table I'm trying to modify.

 

Best Answer

  • RGranada
    RGranada Contributor
    Answer ✓

    I Think i know what is going on.  Domo is using the year number to calculate the intervals of your heat map.

    One way to avoid this is no to allow Domo to do this by making impossible for Domo to convert the year to a number.

     

    You can achieve this by using the following beastmode instead of the year field:

    Concat(' ',`Year`)

     

    Sending a screen cap illustrating my idea.

    Hope it helps!

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.

Answers

  • AS
    AS Coach

    I bet your null values are involved in the distribution monotony.  I'm not sure how to handle that.  That said, I like to change the scale to log as well as change the theme to one that has more colors.  Try a combination of those and let us know if it helps.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Thanks AS for your response! I tried replacing the null values with zeros, but unfortunately it still did not fix the color scaling. Attached is a copy of the new table with zeros.

  • RGranada
    RGranada Contributor

    Are those all the values you wan't to show?

    What is your minimum value and maximum Value?

     

     

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • Yes, those are all of the values I am wanting to show. The minimum is 0 and the maximum is 291.

  • RGranada
    RGranada Contributor

    And there are no nulls, right?

    Are there any aggregations on the columns?

    Are the chart properties the default ones?

     

     

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • This is an aggregate of the columns and the chart properties are set to default.

  • RGranada
    RGranada Contributor
    Answer ✓

    I Think i know what is going on.  Domo is using the year number to calculate the intervals of your heat map.

    One way to avoid this is no to allow Domo to do this by making impossible for Domo to convert the year to a number.

     

    You can achieve this by using the following beastmode instead of the year field:

    Concat(' ',`Year`)

     

    Sending a screen cap illustrating my idea.

    Hope it helps!

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • RGranada
    RGranada Contributor

    Also there is  a kind of a bug here, because even if domo takes the values in the first column into account while calculating the max and min values, it does not apply the interval color to the first column.

     

    You can verify this with a simple swap of the columns.

     

    Hope this helps!

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • Thanks RGranada! That solved it for me!

This discussion has been closed.