# summarize

summarize operator is complicated in my opinion. 😄 And often I still forgot how to use it and even got it all wrong. Because summarize is used with many aggregation funcions. Here is the full list

### 📃List of aggregation functions

FunctionDescription

Returns one or more expressions when the argument is maximized

Returns one or more expressions when the argument is minimized

Returns an average value across the group

Returns an average value across the group (with predicate)

Returns aggregated value using the binary `AND` of the group

Returns aggregated value using the binary `OR` of the group

Returns aggregated value using the binary `XOR` of the group

Returns the minimal schema that admits all values of the `dynamic` input

Returns a count of the group

Returns a count with the predicate of the group

Returns an approximate distinct count of the group elements

Returns an approximate distinct count of the group elements (with predicate)

Returns a property bag of dynamic values within the group

Returns a property bag of dynamic values within the group (with predicate)

Returns a list of all the values within the group

Returns a list of all the values within the group (with predicate)

Returns a list of all the values within the group, including null values

Returns a set of distinct values within the group

Returns a set of distinct values within the group (with predicate)

Returns the maximum value across the group

Returns the maximum value across the group (with predicate)

Returns the minimum value across the group

Returns the minimum value across the group (with predicate)

Returns the percentile approximate of the group

Returns the percentiles approximates of the group

Returns the weighted percentile approximate of the group

Returns the weighted percentiles approximates of the group

Returns the standard deviation across the group

Returns the standard deviation across the group (with predicate)

Returns the sum of the elements within the group

Returns the sum of the elements within the group (with predicate)

Returns a random non-empty value for the group

Returns a random non-empty value for the group (with predicate)

Returns the variance across the group

Returns the variance across the group (with predicate)

Last updated