Kusto - Get Average and Count in the same row

Varun Sharma 0
Viewed 18

Using Kusto, I want to write a query to see the average duration of events and total count of those events as well. I am able to do it in two queries like this but is it possible to do this in 1 query?

dependencies
| where type == 'SQL' and operation_Name == 'something'
| summarize avg(duration) by data
| order by data asc

dependencies
| where type == 'SQL' and operation_Name == 'something'
| summarize count() by data
| order by data asc

This is giving me what I want in two separate results. For example I get this:

A 1.2
B 1.4
C 4.5

and

A 5
B 90
C 78

but what I want is this

A 1.2 5
B 1.4 90
C 4.5 78
kql azure-application-insights
1 Answers

See summarize operator for syntax

T | summarize [SummarizeParameters] [[Column =] Aggregation [, ...]] [by [Column =] GroupExpression [, ...]]

dependencies
| where type == 'SQL' and operation_Name == 'something'
| summarize avg(duration), count() by data
| order by data asc
David דודו Markovitz0
Related