反馈已提交

网络繁忙

Analysis Function Overview

  • Last update：  2023-08-14

    • Overview

    DEF, DEF_ADD, and DEF_SUB functions allow users to modify or control the calculation level of detail (granularity), specifying the granularity of indicator-based calculation. 

    Where to Use


    		Where to Use
    Self-service datasetFormula Column
    Component

    Adding Calculation Indicator

    iconNote:
    DEF_ADD and DEF_SUB do not support output as dimension fields.

    Function List

    Function
    		Explanation

    DEF

    Definess only dimensions in the function.

    DEF_ADD

    Adds the dimension of the analysis area and the dimension of the function.

    The calculation is performed based on the dimension of the analysis area and the dimension specified in the DEF_ADD function.

    DEF_SUB

    Subtracts the dimension of the function from the dimension of the analysis area.

    The calculation is performed based on the dimension of the analysis area with ignorance of the dimension specified in the DEF_SUB.

    For example, you can use this function to view the average annual sales of delivered orders without viewing the sales of each order, even though data is grouped by order.

    EARLIER

    Used in DEF-type functions generally as a parameter for inter-row filtering calculation.

    Definition of Dimensions of the Analysis Area

    • For tables, dimensions of the analysis area refer to fields dragged into Dimension.

    分析概述1.png

    • For charts, dimensions of the analysis area refer to the dimension fields in Graphic Property and those dragged into the analysis area.

    分析概述2.png

    iconNote:
    Hidden fields of the analysis area are not involved in function calculation.

    Attachment List


    Theme： Advanced Data Analysis
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ
    中文（简体） 中文（繁體） English
    日本語

    フィードバック

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭