All eazyBI for Jira eazyBI for Confluence Private eazyBI

Correlation

Returns the correlation coefficient between two numeric expressions over a specified set. The result is a number between -1 and 1, where:

  • 1: A perfect positive correlation (as one series increases, the other increases proportionally).
  • -1: A perfect negative correlation (as one series increases, the other decreases proportionally).
  • 0: No linear correlation.

Syntax

Correlation(Set_Expression, Y_Numeric_Expression [, X_Numeric_Expression])

Arguments

Set_Expression

A set of members (usually from a dimension such as Time, Project, or Sprint) over which the correlation is calculated.

Y_Numeric_Expression

A valid numeric MDX expression that represents the values for the y-axis (Series Y).

X_Numeric_Expression

(Optional) A valid numeric MDX expression that represents the values for the x-axis (Series X).

Examples

The Correlation function calculates the strength of the linear relationship (the correlation coefficient) between two data series, Series Y and Series X, as evaluated across the members of a given set.

The function works by evaluating the Set_Expression against the first numeric expression (Y_Numeric_Expression) to obtain the values for Series Y. It then evaluates the set against the second expression (X_Numeric_Expression) for Series X values.

If X_Numeric_Expression is not specified, the function uses the current context of the cells in the specified set as the values for the X-axis instead. The result is a single value between -1 and 1 indicating how closely the two series move together.

Use the Numeric → Decimal formatting for the measure using this function.

Correlation between issues created and resolved by month

The following formula calculates how strongly the number of issues created and resolved correlate over months.
A result close to 1 means that months with many created issues also tend to have many resolved issues.

Correlation(
  [Time].[Month].Members,
  [Measures].[Issues created],
  [Measures].[Issues resolved]
)

Correlation between story points committed and completed per sprint

The following formula measures how closely sprint commitment aligns with actual completion.
A value near 1 indicates consistent delivery relative to commitment; a lower value implies variability between committed and completed story points.

Correlation(
  [Sprint].[Sprint].Members,
  [Measures].[Story Points committed],
  [Measures].[Story Points completed]
)