Forum Discussion

Anilkumar23's avatar
Anilkumar23
Copper Contributor
Apr 15, 2021

Appinsights analytics Query to calculate Avg Rps for given duration

Hi Team,

Below Appinsights analytics query displays the RPS w.r.t time stamp for a given duration.

let start=datetime("2021-04-13T18:35:00.000Z");
let end=datetime("2021-04-13T18:52:00.000Z");
requests
| where timestamp > start and timestamp < end
| summarize RequestPerSecond = sum(itemCount) by bin(timestamp, 1s)

Output
"timestamp [UTC]",RequestPerSecond
"4/13/2021, 6:36:39.000 PM",2429
"4/13/2021, 6:36:40.000 PM",2292
"4/13/2021, 6:36:41.000 PM",2055


I need a AI analytics query that will calculate Average of RPS from above result and display output in below format
Metrics, AverageRequestPerSecond
RequestPerSecond,2258

Appreciate if any one can help on this

No RepliesBe the first to reply