topic Re: Create graphs from a CSV file with time and values in Dashboards & Visualizations

Create graphs from a CSV file with time and values

athreyavc — Fri, 28 Mar 2014 15:42:27 GMT

Hi,

I am vey new to splunk, still exploring the options.

I have a file it is a CSV

03/27/2014 18:01:32, 2.036544
03/27/2014 18:11:32, 1.846386
03/27/2014 18:21:32, 1.911929
03/27/2014 18:31:32, 1.655284
03/27/2014 18:41:32, 9.481447
03/27/2014 18:51:32, 9.385653
03/27/2014 19:01:32, 9.599620
03/27/2014 19:11:37, 2.907257
03/27/2014 19:21:41, 2.192929
03/27/2014 19:31:41, 1.993718

Is it possible to create a graph using the CSV in Splunk?

Best Regards,
A

Re: Create graphs from a CSV file with time and values

somesoni2 — Fri, 28 Mar 2014 15:51:52 GMT

You can add your csv file as lookup input file OR import to Splunk (with necessary field extraction configuration). Once data is in splunk, your can create charts as per your requirement.
if lookup
|inputlookup yourCsvFileName.csv | stats max(Value) by Timestamp
if imported to index
index=yourIndex source=*yourCsvFileName.csv | stats max(Value) by Timestamp

Re: Create graphs from a CSV file with time and values

athreyavc — Fri, 28 Mar 2014 16:19:43 GMT

Hi Thanks for the comment.

Should I run it from the command line?

Re: Create graphs from a CSV file with time and values

somesoni2 — Fri, 28 Mar 2014 17:45:43 GMT

All these activities you can do from Splunk Web UI.
Create lookup
http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/Usefieldlookupstoaddinformationtoyourevents
Index data
http://docs.splunk.com/Documentation/Splunk/latest/Data/UseSplunkWeb
Search manual
http://docs.splunk.com/Documentation/Splunk/latest/Search/Whatsinthismanual

Re: Create graphs from a CSV file with time and values

athreyavc — Mon, 14 Apr 2014 14:53:48 GMT

Hi,

Sorry there was a delay from myside on the update. I got the Graph created.

04/14/2014 08:05,1048576
04/14/2014 08:10,1048576
04/14/2014 08:15,908112
04/14/2014 08:20,873912
04/14/2014 08:25,1048576
04/14/2014 08:30,1048576

| inputlookup master.csv | fields Time,bandwidth | eval bw=bandwidth/100 | table Time bw,

however the X-Axis is not showing the times.

I am not sure how to use the timechart for this.

Please help.

Best Regards,

Re: Create graphs from a CSV file with time and values

somesoni2 — Mon, 14 Apr 2014 15:10:46 GMT

Try this:

| inputlookup master.csv | fields Time,bandwidth | convert ctime | eval bw=bandwidth/100| convert timeformat="%m/%d/%Y %H:%M" mktime(Time) as _time | table _time bw

Re: Create graphs from a CSV file with time and values

athreyavc — Mon, 14 Apr 2014 16:18:46 GMT

thanks for the reply,

Sorry, it doesn't show the time in the X-axis, Graph is getting created and it is fine too, just want the X axis to show dates.

Thanks again

best Regards,

Re: Create graphs from a CSV file with time and values

somesoni2 — Mon, 14 Apr 2014 16:33:26 GMT

Where are you using this query to create chart, a dashboard or from Search screen?

Re: Create graphs from a CSV file with time and values

linu1988 — Mon, 14 Apr 2014 16:47:49 GMT

| inputlookup master.csv|eval _time=strptime(Time,"%m/%d/%Y %H:%M")|timechart avg(Value) span=5m

Re: Create graphs from a CSV file with time and values

athreyavc — Mon, 14 Apr 2014 17:01:20 GMT

|inputlookup master.csv|eval _time=strptime(Time,"%m/%d/%Y %H:%M")|timechart avg(Bandwidth) span=5m

Worked like a Charm, awesome!!

Re: Create graphs from a CSV file with time and values

athreyavc — Mon, 14 Apr 2014 17:08:04 GMT

One other issue I observed when I graph it it misses some values, it is becuase of Avg ?

Re: Create graphs from a CSV file with time and values

linu1988 — Mon, 14 Apr 2014 17:31:21 GMT

it may be missing some timestamp or it may not be able to read the formated csv file.
try the below as well
|timechart Values(Bandwidth) span=5m

Re: Create graphs from a CSV file with time and values

athreyavc — Mon, 28 Sep 2020 16:23:07 GMT

thank you for helping me so quickly with this.It was mainly because there was readings which are 0 for some timestamps, corrected that with this.

Graph looks all good.

Re: Create graphs from a CSV file with time and values

reswob4 — Thu, 11 May 2017 17:51:49 GMT

I've been looking for something that did what Values did. Thanks.