Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FunctionDescription
averageThis 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.
minimumThis 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.
sumThis 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