topic Re: Sorting Months in App Development

Sorting Months

nicouek — Tue, 25 Jun 2024 12:56:59 GMT

Hi, all

I need a bit of help with a problem.

I have developed this report last year to show count of sales per month for the past 6 months , it's doing that just fine... (FYI aggregation for past six months was done using past -180 days NOT months).

The issue I am having is that, my months on the X axis are not displaying in the desired order, JAN and FEB are 2024; SEPT, OCT, NOV, and DEC are 2023. I would like last year QUARTER to be displayed before JAN and FEB how do I setup for the visualization to follow the right calendar order?

Thank you

Re: Sorting Months

marksouzacosta — Tue, 25 Jun 2024 13:39:47 GMT

Hi @nicouek,

Change the sort of your Month Dimension to be by Month Year, like the example below:

Regards,

Mark Costa

Re: Sorting Months

lennart_mo — Tue, 25 Jun 2024 13:40:22 GMT

I'm guessing you used Month(PostingDate) for your Dimension.

If you want this to be the case still you can try using the Dual() function, where you can define a text and a number value. The text will be displayed but the number is used to calculate and sort the data.

So your formula could look like this:

=DUAL(Month(PostingDate), MonthName(PostingDate))

Re: Sorting Months

anat — Tue, 25 Jun 2024 13:47:57 GMT

you may try one of the below method

MonthName(date#(YourField,'MMM-YY'))

or
year * 100 + month

or
MonthName(date)

Re: Sorting Months

nicouek — Tue, 25 Jun 2024 14:44:08 GMT

Hi, @marksouzacosta,

It worked beautifully!

Thank you

Re: Sorting Months

nicouek — Tue, 25 Jun 2024 14:45:41 GMT

Thank you will try that later!

Thanks

Re: Sorting Months

nicouek — Tue, 25 Jun 2024 14:46:39 GMT

Thank you very much, I found a solution for now, however will try your suggestion later.

Thank you