Display Time of Measure in query

Question

In the chart window i want to display the Reponsetime as 1100ms , 1200ms  or i want to display at least the unit of Measure (milliseconds) on the chart is there a way to define that in the query ?

Answer 1

The render operator is what you are looking for, and it will allow you to use ytitle to name your y axis something more meaningful.  In my example below, I've renamed my y axis to "Time in MS":

// average request duration by name
let start=datetime("2020-05-28T17:35:00.000Z");
let end=datetime("2020-05-28T18:35:00.000Z");
let timeGrain=1m;
let dataset=requests
// additional filters can be applied here
| where timestamp > start and timestamp < end
| where client_Type != "Browser" ;
// calculate average request duration for all requestsdataset
| summarize avg(duration) by bin(timestamp, timeGrain)
| extend request='Overall'
// render result in a chart
| render timechart with (ytitle="Time in MS")

 

Useful Links:

Render Operator: https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/renderoperator?pivots=azuredataexplorer

Answer 2

Thank you this is what i am expecting.