Splunk Search

plot time against date in graph

New Member

Hi everyone,

Is it possible to plot time which is in HH:MM format agains date which is in MM/DD/YYYY format .
the hours should come on y-axis and date on x-axis.

here is my sample data:

JOB NAME,ENDTIME,FORM,     DATE
FCIND60 ,23:45,EXCHANGES  ,22:58,03/27/2014
FMEGD70 ,23:45,EXCHANGES  ,23:39,03/27/2014
FSLCD70 ,23:45,EXCHANGES  ,22:49,03/28/2014
FRSCD80 ,23:45,EXCHANGES  ,22:45,03/27/2014
FKEND70 ,23:45,EXCHANGES  ,23:00,03/29/2014
Tags (3)
0 Karma

SplunkTrust
SplunkTrust

Sure. Assuming your time field is TIME and your date field is DATE, you can do this:

base search | eval _time = strptime(DATE, "%m/%d/%Y") | eval seconds = TIME.":00" | convert dur2sec(seconds) | timechart span=1d avg(seconds)
0 Karma

SplunkTrust
SplunkTrust

You can use timechart once you've set the _time field.

0 Karma

New Member

Thanks so much Martin, but the problem I have is the file is not indexed and hence I cannot use timechart, I am using chart instead.

0 Karma
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes and swag!