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: