sorting data by Month-year

Raju_6952 — Mon, 08 Jan 2024 11:38:14 GMT

Hi,

I have data like below format,

Sep-22

Oct-22

Nov-22

Dec-22

Jan-23

Feb-23

Mar-23

Apr-23

May-23

Jun-23

Jul-23

Aug-23

I tried sort by expression and Used Year*100+Month,But in the chart the sorting is not in the above specified order,Any suggestions to make it works better.

Re: sorting data by Month-year

Or — Mon, 08 Jan 2024 11:51:08 GMT

Are these actually date fields? Or are they textual? If they're textual, you'll need to first convert them to dates (using e.g. MonthName(date#(YourField,'MMM-YY')).

topic Re: sorting data by Month-year in App Development

sorting data by Month-year

Re: sorting data by Month-year