month order

master_student · ‎2017-02-20

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 · ‎2017-02-20

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-02-20

Try "Sort by expression"

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Related Topics