Documentation

    Correlation matrix

    Correlation matrix shows the Pearson correlation between numeric columns in a colored grid, so you can see at a glance which of them move together.

    Compare three measurements

    Eight people's height, arm span and reading time go into one grid. Height and Arm span almost move as one, while Reading minutes has a correlation close to zero with both.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    Result
    Height cmArm span cmReading minutes
    15015120
    15515440
    16016230
    16516410
    17017210
    17517430
    18018140
    18518420
    1. In the Data tab, remove one entry from Variables. The grid shrinks to the remaining columns.
    2. Change Variable order from Default to Descending to reorder the rows and columns.
    3. Open the Design tab, expand Cells and change Cells shown from Full matrix to Lower triangle to hide the mirrored half.

    When to use

    Use Correlation matrix before charting, to decide which pairs of numeric columns deserve a closer look. Once you've picked a pair, Scatter plot shows the points behind the number.

    Inputs

    1 port
    Table

    Accepts: Tables.

    Accepts one connection on this port.

    Settings

    A correlation matrix needs 2 to 24 numeric columns. Date grouping, summaries and missing periods don't apply.

    Variables

    Number columns to correlate in pairs, up to 24.

    Variable order

    Order of the columns on both axes.

    Default: Default

    Options: Default, Ascending, Descending.

    32 more settings
    Show tooltip

    Shows or hides values when you hover over a mark.

    Default: true

    Tooltip

    Text shown when you hover over a mark. Write it in the editor and insert values from Values.

    Values

    Values you can insert into the text. Each row calculates a value from a source field or, in charts, shows a chart value, and can have its own number or date format.

    Title

    Title shown inside the chart. Leave empty to hide it.

    Title color

    Color of the title.

    Title size

    Size of the title, in pixels.

    Default: 24

    Title alignment (plot)

    Alignment of the title.

    Default: Left

    Options: Left, Center, Right.

    Cells shown

    The full matrix or only one triangle. The lower triangle includes the diagonal and the upper one doesn't. Numbers show two decimal places.

    Default: Lower triangle

    Options: Lower triangle, Upper triangle, Full matrix.

    Cell content

    Colors the cells, shows the numbers or both.

    Default: Color

    Options: Color, Number, Color + number.

    Cell outlines

    Shows or hides a border around each cell.

    Default: false

    Number size

    Size of the cell numbers, in pixels (8–24).

    Default: 10

    Number color

    Color of the cell numbers.

    Axis titles

    Shows or hides the titles on both axes.

    Default: true

    Horizontal title

    Title of the X axis. Leave empty to use the field names.

    Vertical title

    Title of the Y axis. Leave empty to use the field names.

    Axis label size

    Size of the X axis labels, in pixels.

    Default: 12

    X label angle

    Angle of the X axis labels. Auto turns them when they don't fit.

    Default: Auto

    Options: Auto, 0°, 45°, 90°.

    Tick color

    Color of the axis labels.

    Axis title color

    Color of the axis titles. Auto matches the axis labels.

    X title size

    Size of the X axis title, in pixels.

    Default: 12

    X title distance

    Extra space between the X axis labels and the title, in pixels.

    Default: 4

    Y title size

    Size of the Y axis title, in pixels.

    Default: 12

    Y title distance

    Extra space between the Y axis labels and the title, in pixels.

    Default: 4

    Background

    Card background color. Auto follows the theme.

    Plot padding

    Space between the card edge and the chart, in pixels.

    Default: 0

    Axis frame

    Shows or hides the axis lines around the plot.

    Default: true

    Frame color

    Color of the axis lines.

    Decimal places

    Most decimal places shown on value-axis labels and in tooltips.

    Default: 2

    Always show decimal places

    Pads values to the decimal places, so with 2, 2630 shows as 2,630.00.

    Default: false

    Thousands separators

    Groups digits, so 2630 shows as 2,630.

    Default: true

    Corner radius (px)

    Corner radius in whole logical pixels.

    Default: 0

    Border width (px)

    Border width in whole logical pixels.

    Default: 0

    Correlation matrix FAQs

    Why does my correlation matrix show an error?
    It needs at least two numeric columns. Pick them under Variables in the Data tab.
    Does correlation use all rows?
    It uses only rows with valid numbers in every selected column. A constant column, or fewer than two complete rows, gives no coefficient.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.