The heatmap feature is used to highlight wherever the data density is the highest as represented with the darkest shade of a color, followed by lighter shades of the same color proportional to the density of the data. In Analytics+ this is dynamically calculated and the range - enabling is also applied in a single click. You can also override the pre-calculated ranges and specify custom values.
1) Below we have a report in which we want to apply heatmap. To do this we first go to the Conditional Formatting tab and select Color scale and under Color scale choose the Sequential option:
2) In Sequential Color scale the charts are formatted as per the density of the data with the higher data density charts highlighted by darker shades of the same color and smaller data density charts highlighted with lighter shades of the same color:
3) We can even do the reverse of the same color scaling by using the Reversal Scale Option:
4) Finally, we can set the Heat map type as either Column wise or Table wise. So, in Column wise the charts will be formatted as per the column values whereas in table wise the charts will be formatted as per table values:
5) In addition to Sequential Color scaling we also have other options in heat map like Diverging, Qualitative, Color Blind, Continuous, Continuous - Diverging and Custom. However, in all these other options we have different colors for each chart and it not the same as the Sequential heat map where shades of the same color are used to depict the heatmap (lighter shades used to depict less data density and darker shades used to depict higher data density).
Diverging:
Qualitative:
Color Blind:
Continuous:
Continuous - Diverging:
Custom option where we can set the ranges ourselves:
FAQs:
Can we set different colors in Sequential color scale?
No in Sequential color scale we have different shades of one color with darker shades representing higher data density and lighter shades representing lesser data density.
Can we set custom ranges which is not the same as the one set in Analytics+?
Yes, we can set our own data ranges by using the Custom option under Color scale type.
