Splunk Search

help to display field header in ordinate axis

jip31
Motivator

hi

The stats command below allows me to display data in a table panel

I would like to display the fields header in an ordinate axis instead an abcissa axis

could you help me please??

 

| stats last(Site) as "Geolocation site", last(Building) as "Geolocation building", last(DESCRIPTION_MODEL) as Model, last(OS) as OS by USERNAME

 

 

Tags (1)
0 Karma
1 Solution

to4kawa
Ultra Champion

 

| makeresults
| eval _raw="A B C D
1 2 3 4"
| multikv
| table A B C D

| eval header="count"
| transpose 0 column_name=cols header_field=header

 

try transpose

View solution in original post

0 Karma

niketn
Legend

@jip31 can you add some sample data for current output and expected output?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

jip31
Motivator

Sort I cant share datas

But instead having the field header at the bottom

A B C D

1 2 3 4

I need the field header on the left

A 1

B 2

C 3

D 4

0 Karma

to4kawa
Ultra Champion

 

| makeresults
| eval _raw="A B C D
1 2 3 4"
| multikv
| table A B C D

| eval header="count"
| transpose 0 column_name=cols header_field=header

 

try transpose

0 Karma
Get Updates on the Splunk Community!

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

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

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...