기본 콘텐츠로 건너뛰기

Aggregation functions

The family of functions known as aggregation functions consists of functions that take multiple field values as their input and return a single result, where the aggregation is defined by a chart dimension or a group by clause in the script. Aggregation functions include Sum(), Count(), Min(), Max(), and many more..

Most aggregation functions can be used in both the data load script and chart expressions, but the syntax differs.

Using aggregation functions in a data load script

Aggregation functions can only be used inside LOAD statements..

Using aggregation functions in chart expressions

The argument expression of one aggregation function must not contain another aggregation function.

표현식에는 내부 집계에 TOTAL 한정자가 포함된 경우를 제외하고, 집계 함수가 포함되지 않아야 합니다. 고급 중첩 집계가 필요한 경우는 고급 집계 함수 Aggr을 계산 차원과 함께 사용하십시오.

An aggregation function aggregates over the set of possible records defined by the selection. However, an alternative set of records can be defined by using a set expression in set analysis.

집합 분석 및 집합 표현식