topic Re: date increments x-axis in Discussions

date increments x-axis

mightykd — Thu, 12 Dec 2019 21:28:12 GMT

I'd like to set specific date increments, starting at a specific date and then every 6 months (even if there are data gaps), on the x-axis of a graph with a secondary y axis. However, only numerical increments are available on the axis settings. I suspect it has to do with how the column "date" is defined, but I just can't seem to figure out the correct set up. The data table and graph are attached. Any insight would be greatly appreciated! Thanks.

Re: date increments x-axis

txnelson — Fri, 13 Dec 2019 03:52:58 GMT

If you change the modeling type of your Date column, from "None" to "Continuous", you will be able to go into the Axis Settings and set the min and increment specs to what you want

Re: date increments x-axis

mightykd — Mon, 16 Dec 2019 16:43:55 GMT

Minimum and maximum date of axis and increments by month are indeed
available if I go into Column Info, Column Properties, Axis, Set Axis
Settings. However, when I apply the new settings, the graph becomes blank.

Re: date increments x-axis

txnelson — Mon, 16 Dec 2019 18:27:02 GMT

What I showed in my last entry, is not the same approach you are taking. I was not changing the Axis Column Property. Rather, what I demonstrated was simply going directly to the axis of question, on the Graph Builder output, and right clicking on it, and going to Axis Settings. I would not expect your approach to yield different results, but they might.

I would suggest that you go to the Axis Column Property, and remove it. Then go directly to the Graph Builder Axis, and make the axis changes there. Make sure your column in question has a Data Type as numeric and a Modeling Type of Continuous.