covariance() function

The covariance() function computes the covariance between two columns.

*Function type: Transformation
**Output data type:* Float

covariance(columns: ["column_x", "column_y"], pearsonr: false, valueDst: "_value")

Parameters

columns

A list of two columns on which to operate. Required

*Data type: Array of strings*

pearsonr

Indicates whether the result should be normalized to be the Pearson R coefficient.

*Data type: Boolean*

valueDst

The column into which the result will be placed. Defaults to "_value".

*Data type: String*

Examples

from(bucket: "example-bucket")
  |> range(start:-5m)  
  |> map(fn: (r) => ({r with x: r._value, y: r._value * r._value / 2}))
  |> covariance(columns: ["x", "y"])