Home

Aggregating daily requests application insights

%3CLINGO-SUB%20id%3D%22lingo-sub-201745%22%20slang%3D%22en-US%22%3EAggregating%20daily%20requests%20application%20insights%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-201745%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20Appication%20Insights%20and%20want%20to%20make%20a%20table%20(or%20graph)%20for%20the%20number%20of%20requests%20per%20day.%20I%20have%20managed%20to%20make%20averages%20and%20binning%20the%20data%20over%20different%20spans%2C%20but%20how%20do%20I%20do%20aggregated%20values%3F%26nbsp%3BAka%20a%20running%20total%20per%20time%20specified.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20example%20below%20shows%20me%20the%20total%20number%20per%20day%2C%20but%20I%20would%20like%20to%20have%20a%20running%20total%20per%2C%20let's%20say%205%20minutes%2C%20so%20that%20I%20can%20make%20a%20graph.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3Erequests%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20name%20%3D%20example%3C%2FSPAN%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%20%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E(itemCount)%2C%20avg(itemCount)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20bin(timestamp%2C%20%3C%2FSPAN%3E%3CSPAN%3E24%3C%2FSPAN%3E%3CSPAN%3Eh)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EThanks%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-201745%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApplication%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Eva Wilhelmsson
Occasional Visitor

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, 
 
 
 
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies