Splunk Search

How to turn CSV into a graph?

Lither1423
Observer

Hey hey, I'm trying to turn telemetry to a graph.

I have a CSV containing:

PID,runtime,invoked,usecs,5sec,1min,5min,tty,process.

There are a bunch of process with each of those fields, I want to turn the CSV into 3 column graphs, one with the process name and then% CPU used in (5sec, 1min or 5min, one graph each)

And I'm confused as to how to accomplish that

 

 

 

 

 

Labels (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

I thought you wanted a single graph with three values.  Thanks for clarifying.  To get three separate graphs, you can try trellis mode.  If that doesn't do what you expect then you'll need three separate searches in different panels.

---
If this reply helps you, an upvote would be appreciated.
0 Karma

richgalloway
SplunkTrust
SplunkTrust

It's not clear what output you want, but perhaps this will get you started.

... | chart max(5sec) as 5sec, max(1min) as 1min, max(5min) as 5min by PID
---
If this reply helps you, an upvote would be appreciated.
0 Karma

Lither1423
Observer

It didn't really show me anything, what I'm looking for is adding a panel to my dashboard with 3 column charts, 1 chart will have a %amount specified on the 5th place every row in the y axis and the process name which is the first place every row on the X axis,  second chart will be the same but the y axis will take the number from the 6th place every row and third chart will take from the 7th.

So the result would be 3 column charts with the process names on the X axis and % on the y axis, one graph showing the usage in 5 seconds, one shows usage in 1 minute and the third for 5 minutes.

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...