Tom Azernour avatar
Written by Tom Azernour
Updated over a week ago

Type: Aggregator

Function: VARIANCE

Syntax: VARIANCE(number)

Description: Returns the variance (the square of the average distance to the mean value) for the provided field/expression, for each grouping (set of dimensions).

The variance is related to the standard deviation via the formula VARIANCE = STDDEV^2.

Sample usage:

  • VARIANCE(lines_changed) returns the variance for the lines_changed field value.

  • VARIANCE(required_approval_remaining_count) returns the variance for the required_approval_remaining_count field value.

Did this answer your question?