Bucket sorting issue

Fri, 20 Nov 2020 18:02:30 GMT

hi all,

I have created one bucket but its sorting is not proper....

How to make it as per my script...

I have attached my sample application...

Re: Bucket sorting issue

tresB — Thu, 12 Nov 2015 05:47:04 GMT

Sort by exp:

SubField(PurgeChar(BUCKET,'+'),'-',1)

tamilarasu — Thu, 12 Nov 2015 05:47:52 GMT

Hi Akshata,

Your data format is text, so try the below in listbox property

Let me know

Kushal_Chawda — Thu, 12 Nov 2015 05:56:35 GMT

best way to do it is using Dual function in script

create your bucket like below

IF( ([Target Completion Date]-[Main Start Date])>=0 AND ([Target Completion Date]-[Main Start Date])<=2, dual('0-2',1) ,

IF( ([Target Completion Date]-[Main Start Date])>=3 AND ([Target Completion Date]-[Main Start Date])<=5, dual('3-5',2),

IF( ([Target Completion Date]-[Main Start Date])>=6 AND ([Target Completion Date]-[Main Start Date])<=10, dual('6-10',3),

IF( ([Target Completion Date]-[Main Start Date])>=11 AND ([Target Completion Date]-[Main Start Date])<=15, dual('11-15',4),

IF( ([Target Completion Date]-[Main Start Date])>=16 AND ([Target Completion Date]-[Main Start Date])<=20, dual('16-20',5),

IF( ([Target Completion Date]-[Main Start Date])>=21 AND ([Target Completion Date]-[Main Start Date])<=25,dual( '21-25',6),

IF( ([Target Completion Date]-[Main Start Date])>=26 AND ([Target Completion Date]-[Main Start Date])<=30,dual( '26-30',7),

IF( ([Target Completion Date]-[Main Start Date])>=31 AND ([Target Completion Date]-[Main Start Date])<=40, dual('31-40',8),

dual('40+',9))))))))) AS BUCKET,

Now go to properties of list box , go to sort tab, sort it by Numerical value asc or desc

Anonymous — Thu, 12 Nov 2015 06:28:08 GMT

Or you can do something like this:

see the attachment..

buzzy996 — Thu, 12 Nov 2015 10:47:35 GMT

see tis,