Dashboards & Visualizations

Formatting _time on X-axis of a Chart

jbrenner
Path Finder

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

0 Karma

cmerriman
Super Champion

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

jbrenner
Path Finder

I'm not using "chart" or "timechart".
I'm using "bucket _time span=1d"

Thanks,
Jonathan

0 Karma
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!