Forum Discussion

d1x0nl30ng's avatar
d1x0nl30ng
Frequent Visitor
8 years ago
Solved

Sorting visual by year month (months with overlapping years)

i'm just trying out some simple visual with some recent data I have data for Nov 2017, Dec 2017 & Jan2018 but when it display in chart, the sorting is messed up ( on the axis, i have removed the ye...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Dear d1x0nl30ng,

     

    You should use another column with Number, it's the best way for sorting Date.

    Right click on your Table, choose "New column", type a name, ex "Month Key" = FORMAT ( YourColumnDate, "YYYYMM" ) 

    Then sort by Month Key.

     

    Regards,

    ManNVSM.

d1x0nl30ng's avatar
d1x0nl30ng
Frequent Visitor
8 years ago

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Nice to help you :)