# summarize **summarize** operator is complicated in my opinion. :smile: 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](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/summarizeoperator#list-of-aggregation-functions) | Function | Description | | ------------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------------------- | | [arg\_max()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/arg-max-aggfunction) | Returns one or more expressions when the argument is maximized | | [arg\_min()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/arg-min-aggfunction) | Returns one or more expressions when the argument is minimized | | [avg()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/avg-aggfunction) | Returns an average value across the group | | [avgif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/avgif-aggfunction) | Returns an average value across the group (with predicate) | | [binary\_all\_and](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/binary-all-and-aggfunction) | Returns aggregated value using the binary `AND` of the group | | [binary\_all\_or](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/binary-all-or-aggfunction) | Returns aggregated value using the binary `OR` of the group | | [binary\_all\_xor](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/binary-all-xor-aggfunction) | Returns aggregated value using the binary `XOR` of the group | | [buildschema()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/buildschema-aggfunction) | Returns the minimal schema that admits all values of the `dynamic` input | | [count()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/count-aggfunction) | Returns a count of the group | | [countif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/countif-aggfunction) | Returns a count with the predicate of the group | | [dcount()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/dcount-aggfunction) | Returns an approximate distinct count of the group elements | | [dcountif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/dcountif-aggfunction) | Returns an approximate distinct count of the group elements (with predicate) | | [make\_bag()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/make-bag-aggfunction) | Returns a property bag of dynamic values within the group | | [make\_bag\_if()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/make-bag-if-aggfunction) | Returns a property bag of dynamic values within the group (with predicate) | | [make\_list()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/makelist-aggfunction) | Returns a list of all the values within the group | | [make\_list\_if()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/makelistif-aggfunction) | Returns a list of all the values within the group (with predicate) | | [make\_list\_with\_nulls()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/make-list-with-nulls-aggfunction) | Returns a list of all the values within the group, including null values | | [make\_set()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/makeset-aggfunction) | Returns a set of distinct values within the group | | [make\_set\_if()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/makesetif-aggfunction) | Returns a set of distinct values within the group (with predicate) | | [max()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/max-aggfunction) | Returns the maximum value across the group | | [maxif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/maxif-aggfunction) | Returns the maximum value across the group (with predicate) | | [min()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/min-aggfunction) | Returns the minimum value across the group | | [minif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/minif-aggfunction) | Returns the minimum value across the group (with predicate) | | [percentiles()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/percentiles-aggfunction) | Returns the percentile approximate of the group | | [percentiles\_array()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/percentiles-aggfunction) | Returns the percentiles approximates of the group | | [percentilesw()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/percentiles-aggfunction) | Returns the weighted percentile approximate of the group | | [percentilesw\_array()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/percentiles-aggfunction) | Returns the weighted percentiles approximates of the group | | [stdev()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/stdev-aggfunction) | Returns the standard deviation across the group | | [stdevif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/stdevif-aggfunction) | Returns the standard deviation across the group (with predicate) | | [sum()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/sum-aggfunction) | Returns the sum of the elements within the group | | [sumif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/sumif-aggfunction) | Returns the sum of the elements within the group (with predicate) | | [take\_any()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/take-any-aggfunction) | Returns a random non-empty value for the group | | [take\_anyif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/take-anyif-aggfunction) | Returns a random non-empty value for the group (with predicate) | | [variance()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/variance-aggfunction) | Returns the variance across the group | | [varianceif()](https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/varianceif-aggfunction) | Returns the variance across the group (with predicate) |