# 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) <a href="#list-of-aggregation-functions" id="list-of-aggregation-functions"></a>

| 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)                       |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/summarize.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.