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 dataset | Formula Column |
| Component |
Note: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. |
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.
For charts, dimensions of the analysis area refer to the dimension fields in Graphic Property and those dragged into the analysis area.
Note:
