Forum Discussion
Sort Graph by Month and Year
Hi All, Help needed. Can I have this graph sorted to have (left to right), Jan 2018, Dec 2017, Nov 2017 so on...? Thanks, Paul
Hi Polaris,
You could create a new column in your table in the query editor and input the order in which you wish to see the dates by creating an index e.g.
Jan 2018 = 1
Dec 2017 = 2
Nov 2017 = 3
Once you've done that then sort the graph via the index created. But i would advise creating the table oldest date to newest for ease of use.
good solution, I could solved the same problem thank to your comment.