https://community.splunk.com/t5/Splunk-Search/How-to-add-a-row-with-statistics-for-the-last-week/m-p/650256#M224796 <P>Hey guys!</P><P>&nbsp;</P><P>I need the statistics of a bunch of data by month. And this is done already.</P><P>&nbsp;</P><P>search<BR />|eval Month=strftime(_time,"%Y %m") | stats count(mydata) AS nobs, mean(mydata) as mean, min(mydata) as min by Month | reverse</P><P>&nbsp;</P><P>The output is what I want:</P><TABLE border="0" width="348" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="87" height="21">Month</TD><TD width="87">nobs</TD><TD width="87">mean</TD><TD width="87">min</TD></TR><TR><TD height="21">2023 06</TD><TD>1900</TD><TD>-5.0239778</TD><TD>-68.73417</TD></TR><TR><TD height="21">2023 05</TD><TD>3562</TD><TD>-4.2430259</TD><TD>-67.134697</TD></TR><TR><TD height="21">2023 04</TD><TD>3181</TD><TD>-4.1811658</TD><TD>-64.995394</TD></TR><TR><TD height="21">2023 03</TD><TD>4274</TD><TD>-4.3373071</TD><TD>-134.20177</TD></TR><TR><TD height="21">2023 02</TD><TD>3939</TD><TD>-4.7725011</TD><TD>-73.538274</TD></TR><TR><TD height="21">2023 01</TD><TD>2868</TD><TD>-5.5231115</TD><TD>-41.056093</TD></TR><TR><TD height="21">2022 12</TD><TD>395</TD><TD>-4.617424</TD><TD>-35.51642</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now I need add another row on the very top with statistics for the most recent WEEK. Ideally, I can use the search result without the need to search again and degrade performance. Thanks!</P> Wed, 12 Jul 2023 17:36:16 GMT qqzj 2023-07-12T17:36:16Z https://community.splunk.com/t5/Splunk-Search/How-to-add-a-row-with-statistics-for-the-last-week/m-p/650256#M224796 <P>Hey guys!</P><P>&nbsp;</P><P>I need the statistics of a bunch of data by month. And this is done already.</P><P>&nbsp;</P><P>search<BR />|eval Month=strftime(_time,"%Y %m") | stats count(mydata) AS nobs, mean(mydata) as mean, min(mydata) as min by Month | reverse</P><P>&nbsp;</P><P>The output is what I want:</P><TABLE border="0" width="348" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="87" height="21">Month</TD><TD width="87">nobs</TD><TD width="87">mean</TD><TD width="87">min</TD></TR><TR><TD height="21">2023 06</TD><TD>1900</TD><TD>-5.0239778</TD><TD>-68.73417</TD></TR><TR><TD height="21">2023 05</TD><TD>3562</TD><TD>-4.2430259</TD><TD>-67.134697</TD></TR><TR><TD height="21">2023 04</TD><TD>3181</TD><TD>-4.1811658</TD><TD>-64.995394</TD></TR><TR><TD height="21">2023 03</TD><TD>4274</TD><TD>-4.3373071</TD><TD>-134.20177</TD></TR><TR><TD height="21">2023 02</TD><TD>3939</TD><TD>-4.7725011</TD><TD>-73.538274</TD></TR><TR><TD height="21">2023 01</TD><TD>2868</TD><TD>-5.5231115</TD><TD>-41.056093</TD></TR><TR><TD height="21">2022 12</TD><TD>395</TD><TD>-4.617424</TD><TD>-35.51642</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now I need add another row on the very top with statistics for the most recent WEEK. Ideally, I can use the search result without the need to search again and degrade performance. Thanks!</P> Wed, 12 Jul 2023 17:36:16 GMT https://community.splunk.com/t5/Splunk-Search/How-to-add-a-row-with-statistics-for-the-last-week/m-p/650256#M224796 qqzj 2023-07-12T17:36:16Z https://community.splunk.com/t5/Splunk-Search/How-to-add-a-row-with-statistics-for-the-last-week/m-p/650262#M224799 <P>Maybe last week is the wrong way to specify it. I should have written "the previous 7 days". Thanks!</P> Wed, 12 Jul 2023 18:12:54 GMT https://community.splunk.com/t5/Splunk-Search/How-to-add-a-row-with-statistics-for-the-last-week/m-p/650262#M224799 qqzj 2023-07-12T18:12:54Z