Warning threashold in Charts

Question

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?

Answer 1

@TTLAzure Thanks for your question !! I have reproduced your issue by adding reference line to identify if the metric exceeded a specific threshold and I am able to view the threshold line. Snapshot for your reference. Kindly check again from your end and revert if you have further questions.

Answer 2

@SwathiDhanwada-MSFT

My question is about "Duration in MS" in Ytitle column, If you see 0k, 0.1k,.....0.8k,0.9k,1k , what is this about ? if we didnt specify that these are in Milliseconds no one knows its time in MS.

We know Response time will be in MilliSeconds , But i wanted to display the title there saying its Duration in MS. So it will be easy for everyone to understand who see my chart.

Please check and suggest