Age bucket sorting

[ajsjoshua]

Dear all,

I am using this in script for age bucket

If(Age <=10, '<10 Years',

    IF(Age >= 11 and Age < 20, '11 - 20',

  IF(Age >= 21 and Age < 30, '21 - 30',

  IF(Age >= 31 and Age < 40, '31 - 40',

  IF(Age >= 41 and Age < 50, '41 - 50',

  IF(Age >= 51 and Age < 60, '51 - 60',

  IF(Age >= 61 and Age < 70, '61 - 70',

  IF(Age >= 71 and Age < 80, '71 - 80',

  IF(Age >= 81 and Age < 90, '81 - 90',

  IF(Age >= 91 and Age < 100, '91 - 100',

'100+')))))))))) as AgeRange,

When i use this AgeRange dimension in bar chart i am not getting the dimension in proper  order.I want to sort like this

<10 Years,'11 - 20','21 - 30','31 - 40','41 - 50','51 - 60','61 - 70','71 - 80','81 - 90','91 - 100', '100+'

PFA for screenshot

[sunny_talwar · Accepted solution]

Try this

If(Age <=10, Dual('<10 Years', 1),

  IF(Age >= 11 and Age < 20, Dual('11 - 20', 2),

  IF(Age >= 21 and Age < 30, Dual('21 - 30', 3),

  IF(Age >= 31 and Age < 40, Dual('31 - 40', 4),

  IF(Age >= 41 and Age < 50, Dual('41 - 50', 5),

  IF(Age >= 51 and Age < 60, Dual('51 - 60', 6),

  IF(Age >= 61 and Age < 70, Dual('61 - 70', 7),

  IF(Age >= 71 and Age < 80, Dual('71 - 80', 8),

  IF(Age >= 81 and Age < 90, Dual('81 - 90', 9),

  IF(Age >= 91 and Age < 100, Dual('91 - 100', 10),

Dual('100+', 11))))))))))) as AgeRange,

[Anil_Babu_Samineni]

Try this, add similar to all

If(Age <=10, '<10 Years',

    IF(Age >= 11 and Age < 20, dual('11 - 20',1),

  IF(Age >= 21 and Age < 30, dual('21 - 30',2),

  IF(Age >= 31 and Age < 40, '31 - 40',

  IF(Age >= 41 and Age < 50, '41 - 50',

  IF(Age >= 51 and Age < 60, '51 - 60',

  IF(Age >= 61 and Age < 70, '61 - 70',

  IF(Age >= 71 and Age < 80, '71 - 80',

  IF(Age >= 81 and Age < 90, '81 - 90',

  IF(Age >= 91 and Age < 100, '91 - 100',

'100+')))))))))) as AgeRange,