Splunk Search

How can I make transpose work for all more than 5 days of data?

ashidhingra
Path Finder

My actual query as all this data.

ashidhingra_0-1658338219120.png

 


but after i use transpose 

| sort by _time desc
| eval mytime=strftime(_time, "%B %d %Y")
| fields - _* | transpose header_field=mytime

I only see the result for first 5 columns 

ashidhingra_1-1658338252531.png

 



How can i make transpose work for all more than 5days of data

Also is there a way to generically format the color. Because the date changes. 

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Try this

| transpose 0 header_field=mytime

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try this

| transpose 0 header_field=mytime
0 Karma

ashidhingra
Path Finder

Thanks @ITWhisperer  you are the best!!

is there a way to generically format the color as the date changes everyday/

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 ...