# KQL Quick Guide

- [Useful Resources 🔦](https://sandyzeng.gitbook.io/kql/kql-quick-guide/useful-resources.md)
- [My favorites 😍](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites.md)
- [search](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/search.md)
- [take](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/take.md)
- [where](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/where.md)
- [summarize](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/summarize.md)
- [arg\_max()](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/summarize/arg_max.md)
- [count, countif](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/summarize/count-countif.md)
- [dcount, dcountif](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/summarize/dcount-dcountif.md)
- [take\_any](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/summarize/take_any.md)
- [distinct](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/distinct.md)
- [case](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/case.md)
- [project](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/project.md)
- [project-reorder](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/project/project-reorder.md)
- [project-away](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/project/project-away.md)
- [project-rename](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/project/project-rename.md)
- [project-keep](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/project/project-keep.md)
- [sort by](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/sort-by.md)
- [extend](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/extend.md)
- [extract](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/extract.md)
- [extract\_all](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/extract/extract_all.md)
- [parse](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/parse.md)
- [stract](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/stract.md)
- [count](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/count.md)
- [countif](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/count/countif.md)
- [mv-expand](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/mv-expand.md)
- [dcount](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/dcount.md)
- [dcountif](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/dcount/dcountif.md)
- [Create table](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/create-table.md)
- [let](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/let.md)
- [join](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/join.md)
- [union](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/union.md)
- [materialize](https://sandyzeng.gitbook.io/kql/kql-quick-guide/my-favorites/materialize.md)
- [Need to practice more 🎯](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more.md)
- [toscalar](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/toscalar.md)
- [range](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/range.md)
- [make-series](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/make-series.md)
- [series\_outliers](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/series_outliers.md)
- [set\_differenc](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/set_differenc.md)
- [pack](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/pack.md)
- [summarize](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/summarize.md)
- [make\_bag](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/summarize/make_bag.md)
- [make\_set, make\_list](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/summarize/make_set-make_list.md)
- [evaluate](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/evaluate.md)
- [pivot](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/evaluate/pivot.md)
- [bag\_unpack](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/evaluate/bag_unpack.md)
- [pack\_all](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/evaluate/pack_all.md)
- [mv-expand](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/mv-expand.md)
- [set\_difference](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/set_difference.md)
- [render](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-practice-more/render.md)
- [Need to learn later 🐢](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later.md)
- [scan](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/scan.md)
- [ExtractParseParse-kv-Tabular](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/extractparseparse-kv-tabular.md)
- [decode](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/decode.md)
- [mv-apply](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/mv-apply.md)
- [prev and next](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/prev-and-next.md)
- [row\_cumsum](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/row_cumsum.md)
- [any](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/any.md)
- [top-nested](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/top-nested.md)
- [Time Series](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/time-series.md)
- [series\_stats](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/time-series/series_stats.md)
- [series\_fir](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/time-series/series_fir.md)
- [series\_iir](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/time-series/series_iir.md)
- [series\_fit\_line](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/time-series/series_fit_line.md)
- [series\_fit\_2lines](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/time-series/series_fit_2lines.md)
- [Machine Learning](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/machine-learning.md)
- [basket](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/machine-learning/basket.md)
- [autocluster](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/machine-learning/autocluster.md)
- [diffpatterns](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/machine-learning/diffpatterns.md)
- [reduce](https://sandyzeng.gitbook.io/kql/kql-quick-guide/need-to-learn-later/machine-learning/reduce.md)


---

# 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.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.