STDEV_AGG - Standard Deviation- FineBI Help Document

Last update：January 06, 2025

Overview

Syntax	SUM_AGG(Array)	According to the current analysis dimension, this function returns the standard deviation of the field. The generated results are listed in a data column. The number of rows in the data column is consistent with that in the current analysis dimension.
Parameter	Array	The Array parameter must be the result returned by a non-aggregate function formula, which can be a calculation result of an indicator field, dimension or indicator field and a common formula.

Notes

The function supports one parameter of any type for real-time data.

Note:

STDEV_AGG in FineBI has the same function as STDEV.P() in Excel.

Example

If the horizontal axis is the dimension field Day, the value returned by the calculation field STDEV_AGG(Sales Volume) of the vertical axis is the standard deviation of sales per day.

If the dimension field in the lateral axis is Month, the value returned by the calculation field STDEV_AGG(Sales Volume) is the standard deviation of sales per month.

Previous：AVG_AGG - Average Value

Next：PERCENTILE_AGG - The Percentile

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

STDEV_AGG - Standard Deviation

Overview

Notes

Example

附件列表