Jul 27 2020
03:30 PM
- last edited on
Apr 08 2022
10:34 AM
by
TechCommunityAP
Jul 27 2020
03:30 PM
- last edited on
Apr 08 2022
10:34 AM
by
TechCommunityAP
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
@CliveWatson 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