Overview
Syntax | VAR_AGG(Array) | According to the current analysis dimension, this function dynamically returns the variance of the field. The generated results are listed in a dynamic 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 numeric parameter for the real-time data.
Example
If the horizontal axis is the dimension field Day, the value returned by the calculation field VAR_AGG(Sales Volume) of the vertical axis is the variance of sales per day.
If the dimension field in the lateral axis is Month, the value returned by the calculation field VAR_AGG(Sales Volume) is the variance of sales per month.
Previous：MEDIAN_AGG - Median
