VAR_AGG- FineBI Document

Last update： 2022-04-06

1. Overview

Grammar	VAR_AGG(array)	According to the current analysis dimension, the variance of the indicator field is dynamically returned, and the generated result is a dynamic data column with the number of rows consistent with the current analysis dimension.
Parameter	array	It 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.

2. Matters needing attention

The real-time data supports the use of a single numeric type parameter.

3. Examples

When the user's horizontal axis is the dimension field "Day", the value returned by the calculated field VAR_AGG (Sales) on the vertical axis is the daily sales variance.

When the user's horizontal axis is the dimension field "Month", the value returned by VAR_AGG (Sales) is the monthly sales variance.

Helpful
Not helpful
Only read

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

English

VAR_AGG

1. Overview

2. Matters needing attention

3. Examples

附件列表