https://community.splunk.com/t5/Splunk-Search/need-help-with-a-query-to-get-count-and-avg-count-per-day/m-p/252330#M189336 <P>Like this:</P> <PRE><CODE>index=main host=src* source=ihs* | bucket _time span=1d | stats count by _time | addtotals col=t row=f | fillnull value=TOTAL | streamstats current=f count AS serial | eval daily_average = if(_time = "TOTAL", count/serial, "vvvvvvvvvv") | fields - serial </CODE></PRE> Sat, 28 Nov 2015 21:10:01 GMT woodcock 2015-11-28T21:10:01Z https://community.splunk.com/t5/Splunk-Search/need-help-with-a-query-to-get-count-and-avg-count-per-day/m-p/252329#M189335 <P>I have given this query and it's just giving me avg(count) in the output, i'm looking for both count and avg(count) per day in the output.. any help would be appreciated. Thanks.</P> <P>index=main host=src* source=ihs* | stats count by date_mday | stats avg(count)</P> Fri, 27 Nov 2015 16:52:55 GMT https://community.splunk.com/t5/Splunk-Search/need-help-with-a-query-to-get-count-and-avg-count-per-day/m-p/252329#M189335 prakash007 2015-11-27T16:52:55Z https://community.splunk.com/t5/Splunk-Search/need-help-with-a-query-to-get-count-and-avg-count-per-day/m-p/252330#M189336 <P>Like this:</P> <PRE><CODE>index=main host=src* source=ihs* | bucket _time span=1d | stats count by _time | addtotals col=t row=f | fillnull value=TOTAL | streamstats current=f count AS serial | eval daily_average = if(_time = "TOTAL", count/serial, "vvvvvvvvvv") | fields - serial </CODE></PRE> Sat, 28 Nov 2015 21:10:01 GMT https://community.splunk.com/t5/Splunk-Search/need-help-with-a-query-to-get-count-and-avg-count-per-day/m-p/252330#M189336 woodcock 2015-11-28T21:10:01Z