Correlation Matrix

Contents[Hide]

This function can only be used in formula visualizations, not formula measures.

The Correlation Matrix calculates the strength of the relationships between all possible pairings of the specified data series as a value between -1 and 1. Zero implies that the two series are independent; a value close to 1 implies they are positively correlated, and a value close to -1 implies they are negatively correlated. A negative correlation means that when the first input is large, the second input is small, and vice-versa.

Correlation Matrix
Correlation Matrix

Tip
The pre-set version of the Correlation Matrix shown above will appear in the Recommended Visualizations when you have a fitting metric set. See Using Dundas BI recommendations for more details.

1. Syntax

CORRMATRIX(d0...)

2. Input

The Correlation Matrix requires the following input:

  • d0 - The data series for which the Correlation Matrix is calculated. Must contain at least one data series.

3. Parameters

The Correlation Matrix does not use any parameters.

4. Output

 The Correlation Matrix function generates the following output:

  • Correlation Matrix – the Correlation Matrix result set containing a measure with the correlation values between pairs of measures, a hierarchy of measure names places on Rows, and a hierarchy of measure names placed on Columns in the metric set.

Note
You are not allowed to change the placement the hierarchies in the resulting metric set.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri