Aggregating daily requests application insights

Copper Contributor

Hi! 

 

I am new to Appication Insights and want to make a table (or graph) for the number of requests per day. I have managed to make averages and binning the data over different spans, but how do I do aggregated values? Aka a running total per time specified. 

 

The example below shows me the total number per day, but I would like to have a running total per, let's say 5 minutes, so that I can make a graph. 

 

requests
| where name = example 
| summarize count(itemCount), avg(itemCount) by bin(timestamp, 24h)
 
Thanks, 
 
 
 
0 Replies