Splunk Search

How to pivot convert in Splunk?

zoe
Path Finder

Hi, 

I habe a table after using stats:

| stats values(durationSum) as duration by Fauf Station. How can I convert it to a table with only one line in such a format:

Fauf duration_Station1 duration_Station2, duration_Station7, duration_Station10

zoe_0-1658220188640.png

Thanks for helping in advance!

 

 

Labels (3)
0 Karma
1 Solution

zoe
Path Finder
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| xyseries Fauf Station duration
0 Karma

zoe
Path Finder

Thank! it helps!

0 Karma
Get Updates on the Splunk Community!

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...