topic Re: How to turn CSV into a graph in Splunk Search

How to turn CSV into a graph?

Lither1423 — Wed, 23 Mar 2022 05:06:36 GMT

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

Re: CSV to graph

richgalloway — Sun, 20 Mar 2022 21:23:48 GMT

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

Re: CSV to graph

Lither1423 — Tue, 22 Mar 2022 07:57:58 GMT

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.

Re: How to turn CSV into a graph

richgalloway — Tue, 22 Mar 2022 12:40:19 GMT

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.