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 thelines_changed
field value.VARIANCE(required_approval_remaining_count)
returns the variance for therequired_approval_remaining_count
field value.