Matrix heat chart

Matrix heat charts analyze relationships between two categorical fields, which can be visualized by count or summarized by a numeric field. Each cell in a matrix heat chart corresponds to the intersection of the categories from the Column and Row fields, and all records sharing those two category values will be aggregated into the same cell. For example, in the following diagram, all records with a value of C in the Row field and with a value of X in the Column field will be aggregated into the same cell.

Matrix heat chart

Variables

Matrix heat charts aggregate pairings between the Column and Row fields into a grid of cells.

Note:

The Column and Row fields must be of type date, integer, or text.

By default, a matrix heat chart displays the count of occurrences between the Column and Row field categories. Optionally, you can summarize a numeric variable by choosing a Number field and an Aggregation method. Applying a numeric variable is helpful when you want to investigate the patterns for a secondary field when two categories intersect. The aggregation method can be one of the following:

  • Count—The number of records in each cell
  • Sum
  • Mean
  • Median
  • Minimum
  • Maximum

Appearance

Several options control the chart appearance and related settings.

Titles and description

Charts and axes are given default titles based on the variable names and chart type. These can be edited on the General tab in the Chart Properties pane. You can also provide a chart Description, which is a block of text that appears at the bottom of the chart window.

Color

Grid cells are symbolized using graduated colors that correspond to a count or summarized value in the category pairings between the Column and Row fields. You can adjust a color classification Method, number of Classes, and Color scheme on the Data tab in the Chart Properties pane.

Sort

Matrix heat chart axes are automatically sorted alphabetically by their categories. Sorting for either axis can be changed using the Sort columns and Sort rows options in the Chart Properties pane. The following sort options are available for matrix heat charts:

  • Ascending—Categories are sorted in alphabetical order.
  • Descending—Categories are sorted in reverse alphabetical order.
  • Custom—Categories can be arranged manually in the Custom sort table.

Examples

Create a matrix heat chart to identify the flights that have the highest average arrival delay time between origin and destination city by setting the following properties:

  • ColumnDestCity
  • RowOrigCity
  • AggregationMean
  • NumberDelayTime

Matrix heat chart showing patterns in flight delays between cities.

Create a matrix heat chart to identify the cities that have the highest count of flights between origin and destination by setting the following properties:

  • ColumnDestCity.
  • RowOrigCity.
  • AggregationCount.
  • Number—Leave this property unset.

Matrix heat chart showing count of flights between cities.