Forum Discussion

PatP's avatar
PatP
Frequent Visitor
8 years ago
Solved

Months in wrong order

Hi!   I’m trying to order months in the right order in a table and in a graph. From what I understand, I have to order by month number in my “Date” Table, but it doesn’t work. What I am doing wrong...
Need Help
  • rema's avatar
    rema
    8 years ago

    Hi PatP

    I think your monthnumber column is text field instead of number. You can check once.

drewlewis15's avatar
drewlewis15
Solution Specialist
8 years ago

Are you, by chance, trying to solve this by sorting the month number column, itself?  If so, that will not work.  You need to select the Month Name column, and then choose the "Sort by Column" option.  From there, choose to sort by the month number column.

 

 

That will turn your chart from looking like this:

 

To this:

 

 

  • PatP's avatar
    PatP
    Frequent Visitor
    8 years ago

    This is exactly what I did, but the order in the table and chart remain the same. What else could explain this?

     

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      In that Table, ensure that you keep your active cell in the Month column and then go to Sort by Column.

      • PatP's avatar
        PatP
        Frequent Visitor
        8 years ago
        Hi,

        Thanks for your reply. This is what I did that you can see in my last screenshot I think. Is that what you mean or something else that I'm missing?