Hello,
I am planning to add a warning threashold to Responsetime chart by using "SLA"
i am using below query, but when i add this chart to dashboard, i am unable to see the SLA line(warning line)
requests
| where operation_Name contains "xxxxxxx" and cloud_RoleName == "xxxxxxxxxxxxxxx"
| summarize avgRequestDuration=avg(duration), percentiles(duration, 95, 99) by bin(timestamp, 1m)
| extend SLA = 1000
| project SLA, avgRequestDuration, percentile_duration_95, percentile_duration_99, timestamp
| render timechart with (ytitle="Duration in MS")
Can someone please help?