Forum Discussion

rarora20's avatar
rarora20
Regular Visitor
8 years ago
Solved

Sorting by Month Number

Hello,   I have a month and year column. I have created a conditional column which gives me the month number based on the month name. When I try to sort the data by the conditional column(Number), ...
  • parry2k's avatar
    parry2k
    8 years ago

    rarora20 make sure to change date type for your new column M# to whole number, it is string , you will not get correct sort because with string sort will go like this

    1

    10

    11

    12

    2

    3

    4

    5

    6

    7

    8

    9

     

    and that is the reason you see Jan, Oct, Nov, Dec and so on..

parry2k's avatar
parry2k
Super User
8 years ago

rarora20 make sure to change date type for your new column M# to whole number, it is string , you will not get correct sort because with string sort will go like this

1

10

11

12

2

3

4

5

6

7

8

9

 

and that is the reason you see Jan, Oct, Nov, Dec and so on..

  • sevenhills's avatar
    sevenhills
    Super User
    8 years ago

     

    In the query editor, select your query, select your month (ie., number) column, right click, change type, click whole number. 

     

    You can do the same using Data Type as "whole number".

     

    Basically, when you added conditional column, it shows Data Type as Any. You need to fix it as Whole number.

     

    After this, Verify: Data Tab in the main app: Make sure for the month: january, feb ... column, sort by column is still the number column. 

     

    Save. Now the order should be good and recreate the chart (if it is not fixed).

  • rarora20's avatar
    rarora20
    Regular Visitor
    8 years ago

    parry2k You just hit all the right chords!! Thanks a ton!! Cheers!

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    Awesome, glad to head that issue is fixed :) 


    Cheers,