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
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)
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
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
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)
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)
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
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)
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 modified 10mo ago