Using AX Web Client > Interpretations and Visualizations > Visualizing results data in charts > Heat map chart

Heat map chart

A heat map is a graphical representation of data where the individual values contained in a matrix are represented as colors. Data points are defined by an x and y axis intersection and a third value that determines the data point's color.

When do you use it?

Use heat maps to compare variables across a large number of categories and to sort complex data by color intensity.

How does it work?

Data values

Data values appear as boxes on the heat map. The size and color of each box are determined by the data for that item:

size determined by the concentration of x and y axis categories and is not configurable
color determined by the calculated value specified in the Color by setting

Colors

The lowest values are colored green, the mid-range values are colored yellow, and the highest values are colored red. Data points are colored using one of the following display setting coloring schemes:

color gradient continuous change from green, through yellow, to red following individual data values
stepped color scale data values grouped into five equidistant categories and displayed using discrete colors

Data configuration settings

Setting	Supported data types	Description
X-Axis	character	The field to use as the category on the chart’s horizontal scale.
Y-Axis	character	The field to use as the category on the chart’s vertical scale.
Color by	numeric	The field that determines the color of the box at the intersection of the X and Y axis values: Count calculates the count of records that match each intersection of X and Y axis values Average, Sum, Min, Max calculates the selected statistical value for the numeric field selected at each intersection of X and Y values

Setting

Supported data types

Description

X-Axis

character

The field to use as the category on the chart’s horizontal scale.

Y-Axis

character

The field to use as the category on the chart’s vertical scale.

Color by

numeric

The field that determines the color of the box at the intersection of the X and Y axis values:

Count calculates the count of records that match each intersection of X and Y axis values
Average, Sum, Min, Max calculates the selected statistical value for the numeric field selected at each intersection of X and Y values