Forum Discussion
Solved
Adding a threshold marker in Azure Log Anayltics
I am trying to add a line into a time chart. The time chart looks at a metric across all stream analytics jobs in the azure metrics table. Each job is represented by a line. I would like to add an ar...
This is already documented with lesson:
https://docs.microsoft.com/en-us/azure/log-analytics/query-language/charts#reference-line
AzureMetrics
| where ResourceProvider == "MICROSOFT.STREAMANALYTICS"
and MetricName contains "WatermarkDelay"
| summarize WatermarkDelay = max(Maximum), Threshold = 900 by Resource, bin(TimeGenerated, 15m)
This will produce two time series. One called WaterMarkDay and the other Threshold with a constant value of 900 for every time.