Overview of Aggregate Functions- FineBI Document

Last update： 2023-05-15

1. Overview

1.1 Application scenario

Comonent edit pane: Add caculation indicator

1.2 Function description

Aggregate functions can summarize a group of data. In general, aggregate functions are used to summarize the values and then calculate.
Different aggregate functions correspond to different aggregate methods, including sum, average, medium, maximum, minimum, standard deviation, variance, distinct count and count.
The column to be calculated is changed dynamically according to the dimensions when users swich the analysis dimension.

The sum aggregate function [SUM_AGG] is the most frequently used aggregate function and the following passage will use [SUM_AGG] as an exaple to explain aggregate function in details.

2. Function list

Function	Definition
SUM_AGG	Summarize the data in specified dimension(dragged to the analysis panel).
AVG_AGG	Return the summarized average of the indicator column according to current analysis dimension. The result is a column of data and the number of rows is the same as the number of rows in current analysis dimension.
COUNT_AGG	Count the data(the number of cells that are not null) in specified dimension(dragged to the analysis panel).
COUNTD_AGG	Count the distinct not null values(the number of distinct cells that are not null) in specified dimension(dragged to the analysis panel).
MIN_AGG	Return the minimum value of the indicator column according to current analysis dimension. The result is a column of data and the number of rows is the same as the number of rows in current analysis dimension.
MAX_AGG	Return the maximum value of the indicator column according to current analysis dimension. The result is a column of data and the number of rows is the same as the number of rows in current analysis dimension.
MEDIAN_AGG	Return the median of the indicator column according to current analysis dimension. The result is a column of data and the number of rows is the same as the number of rows in current analysis dimension.
VAR_AGG	Return the variance of the indicator column dynamically according to current analysis dimension. The result is a column of data and the number of rows is the same as the number of rows in current analysis dimension.
STDEV_AGG	Return the standard deviation of the indicator column according to current analysis dimension. The result is a column of data and the number of rows is the same as the number of rows in current analysis dimension.
PERCENTILE_AGG	Return the value from the expression according to current analysis dimension and the value is at the percentile corresponding to the specified number. The specified number must be between 0 and 1(include 0 and 1), e.g. 0.66 and must be a numerical constant.
APPROX_COUNTD_AGG	Count the approximate distinct values dynamically according to current analysis dimension. The result is a dynamic column of data and the number of rows is the same as the number of rows in current analysis dimension.

Previous：Switch

Next：APPROX_COUNTD_AGG

Helpful
Not helpful
Only read

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

English

Overview of Aggregate Functions

1. Overview

1.1 Application scenario

1.2 Function description

2. Function list

附件列表