Querying Application Insights and Log Analytics with KQL: where, summarize, bin, join, percentiles and Alert Queries
When you query Application Insights with KQL you count with sum(itemCount), not count(): with 25 percent sampling, 300 checkouts shrink to 82 rows and none of the 7 failed ones remains. We collect Bookstore's telemetry in the Application Insights schema without an Azure account and try where, summarize, percentile, bin, make-series, join, lookup, parse/extract and alert queries on real data.
15 Nov 2026
·
20 min
·
16
