Modifying x-axis format

[user789]

I am trying to re-format the x-axis time to read cleaner. Here is my spl:
index="servers" source="/var/log/secure" action=failure
| timechart count
| eval time=_time
|table time count
| fieldformat time=strftime(time, "%Y%m%d%H%M")

How can I get it in a format like %Y-%m-%d %H:%M ?

[richgalloway]

fieldformat should be all you need.

index="servers" source="/var/log/secure" action=failure
| timechart count
| fieldformat _time=strftime(_time, "%Y-%m-%d %H:%M")

[user789]

When I try this, I don't get any results.

[richgalloway]

It works for me, but the format of _time changes only in the timechart output - not in the visualization. The viz appears to be fixed.

[user789]

With this I get a visualization with count on the bottom, then above that, another x-axis labeled" _span".

[richgalloway]

I don't know where "_span" is coming from. On my system it's "_time".
You can turn off the x-axis label, by the way. Click the format icon on the viz and there will be options to control the x-axis, y-axis, legend, and other settings.