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 Linethen select[fit-type]. For details about the fit types that are available, see Fit Line.