topic Re: Calculate Difference Between Same Field in Different Rows in Reporting

topic Re: Calculate Difference Between Same Field in Different Rows in Reporting https://community.splunk.com/t5/Reporting/Calculate-Difference-Between-Same-Field-in-Different-Rows/m-p/680450#M12392 <P>Assuming these are numeric (not strings), you can use streamstats</P><LI-CODE lang="markup">| streamstats window=2 range(USAGE) as difference</LI-CODE> Tue, 12 Mar 2024 23:05:16 GMT ITWhisperer 2024-03-12T23:05:16Z Calculate Difference Between Same Field in Different Rows https://community.splunk.com/t5/Reporting/Calculate-Difference-Between-Same-Field-in-Different-Rows/m-p/680426#M12391 <P>If I have the following table using columns DATE and USAGE, is there a way to create a 3rd column to display the difference in the USAGE column from Day X to previous day?</P><P> </P><P>DATE USAGE</P><TABLE><TBODY><TR><TD><DIV class="">Feb-28</DIV><DIV class="">Feb-29</DIV><DIV class="">Mar-01</DIV><DIV class="">Mar-02</DIV><DIV class="">Mar-03</DIV><DIV class="">Mar-04</DIV><DIV class="">Mar-05</DIV><DIV class="">Mar-06</DIV><DIV class="">Mar-07</DIV><DIV class="">Mar-08</DIV><DIV class="">Mar-09</DIV><DIV class="">Mar-10</DIV><DIV class="">Mar-11</DIV><DIV class="">Mar-12</DIV></TD><TD><DIV class="">17.68 gb</DIV><DIV class="">18.53 gb</DIV><DIV class="">19.66 gb</DIV><DIV class="">21.09 gb</DIV><DIV class="">22.04 gb</DIV><DIV class="">23.21 gb</DIV><DIV class="">24.20 gb</DIV><DIV class="">24.94 gb</DIV><DIV class="">25.64 gb</DIV><DIV class="">26.80 gb</DIV><DIV class="">27.79 gb</DIV><DIV class="">29.07 gb</DIV><DIV class="">30.09 gb</DIV><DIV class="">31.01 gb</DIV></TD></TR></TBODY></TABLE> Tue, 12 Mar 2024 18:05:44 GMT https://community.splunk.com/t5/Reporting/Calculate-Difference-Between-Same-Field-in-Different-Rows/m-p/680426#M12391 he204035 2024-03-12T18:05:44Z Re: Calculate Difference Between Same Field in Different Rows https://community.splunk.com/t5/Reporting/Calculate-Difference-Between-Same-Field-in-Different-Rows/m-p/680450#M12392 <P>Assuming these are numeric (not strings), you can use streamstats</P><LI-CODE lang="markup">| streamstats window=2 range(USAGE) as difference</LI-CODE> Tue, 12 Mar 2024 23:05:16 GMT https://community.splunk.com/t5/Reporting/Calculate-Difference-Between-Same-Field-in-Different-Rows/m-p/680450#M12392 ITWhisperer 2024-03-12T23:05:16Z