Display Time of Measure in query RRS feed

  • 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 ?

    Tuesday, May 26, 2020 7:47 PM

All replies

  • 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

    Thursday, May 28, 2020 6:59 PM
  • Thank you this is what i am expecting.
    Sunday, May 31, 2020 5:18 PM