https://community.splunk.com/t5/Splunk-Search/Getting-count-and-averages-in-same-search/m-p/42245#M9853 <P>if avgtime represents the average of some field like say response_time, and if Page1.html and Page2.html are a field called filename, then you're looking at a simple <CODE>stats</CODE> clause of </P> <P><CODE>| stats count avg(response_time) by filename</CODE></P> Thu, 03 May 2012 03:27:38 GMT sideview 2012-05-03T03:27:38Z https://community.splunk.com/t5/Splunk-Search/Getting-count-and-averages-in-same-search/m-p/42244#M9852 <P>Hi, </P> <P>I think this must be easy.. but I can't wrap my head around how to get this done... I want to gather multiple stats for a single query. Essentially, I want to gather the count and avg thruput for webpages from my iis logs...Essentially, something like this..</P> <P>Page1.html count=10, avgtime=20</P> <P>Page2.html count=17, avgtime=30</P> <P>Any suggestions?</P> Thu, 03 May 2012 01:38:54 GMT https://community.splunk.com/t5/Splunk-Search/Getting-count-and-averages-in-same-search/m-p/42244#M9852 richnavis 2012-05-03T01:38:54Z https://community.splunk.com/t5/Splunk-Search/Getting-count-and-averages-in-same-search/m-p/42245#M9853 <P>if avgtime represents the average of some field like say response_time, and if Page1.html and Page2.html are a field called filename, then you're looking at a simple <CODE>stats</CODE> clause of </P> <P><CODE>| stats count avg(response_time) by filename</CODE></P> Thu, 03 May 2012 03:27:38 GMT https://community.splunk.com/t5/Splunk-Search/Getting-count-and-averages-in-same-search/m-p/42245#M9853 sideview 2012-05-03T03:27:38Z https://community.splunk.com/t5/Splunk-Search/Getting-count-and-averages-in-same-search/m-p/42246#M9854 <P>:)... Cannot believe that I couldn't see that.. Thanks nick!</P> Thu, 03 May 2012 13:29:13 GMT https://community.splunk.com/t5/Splunk-Search/Getting-count-and-averages-in-same-search/m-p/42246#M9854 richnavis 2012-05-03T13:29:13Z