...
Function | Description |
---|---|
average | This function returns the arithmetic average of the set of numbers. It takes one argument (a name of a field) of numeric type: Long, Float or Integer. It is only available if field on which it is applied, is of such type. |
maximum | |
minimum | |
sum | This function returns the maximum numeric value out of the set of numeric values. It takes one argument (a name of a field) of type, either: Long, Float, or Integer and it can be applied only on field of such type and only then it is available. |
minimum | This function returns the minimum numeric value out of the set of numeric values. It takes one argument (a name of a field) of type, either: Long, Float, or Integer and it can be applied only on field of such type and only then it is available. |
sum | This function returns the sum calculated by suming all the values in a given set of values. It is applicable only (and only then it is available) if the field name passed to this function represents numeric field of type: Long, Float or Integer. |
percent | |
distinct | |
count |