Sorting

[#1]

these are the values

<100k

100k-250k

250k-1M

1M-3M

3M+

ENN

NHH

and I want them to appear in the same manner in the people chart

but the sorting isn't working.

I tried adding 1,2,3 numbers before these and sort them numerically but it is still not working

any way I can get this done?

[#2]

HI Sagarika,

I also faced same issue before some days. First of all create one another dummy field of age in back-end for sorting purpose.

E.g :

if(Time(Time)<'9:00:00 AM','Before 9:00',

  if(time(Time)>='9:00:00 AM' and Time(Time)<'10:00:00 AM','9:00 - 10:00',

  if(time(Time)>='10:00:00 AM' and time(Time)<'11:00:00 AM','10:00 - 11:00',

  if(time(Time)>='11:00:00 AM' and time(Time)<'12:00:00 PM','11:00 - 12:00',

  if(time(Time)>'12:00:00 PM','After 12:00 '))))) as Time,

  if(Time(Time)<'9:00:00 AM',1,

  if(time(Time)>='9:00:00 AM' and Time(Time)<'10:00:00 AM',2,

  if(time(Time)>='10:00:00 AM' and time(Time)<'11:00:00 AM',3,

  if(time(Time)>='11:00:00 AM' and time(Time)<'12:00:00 PM',4,

  if(time(Time)>'12:00:00 PM',5))))) as Time_Order,

and after creating dummy filed in expression use it in Sorting tab of a chart.

Do sort by Expression. Ascending and Write in expression :

= Time_Order

Take Your original field e.g Time as a dimension.

Regards,

Brijesh.