Overview of Aggregate Functions

  • Last update：May 15, 2023

    • 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_AGGReturn 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_AGGCount 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_AGGReturn 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_AGGReturn 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_AGGReturn 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_AGGReturn 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_AGGReturn 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_AGGCount 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.


    附件列表


    主题： Advanced Data Analysis
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read
    中文（简体） 中文（繁體） 日本語
    English

    滑鼠選中內容，快速回饋問題

    滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    How to Get Quotes：
    FineReport FineBI
    Demonstration Booking：
    FineReport FineBI
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy