How to add values of 1st row to 2nd row and so on and show the sum in a different column

New Member

I have count of VMs per month and I want to show the count increment in a new column, for ex

_time Monthly count
2014-06 49
2014-07 300
2014-08 5
2014-09 97

I want to show the incremental sum in a new column as this -
_time Monthly count Incremental Sum
2014-06 49 49
2014-07 300 349
2014-08 5 354
2014-09 97 471

Tags (1)
0 Karma

Super Champion

please check "accum" command -
For each event where field is a number, the accum command calculates a running total or sum of the numbers. The accumulated sum can be returned to either the same field, or a newfield that you specify.

your search here | accum count as IncrementalSum
0 Karma

Revered Legend

Try this

your current search | eval Commulative_sum='Monthly count' | accum Commulative_sum


your current search | streamstats sum("Monthly count") as "Commulative Sum"
0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!