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

see below screenshot, i need to group my data by months, there isnt any other meaningful column i can sort with existing data.

Do i need to create another column (i.e. for nov2017 - 1, dec2017 - 2, jan2018 -3 , then sort ascending 1,2,3 ) ??

 

 

Anonymous's avatar
Anonymous
Not applicable
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 :)