topic Is it possible to achieve a column chart with timechart showing days in every column? in Dashboards & Visualizations

Is it possible to achieve a column chart with timechart showing days in every column?

Mike6960 — Thu, 10 Nov 2022 15:37:17 GMT

I have a search with timechart, If I use the VIS column chart I only see the mondays as date on the axis. Is it possible to show every day per column?

index=test host=test* |my search | eval date=strptime(date,"%A%m/%d/%Y") | timechart span=1d count

Re: Is it possible to achieve a column chart with timechart showing days in every column?

richgalloway — Thu, 10 Nov 2022 16:17:02 GMT

I believe Splunk manages that automatically based on the width of the columns. Fewer columns can be wider, allowing for more labels. You can try overriding that using this in your dashboard.

Re: Is it possible to achieve a column chart with timechart showing days in every column?

johnhuang — Thu, 10 Nov 2022 16:04:30 GMT

Try something like this. You have to manually select the column chart and format the X-Axis Label to rotate vertically.

<base_search> | timechart span=1d count | eval date=strftime(_time, "%Y-%m-%d") | table date count