Forum Discussion
Organize data on column chart from the oldest data to the newest
Hi everyone, I have a column chart and I want to organize my data from the oldest data to the newest. In this case, for an unknown reason the data is organized like this: 2020, Dec / 2020, Nov /2021,...
You need to change your YearMonth definition to
YearMonth = FORMAT([Created],"YYYYMM")
or introduce a "Sort By" column that sorts by month number, not by month name.
lbendlin
Super User
Super UserYou need to change your YearMonth definition to
YearMonth = FORMAT([Created],"YYYYMM")
or introduce a "Sort By" column that sorts by month number, not by month name.
Thank you so much and sorry for this silly question! 😬