Day field is messed up in graph ??

[rakesh_498115]

Hi .

i have plotted the line graph using the following query .

| inputlookup statsdata.csv | eval _time=strptime(Day,"%d-%B-%y") | fields _time,AvgBest95,Mean95,UCL95,LCL95

when i use this the _time field is not displaying on the x-axis..

Wat could be the problem ? if all the dates are not displayed can we intermediate dates atlest ..
i.e i have records for the past three months in my statsdata file..so for all these records can i have the intermediate dates displayed on the x-axis, cause it looks awkward with no data displayed on x-axis..

Please help..

thanx

[jonuwz]

You need to use timechart.

This emulates your data :

| gentimes start=-150 | eval date=strftime(starttime,"%d-%B-%y") | streamstats count as AvgBest95 | search (AvgBest95!=*7) | table date AvgBest95

there's a date missing if AvgBest95 contains a 7

adding this :

| eval _time=strptime(date,"%d-%B-%y") | timechart span=1d avg(AvgBest95)

charts your data with dates on the X axis