Forum Discussion
Formatting X Axis - display all values in order
The other thing I noticed in your first post - in the second picture (when the X-Axis is Categorical)
Thy sorting the Chart - Sort by the Date - it looks like it was Sorted by Transactions
Click the ... in top right corner of the Chart and Sort By Date
Yes if you have all dates you can create a column
Column = 0 and place it in the chart - that will force all dates to be seen
however you won't be able to use the legend if you do this...
HTH! :smileyhappy:
Community ChampionIs it also set as date in the Modeling tab?
Aha!
My Date field (not the Hierarchy) is Data Type: Date in the modelling tab.
This is great but for some reason I can only
That is in order but only displaying values with data (transaction count in this case).
The Categorisation option under the X-Axis to show all values is not available now.
The Date Hierarchy field has all the Modelling buttons greyed out when I select it.
I'm planning to upload a table of Dates and a Count of mail pieces, TV spots ,etc...could I cheat and just put a value in for every day with 0's for empty days? Would that force the graph to display each day?
Edit: Thank you very much for helping :)
- Sean
The other thing I noticed in your first post - in the second picture (when the X-Axis is Categorical)
Thy sorting the Chart - Sort by the Date - it looks like it was Sorted by Transactions
Click the ... in top right corner of the Chart and Sort By Date
Yes if you have all dates you can create a column
Column = 0 and place it in the chart - that will force all dates to be seen
however you won't be able to use the legend if you do this...
HTH! :smileyhappy:
Ah, I never knew the sort function was there :) Perfect, thank you very much!