EMEA SD Team
Category
Integration
Product Version
7.4
Add more colours to heat grid chart
Idea Logged
I have a Heat Grid chart and I would like it to offer more than just three colours.
My heat grid is based on consumption data so it would be great if it could go through a number of colours as the consumption gets higher. As the current three colours include the negative of the max, it currently only means that the middle and max colours are actually used in my data set (I have no negative numbers).
Would it be possible to either make the min colour based on the min value from the data set and not the negative of the max? or is it possible to use more colours in this chart?
regards
I like this idea 
Hi Ed,
Thanks for reaching out. There are indeed only 3 color options in the Heat Grid chart type. I'm not sure if I entirely understand your question regarding making the min colour based on the min value from the data set, but I'm thinking you may be able to accomplish this by changing the Color > Style: Range, instead of Style: Auto
In terms visualizations for indicating a value is larger than another, this doesn't have to mean extra colors. What you could do instead is add the same metric to the Size box, so that higher values will not just be the Max (or closer to the Max) color value, but also be larger in size. Now my chart essentially gives two indications of how much more the Invoiced Amount was in December vs. July, for example:
Failing that, another option here would be to submit this as an Idea instead, and I can create an enhancement request to add more colors. Regardless though, even if this enhancement would be chosen for future development, it'd be many months before actually being implemented, so I think my above suggestion may be worth considering anyways.
Please let me know how this solution works for you and how you'd like to proceed.
Regards,
Mike
Hi Ed,
Thanks for reaching out. There are indeed only 3 color options in the Heat Grid chart type. I'm not sure if I entirely understand your question regarding making the min colour based on the min value from the data set, but I'm thinking you may be able to accomplish this by changing the Color > Style: Range, instead of Style: Auto
In terms visualizations for indicating a value is larger than another, this doesn't have to mean extra colors. What you could do instead is add the same metric to the Size box, so that higher values will not just be the Max (or closer to the Max) color value, but also be larger in size. Now my chart essentially gives two indications of how much more the Invoiced Amount was in December vs. July, for example:
Failing that, another option here would be to submit this as an Idea instead, and I can create an enhancement request to add more colors. Regardless though, even if this enhancement would be chosen for future development, it'd be many months before actually being implemented, so I think my above suggestion may be worth considering anyways.
Please let me know how this solution works for you and how you'd like to proceed.
Regards,
Mike
Replies have been locked on this page!