Overview
to be filled
Remarks
Formula specifies the method of evaluation of row values. Formula enumeration can be one of following values;
| Value | Description |
|---|---|
| None | No aggregation is applied. All values in rows. |
| Count | Count of row values. |
| CountDistinct | Count of distinct values in rows. |
| Sum | Sum of row values. Valid for numeric type columns. |
| SumDistinct | Sum of distinct values in rows. Valid for numeric type columns. |
| Avg | Average of row values. Valid for numeric type columns. |
| AvgDistinct | Average of distinct values in rows. Valid for numeric type columns. |
| Min | Minimum value in rows. |
| Max | Maximum value in row values. |
| StdDev | Standard deviation of row values. |
| DateDiff | Difference between two date values. Valid for date and datetime type columns. |
| DatePart | Crops out the specified part of date values and gives the kept part as number value. Valid for date and datetime type columns. |
| DateTrunc | Truncates date values except the specified date part and gives a date value. Valid for date and datetime type columns. |
When using a formula, refer it with "expression" label instead of "formula" for formulas that accept specific parameters. See the examples below.