Forum Discussion
Anilkumar23
Apr 15, 2021Copper Contributor
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