In my previous posts I tried to transcribe the things that were not too obvious for me when I initially started working on Kusto Query Language. Continuing with the same thought, this time I’m going to share a few of the approaches that can be taken to aggregate the data.
Let’s consider the below input data:
Get the average number of bugs falling under each category.
There are several approaches to achieve this.
Partition operator first partitions the input data with defined criteria and then combines all the results.
Join merges the two tables based on the specified key.
Lookup operator extends the column of the second table and looks up the values in the first one.
I hope you enjoyed aggregating data.