topic splunk timechart skipping x axis - months in Dashboards & Visualizations

splunk timechart skipping x axis - months

Bentash — Thu, 01 Mar 2018 18:11:50 GMT

| timechart span=1mon count by "members" keep skipping month.
I want it to be more cosistent and show all months.

why August, October, December are not populating their text when there is clearly a count visible

Re: splunk timechart skipping x axis - months

cmerriman — Thu, 01 Mar 2018 19:29:06 GMT

is it a month with no data? can you try to add |makecontinuous _time span=1mon before the timechart? you can also add limit=0 to your timechart to make sure no members get excluded.

http://docs.splunk.com/Documentation/Splunk/7.0.2/SearchReference/Makecontinuous

Re: splunk timechart skipping x axis - months

skoelpin — Thu, 01 Mar 2018 19:34:09 GMT

It looks like he's asking why August, October, December are not populating their text when there is clearly a count visible

Re: splunk timechart skipping x axis - months

cmerriman — Thu, 01 Mar 2018 19:55:48 GMT

wow i wildly misread that question. My mistake. if you can put this in a dashboard (or if it already is in one) you can adjust the axis label.
charting.axisLabelsX.majorLabelStyle.rotation in simpleXML to rotate it 45 or 90 degrees. that will probably help.
http://docs.splunk.com/Documentation/SplunkCloud/6.6.3/Viz/ChartConfigurationReference#Area.2C_Bubble.2C_Bar.2C_Column.2C_Line.2C_and_Scatter_charts

Re: splunk timechart skipping x axis - months

Bentash — Tue, 29 Sep 2020 18:17:12 GMT

| where _time>=info_min_time AND (_time<=info_max_time OR info_max_time="+Infinity")
| makecontinuous _time
| timechart span=1mon count by "members" limit=0

Tried this but didnt work

Re: splunk timechart skipping x axis - months

Bentash — Thu, 01 Mar 2018 21:11:13 GMT

45 tried this but still not showing all months.

Re: splunk timechart skipping x axis - months

kmaron — Fri, 02 Mar 2018 18:01:40 GMT

If you change the label rotation it should work.

Under Format click the tab for X-axis. Then change your Label Rotation to -90.

Re: splunk timechart skipping x axis - months

Bentash — Fri, 02 Mar 2018 19:17:51 GMT

thanks.. that worked after rotating them