DEF Function Application Collection

Entry level

Entry-level DEF-type functions

DEF (Specified Dimension)

DEF_ADD (Analysis Area Dimension and Specified Dimension)

DEF_SUB (Analysis Area Dimension with Ignorance of Specified Dimension)

EARLIER — Getting Value of the Current Row (Only for DEF, DEF_ADD, and DEF_SUB Functions)

DEF Application

DEF

Cohort Analysis

Horizontal Proportion of Cross Tables

Dimension field output by DEF

Purchase Frequency Analysis

DEF nesting

Detailed Analysis of Goal Completion

DEF nesting

Monthly Profit Days Statistics

DEF nesting + Cross-row calculation

Cross-Row Calculation of Growth Rate

DEF nesting + Dimension analysis

Consumption Cycle

DEF nesting + Parameter

Sales Gap Analysis

DEF + EARLIER

Conversion Rate Analysis

DEF_ADD application

DEF_ADD

Sales of Each Client in Different Provinces

DEF_ADD nesting + EARLIER

YOY Ratio of Accumulated Sales as of Each Month

Displaying the Sales of the Previous Three Months

DEF_SUB application

DEF_SUB

Average Value Calculated by Multiple Dimensions