Splunk Search

How do I use the reverse command to change the order of my table?

ckunath
Communicator

Hello,

I currently have a table that is ordered by time, ascending. It looks like this:

Date | Action
9pm  | Order finished
8pm  | Processing order step 3
8pm  | Processing order step 2
8pm  | Processing order step 1
7pm  | Start processing order

When I try to sort by time descending, I however get this:

Date | Action
7pm  | Start processing order
8pm  | Processing order step 3
8pm  | Processing order step 2
8pm  | Processing order step 1
9pm  | Order finished

As you can see, the events at 8pm did not change their order, therefore making it harder to read the table.
How can I correctly "turn the table around"? Any help is appreciated.

0 Karma
1 Solution

cmerriman
Super Champion

use |reverse to flip it the other way

View solution in original post

cmerriman
Super Champion

use |reverse to flip it the other way

ckunath
Communicator

Oh boy, i feel stupid for not finding it myself. Thank you!

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...