month order

[master_student]

Hello Guys,

As you can see bellow, my graph is not sorted

my expression is month(date_calcul) & year(date_calcul)

Any idea, how to solve this?

Thanks

[Anil_Babu_Samineni]

Use Quite Date Function

MonthName(DateField) as MonthName1

OR

Date(DateField,'MMM YYYY') as MonthName1

Then use MonthName1 as Dimension / You can use same for dim which can be done Calculation

Then go to sort and apply as per your needs

[vinieme12]

Try "Sort by expression"

NUM#(DATE(date_calcul,'YYYYMM'))