Sorting Months

[nicouek]

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 

[marksouzacosta · Accepted solution]

Hi @nicouek,

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

Regards,

Mark Costa

[lennart_mo]

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))

[anat]

you may try one of the below method

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

or
year * 100 + month

or
MonthName(date)

[nicouek]

Hi, @marksouzacosta,

It worked beautifully!

Thank you

[nicouek]

Thank you will try that later!

Thanks

[nicouek]

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

Thank you