topic Re: Modifying x-axis format in Splunk Search

Modifying x-axis format

user789 — Mon, 08 Jun 2020 18:06:23 GMT

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 ?

Re: Modifying x-axis format

richgalloway — Tue, 02 Jun 2020 14:10:24 GMT

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

Re: Modifying x-axis format

user789 — Tue, 02 Jun 2020 15:24:29 GMT

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

Re: Modifying x-axis format

richgalloway — Tue, 02 Jun 2020 17:15:08 GMT

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.

Re: Modifying x-axis format

user789 — Tue, 02 Jun 2020 18:14:03 GMT

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

Re: Modifying x-axis format

richgalloway — Wed, 30 Sep 2020 05:36:44 GMT

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.