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​
Function
Description
​arg_max()​
Returns one or more expressions when the argument is maximized
​arg_min()​
Returns one or more expressions when the argument is minimized
​avg()​
Returns an average value across the group
​avgif()​
Returns an average value across the group (with predicate)
​binary_all_and​
Returns aggregated value using the binary AND of the group
​binary_all_or​
Returns aggregated value using the binary OR of the group
​binary_all_xor​
Returns aggregated value using the binary XOR of the group
​buildschema()​
Returns the minimal schema that admits all values of the dynamic input
​count()​
Returns a count of the group
​countif()​
Returns a count with the predicate of the group
​dcount()​
Returns an approximate distinct count of the group elements
​dcountif()​
Returns an approximate distinct count of the group elements (with predicate)
​make_bag()​
Returns a property bag of dynamic values within the group
​make_bag_if()​
Returns a property bag of dynamic values within the group (with predicate)
​make_list()​
Returns a list of all the values within the group
​make_list_if()​
Returns a list of all the values within the group (with predicate)
​make_list_with_nulls()​
Returns a list of all the values within the group, including null values
​make_set()​
Returns a set of distinct values within the group
​make_set_if()​
Returns a set of distinct values within the group (with predicate)
​max()​
Returns the maximum value across the group
​maxif()​
Returns the maximum value across the group (with predicate)
​min()​
Returns the minimum value across the group
​minif()​
Returns the minimum value across the group (with predicate)
​percentiles()​
Returns the percentile approximate of the group
​percentiles_array()​
Returns the percentiles approximates of the group
​percentilesw()​
Returns the weighted percentile approximate of the group
​percentilesw_array()​
Returns the weighted percentiles approximates of the group
​stdev()​
Returns the standard deviation across the group
​stdevif()​
Returns the standard deviation across the group (with predicate)
​sum()​
Returns the sum of the elements within the group
​sumif()​
Returns the sum of the elements within the group (with predicate)
​take_any()​
Returns a random non-empty value for the group
​take_anyif()​
Returns a random non-empty value for the group (with predicate)
​variance()​
Returns the variance across the group
​varianceif()​
Returns the variance across the group (with predicate)
​

Function	Description
arg_max()	Returns one or more expressions when the argument is maximized
arg_min()	Returns one or more expressions when the argument is minimized
avg()	Returns an average value across the group
avgif()	Returns an average value across the group (with predicate)
binary_all_and	Returns aggregated value using the binary `AND` of the group
binary_all_or	Returns aggregated value using the binary `OR` of the group
binary_all_xor	Returns aggregated value using the binary `XOR` of the group
buildschema()	Returns the minimal schema that admits all values of the `dynamic` input
count()	Returns a count of the group
countif()	Returns a count with the predicate of the group
dcount()	Returns an approximate distinct count of the group elements
dcountif()	Returns an approximate distinct count of the group elements (with predicate)
make_bag()	Returns a property bag of dynamic values within the group
make_bag_if()	Returns a property bag of dynamic values within the group (with predicate)
make_list()	Returns a list of all the values within the group
make_list_if()	Returns a list of all the values within the group (with predicate)
make_list_with_nulls()	Returns a list of all the values within the group, including null values
make_set()	Returns a set of distinct values within the group
make_set_if()	Returns a set of distinct values within the group (with predicate)
max()	Returns the maximum value across the group
maxif()	Returns the maximum value across the group (with predicate)
min()	Returns the minimum value across the group
minif()	Returns the minimum value across the group (with predicate)
percentiles()	Returns the percentile approximate of the group
percentiles_array()	Returns the percentiles approximates of the group
percentilesw()	Returns the weighted percentile approximate of the group
percentilesw_array()	Returns the weighted percentiles approximates of the group
stdev()	Returns the standard deviation across the group
stdevif()	Returns the standard deviation across the group (with predicate)
sum()	Returns the sum of the elements within the group
sumif()	Returns the sum of the elements within the group (with predicate)
take_any()	Returns a random non-empty value for the group
take_anyif()	Returns a random non-empty value for the group (with predicate)
variance()	Returns the variance across the group
varianceif()	Returns the variance across the group (with predicate)

where

arg_max()

Last modified 1yr ago

summarize

📃List of aggregation functions​

📃List of aggregation functions