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
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)