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)