kusto trendlines

#kusto #appinsights

I recently stumbled upon an example for how to include "trendlines" in kusto queries that might be handy.

exceptions
| where timestamp > ago(90d)
| summarize c = log(count()) by bin(timestamp, 1d)
| as hint.materialized=true T
| extend _perc_25 = toscalar(T | summarize percentile(c, 25)),
         _perc_50 = toscalar(T | summarize percentile(c, 50)),
         _perc_75 = toscalar(T | summarize percentile(c, 75))
| render timechart