Splunk Search

How to custom sort by column headers

DEADBEEF
Path Finder

I have a table that shows the number of logs by severity over each host.  I want to be able to rearrange the severity columns into a specific order but can't figure out how.  I tried using custom sort field via eval but didn't seem to work.

Current SPL

 

index=foo sourcetype=logs
| chart count over server by severity

 


Current Table Order

 

server   major   info   critical    minor
serverA   5       10       8          6
serverB   22       5       13         9

 

 

Desired Table Order

 

server   critical  major   minor  info
serverA   8         5       6      10
serverB   13        22      9       5

 

Labels (2)
Tags (3)
0 Karma
1 Solution

thambisetty
Super Champion

use table command to re arrange table header:

 

| table server critical major minor info

————————————
If this helps, give a like below.

View solution in original post

thambisetty
Super Champion

use table command to re arrange table header:

 

| table server critical major minor info

————————————
If this helps, give a like below.
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) v3.54.0

The Splunk Threat Research Team (STRT) recently released Enterprise Security Content Update (ESCU) v3.54.0 and ...

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

New Learning Videos on Topics Most Requested by You! Plus This Month’s New Splunk ...

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