Azure App Insights - How to plot over time(say 1h) so we can see how the success percentage changes over time?

Question

requests
| summarize Failure=count(resultCode contains "500" or resultCode contains "503"), Success=count(resultCode contains "200")
| extend Percentage=((Success*1.0)/(Success+Failure))*100

The above code would display the success rate per any hour/day given in search query. Need a query that can display success rate over time. Is that possible ?

This is how it looks like

Hello, if the answer is helpful, could you please accept it as answer as per [this link](https://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work?answertab=active#tab-top)? Thanks. — Ivan Glasenberg, Jul 14 '20 at 05:30

score 3 · Answer 1 · answered Jul 08 '20 at 08:25

You should use the bin() function of kusto.

For example, say 1 hour, the sample code looks like below:

requests
| summarize Failure=count(resultCode contains "500" or resultCode contains "503"), Success=count(resultCode contains "200") by length=bin(timestamp,1h)
| extend Percentage=((Success*1.0)/(Success+Failure))*100

Here is the test result:

Azure App Insights - How to plot over time(say 1h) so we can see how the success percentage changes over time?

1 Answers1