Splunk Search

Sort column headers in timechart - customize

martin86
Engager

Hi,

I would like to ask you, of there is some possibility order column based on requirement.

Case:

 

<search>
|eval lower_raw = lower(_raw) 
|rex field=lower_raw "^.*d=(?<opentask>[0-9]+).*" 
|rex field=lower_raw "^.*pm\s(?<trace>[0-9a-z-]+).*" 
|rex field=lower_raw "^.*taskid=(?<opentask>[0-9]+).*" 
|rex field=lower_raw "^.*uuid=(?<trace>[0-9a-z-]+).*" 
| eval task=opentask ."_".trace 
| transaction task
| eval timedelay=case(duration>=0 AND duration<2,"1 sec",duration>=2 AND duration<6,"2-5 sec",duration>=6 AND duration<11,"6-10 sec",duration>=11,"11 and more sec",1=1,"error") 
| timechart span=10m count avg(duration) as avg  by timedelay 
| sort by _time timedelay desc

 

 

I would like to have sorted by group (count event) and AVG duration

I mean, first column time (ok now)

second will be "count: 1sec"

third: "avg: 1sec"

forth: "count: 2-5sec"

fifth: "avg: 2-5sec"

 

etc.

Current it looks like this

martin86_0-1625218824624.png

which is not nice

expectation:

martin86_1-1625219055254.png

 

Thank you

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

kamlesh_vaghela
SplunkTrust
SplunkTrust

@martin86 

I suggest to use table command to rearrange the columns.

Like

| timechart span=10m count avg(duration) as avg  by timedelay 
| sort by _time timedelay desc
|table LIST OF COLUMNS YOU NEED

 

KV 

View solution in original post

0 Karma

martin86
Engager

@kamlesh_vaghela

Thank you, it works

martin86_0-1625223659578.png

 

 

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@martin86 

I suggest to use table command to rearrange the columns.

Like

| timechart span=10m count avg(duration) as avg  by timedelay 
| sort by _time timedelay desc
|table LIST OF COLUMNS YOU NEED

 

KV 

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...

How to Break a Kubernetes Pod on Purpose and Let the AI Troubleshooting Agent Find ...

Let's say I've just rolled out a Kubernetes Deployment with a typo in the image tag. Nothing explodes. The pod ...

Splunk Add-on for Microsoft Windows 11.0.3: Parse Once, Search Faster

The updated Splunk Add-on for Microsoft Windows helps customers search Windows events faster by reducing ...