Dec 12, 2019 1:17 PM
| Last Modified: Dec 12, 2019 1:28 PM(760 views)
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.
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.
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.