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
Top comments (0)