Simple issue but devilish: I have multiple year data with a simple 'create date' field in it for each record.
For one view I'd like to show the data in chronological order in a simple stacked chart, but when i span multiple years it shows months in year order (Jan - Dec) and just puts the data from each month side by side
Ie. if i show July 18 - July 19 it starts with Jan 19, Feb 19....July 18/July 19, Aug18/Aug 19, etc.....
I would like to show earliest date to current date (true chronological order)
July 18, Aug 18, Sept 18, ..... Jan 19, Feb 19, ,....July 19
so the above chart would START with July 18 (orange) and proceed through chronologically to July 19 (DkBlue)
So now usage date looks something like "201904" or "201912". From there, you may need to create another custom column that has both the month name and the year in it. I don't think you will be able to just sort a column of months with my following method since there will be repeats in the month column otherwise.
Go to modeling, click Sort by Column, and select the new usageDate column. As a result, the Month-Year column (which you will have to create a custom column for) will now sort by the usageDate which is effectively just a number that increases as months and years go on.