I have a chart in which each bar represents a day's worth of data.
Even though the values for _time are formatted like "2017-11-29" when I run the query, the values along the X-axis of the chart are displayed in the following format:
2017-11-29T00:00:00.000-05:00
Does anyone know how to get the values along the x-axis to display in the "2017-11-29" format?
Thanks,
Jonathan
Are you using chart
or timechart
? timechart span=1d....
should automatically format the time of the axis nicely. Otherwise, you’ll want to do a fieldformat
or eval
on your _time
field to display it how you wish. Something like eval day=strftime(_time,"%Y-%m-%d") |chart count by day
I'm not using "chart" or "timechart".
I'm using "bucket _time span=1d"
Thanks,
Jonathan