Jul 27 2020 03:30 PM - last edited on Jul 29 2020 12:18 PM by Noa Kuperberg
I am trying to place a threshold line on the x-axis using this query
Perf
| where TimeGenerated > ago(1d)
| where CounterName == "% Processor Time"
| summarize avg(CounterValue), percentiles(CounterValue, 50, 95) by bin(TimeGenerated, 1h)
| extend Threshold = 20
However, it is not giving me the option to have 1 threshold line on the x axis. It's called a "reference line", according to this tutorial: https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/charts
I've attached an image.
Jul 27 2020 08:21 PM
Jul 28 2020 12:17 AM
This shows up best with a linechart
Perf
| where TimeGenerated > ago(1d)
| where CounterName == "% Processor Time"
| summarize avg(CounterValue), percentiles(CounterValue, 50, 95) by bin(TimeGenerated, 1h)
| extend Threshold = 20
| render timechart
Jul 28 2020 10:07 AM
@Clive Watson I see it does, but I do not understand how alerts graph is able to do it with a bar graph https://docs.microsoft.com/en-us/azure/azure-monitor/platform/alerts-log