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.