Working with Heat Maps

About Heat Maps

A heat map displays the distribution of values for two data items by using a table with colored cells. If you do not assign a measure to the Color data role, then the cell colors represents the frequency of each intersection of values. If you assign a measure to the Color data role, then the cell colors represent the aggregated measure value for each intersection of values.

Specify Properties for a Heat Map

On the Properties tab, you can specify the following options:

Name

specifies the name of the visualization.

Title

specifies the title that appears above the graph.

Note: The Title option is disabled if you select Generate graph titles.

Generate graph titles

specifies that the graph title is generated automatically based on the data items in the visualization.

Bin count

specifies the number of value ranges that are represented as cells. Bin count only affects measures.

Show borders

specifies that the borders between cells are visible.

Rotate axis labels

displays the category labels at an angle.

Note: The Rotate axis labels option affects only the values on the X axis.

Note: The Rotate axis labels option has no effect if the heat map contains no categories.

Color gradient

selects the gradient colors for the visualization.

Fit line

adds a fit line to the visualization. For details about the fit types that are available, see Fit Line.

Note: Fit lines are not available if a category is assigned to the heat map.

Data Roles for a Heat Map

The basic data roles for a heat map are:

X Axis

specifies the data item that is assigned to the X axis.

Y Axis

specifies the data item that is assigned to the Y axis.

Color

specifies a measure that determines the cell color. If you do not assign the Color data role, then the cell color indicates frequency.

Note: You can drill down on a hierarchy only if it is assigned to the X axis.

Applying Data Analysis

About Data Analysis

For heat maps, you can apply the following data analyses:

Correlation

identifies the degree of statistical correlation between the variables in the visualization. For more information, see Correlation.

Fit Line

plots a model of the relationship between the variables in the visualization.

There are many types of fit lines, including linear fit, quadratic fit, cubic fit, and penalized B-splines. For more information, see Fit Line.

Correlation is applied to your visualization automatically when you add a linear fit line. It is not available with other fit types.

Enable Data Analysis

To add a fit line to your visualization, select Options

from the visualization toolbar and then select Fit Line

[fit-type]. For details about the fit types that are available, see Fit Line.