Forum Discussion

Prabha45's avatar
Prabha45
Helper III
3 years ago
Solved

Sort by month

Hello, I need to sort my visual by month in a year. I sorted month name column by month(pic 1 ) which I had used in my visual. I sort the axis in the visual(pic2). But didn't work. It is showing as Jan,Oct,Nov,Dec,Feb,March,......Sep. What am I missing ? TIA


I

Need Help
Show and Tell
Tips and Tricks
  • Arul's avatar
    Arul
    3 years ago

    Prabha45 ,

    Can you check the datatype of month column? I think the datatype of month column now is text. If you check datatype of month column and change it to whole number, It will work.

    Thanks,

    Arul

     

1 Reply

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Prabha45 ,

    Can you check the datatype of month column? I think the datatype of month column now is text. If you check datatype of month column and change it to whole number, It will work.

    Thanks,

    Arul