https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/632975#M219883 <P>Thank you for this. How would you do that same thing, but for daily average for this month only?</P> Thu, 02 Mar 2023 11:39:28 GMT JoshSaunders 2023-03-02T11:39:28Z https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/439435#M173217 <P>how do Icalculate the average number of events for each week for this search</P> <LI-CODE lang="markup">index=dcl EventCode=4740 | eval date=strftime(_time,"%Y-%m-%d") | timechart span=7d count</LI-CODE> Thu, 02 Mar 2023 15:06:22 GMT https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/439435#M173217 vonsolo29 2023-03-02T15:06:22Z https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/439436#M173218 <P>If you want a simple average daily count over a week, try this untested query:</P> <PRE><CODE>index=dcl EventCode=4740 | timechart span=7d count as Avg | eval Avg=round(Avg/7, 2) </CODE></PRE> Thu, 31 Jan 2019 22:42:03 GMT https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/439436#M173218 richgalloway 2019-01-31T22:42:03Z https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/632975#M219883 <P>Thank you for this. How would you do that same thing, but for daily average for this month only?</P> Thu, 02 Mar 2023 11:39:28 GMT https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/632975#M219883 JoshSaunders 2023-03-02T11:39:28Z https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/632977#M219884 <P>And is there a way to restrict the average for the first query to only Monday through Friday of the current week, but also only include days that have past (for example, if it's Thursday, show the daily average for Monday through Thursday)?</P> Thu, 02 Mar 2023 11:52:18 GMT https://community.splunk.com/t5/Splunk-Search/Calculating-average-by-week/m-p/632977#M219884 JoshSaunders 2023-03-02T11:52:18Z