Choose Language Hide Translation Bar
Highlighted
mightykd
Level I

date increments x-axis

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.

238407Picture1.png

3 REPLIES 3
Highlighted
txnelson
Super User

Re: date increments x-axis

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

dateaxis.PNG

Jim
Highlighted
mightykd
Level I

Re: date increments x-axis

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.
Highlighted
txnelson
Super User

Re: date increments x-axis

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.

Jim
Article Labels

    There are no labels assigned to this post.