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, Karma 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, Karma 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!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...