Skip to navigation
Window functions

CumulativeStdDev

View as Markdown

The CumulativeStdDev function calculates the standard deviation of a column up to and including the current row value.

Syntax

CumulativeStdDev([Column])

Function Arguments:

  • [Column] (required) - The column of numbers to evaluate the cumulative standard deviation.

Cumulative functions depend on the order of the given column. If you change the sorting you change the result.

Example

CumulativeStdDev([Monthly Revenue])

A table contains the monthly revenue of a store. The CumulativeStdDev function can be used to find the standard deviation up to and including the current month.

Table with Month, Revenue, and Cumulative Standard Deviation columns from 2019-02 to 2020-05, where the standard deviation starts as null and declines from 56,268.57 to 17,464.77.