How to set colors and legend categories in Heat Maps

[Former Member]

I have created a heat map.  The initial colors set by Design Studio are light green to dark green.  But the heat map displays a bunch of colors.  It appears that I can set the legend categories on the properties tab by including them in brackets, like [-50,-25,0,25,50,100] but that does not work for me either.

I am currently running DS1.5 15.0.6. With Microsoft IE 9.0.  Yes I am trying to get IT to upgrade for me!

But in Design Studio the display is not correct.  I can change the legend title.   DS displays the colors in RED (good) to Blue (bad) while on the right side (of the screen print below)  you can see the default light green to dark green is set by DS when it inserts a heat map chart type.

I am assuming the Start color would be the lowest value and the End color would be the highest.

I also tried to set the categories to [-2,000,000, -1,500,000,  etc ]  I include the comma as zero separators here for readability.

I can agree that the displaying of the application may be related to my IE9.0 but I would expect DS to display the desired colors inside DS.

Has anyone run into this and can show me the errors of my ways?

Thanks.

Jim Vaillancourt

[Former Member]

Hi James,

I face this problem too.

The workaround I used is to use tree map. First create a dummy measure which always equals to one. Then assign this dummy measure to the size of the tree map, so all the size will be the same.

Start color and end color work fine in tree map.

Best,

Alfred

[Former Member]

Hello,

I have the same problem. It does not seem like changing the Start Color, End Color or the Legend Values properties has any effect. By looking around on SCN I can see that this problem has been present since 1.4 (at least - I don't remember when Heat Maps was first introduced in Design Studio). In my opinion it seem like Heat Maps are basically broken.

One work-around is to add conditional formatting to the Heat Map chart - this seems to supercede the range colors. Note that this makes the rendering of the chart extremely slow depending on the amount of data you are visualizing, so it might not be a usable work-around. Also the legend will no longer match up with the value ranges and colors used in the chart, so you will have to hide it.

Regards, Janus