Heatmaps

Heatmaps visualize numerical data for items in a Plan, typically from green to yellow to red (though these colors can be changed for each heatmap).

Heatmaps are Customizable, and can be bound to any data or Calculation, including catalog data, Dynamic Fields, or more granular Store Data. To customize Heatmaps, click the button beside the dropdown.

The Heatmap panel can be opened from View > Heatmaps. The current heatmap can be chosen from the Heatmap dropdown. This will also display Heatmap statistics along a color gradient: Minimum, Maximum, Median, and Average values.

It is common to use a Heatmap in conjunction with Labels, so colors and numbers can be seen together.

A Heatmap displaying sales data, with a corresponding Label

Relative vs Fixed Ranges

A Heatmap's range may be Relative (default), or Fixed.

A Relative-Range Heatmap colors the item with the lowest value found the "Minimum Color" (default red), the item with the highest value found the "Maximum Color" (default green), and everything else in between.

A Fixed-Range Heatmap allows one to specify lower and/or upper bounds. Anything under or over the bounds gets the minimum / maximum colors. Fixed-Range Heatmaps are often used for "pass/fail" metrics -- for example, identifying items performing under a determined threshold, such as X turns or dollars per week.

Heatmap range can be edited in the Customize Heatmaps dialog, by clicking the button, then checking the Min and/or Max checkboxes, and entering minimum / maximum range values in the inputs.

The Best Selling heatmap uses a Relative Range. The Weekly Sales heatmap uses a Fixed Range with a minimum of 500 and no maximum.
A heatmap with a relative range
A heatmap with a fixed range

Heatmap Colors

Heatap colors may be customized by clicking the button in the Customize Heatmaps dialog. This allows one to set custom colors for Minimum, Midpoint, and Maximum values. If a Midpoint color is not set, it is automatically calculated from tjehe Minimum and Maximum colors.

A heatmap with a custom color range defined
A heatmap with a custom color range defined
Build Better Planograms Copyright 1998-2026 Northwoods Software