Splunk Search

How can I reorder this table so the column B data represents the month prior?

ASISH_9
Engager

I have the following table:

Month                 Value
September             12
October               78
November              88
December              132

I want to display the value of October in September, November in October and so on. The final output should look like this:

Month                 Value
September             78
October               88
November              132
December              Value of January

How can this be achieved? Please help. Thanks in advance.

0 Karma

cmerriman
Super Champion

try adding this to the end (assuming Value keeps growing):

...|sort 0 Value|streamstats window=1 current=f values(Month) as prevMonth|rename prevMonth as Month|where isnotnull(Month)

if Value doesn't keep growing and it is already sorted how you need it, just remove the sort command.

DalJeanis
Legend

Rather than values(), I'd generally use last() -- or even better, latest(), if there is a _time field --but they are functionally equivalent in this case.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...