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
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
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies