Sort value in Block chart

[Anonymous]

Hi ,

I have a block chart like this

I used calculated dimension:

=if(CountOfExpiryDate>180,'>6 Months',if(CountOfExpiryDate>60 and CountOfExpiryDate<181,'2 to 6 Months',if(CountOfExpiryDate<61 and CountOfExpiryDate>0,'<2 Months','Expired')))

Expression is Count(EmployeeID)

CountOfExpiryDate is consists of date count

But there is a problem  I need to show the chart like below chart, The value should be show in sort in ascending order ,and how can I sort the value in a block chart

Regards,

Vijay.M

[sunny_talwar]

May be like this

=

if(CountOfExpiryDate>180, Dual('>6 Months', 1),

if(CountOfExpiryDate>60 and CountOfExpiryDate<181, Dual('2 to 6 Months', 2),

if(CountOfExpiryDate<61 and CountOfExpiryDate>0, Dual('<2 Months', 3),

Dual('Expired', 4))))

[Anonymous]

Sorry Sunny, its not working which you given condition,may i know is any other condition like this.

[sunny_talwar]

Did you use the above as your calculated dimension?

[Anonymous]

yes I have used the above as my calculated dimension.

[sunny_talwar]

Would you be able to share your app to look at this?

[Anonymous]

Sorry I don't know to share  can you guide me

[sunny_talwar]

Check these links

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample