Rolling Date Bucket List Boxes

[#1]

Looking to create a list box that has four options.

Less than 30 days

Less than 60 days

Less than 90 days

More than 90 days

However everything I have done so far has made 30 day buckets instead. In other words:

0 to 30 days

31 - 60 days

61 - 90 days

90+ days

That wont work for what I need.

What I tried:

=AGGR(

If(WO_Days_Difference >0 and WO_Days_Difference <31, '30 Days or Less',

If(WO_Days_Difference >0 and WO_Days_Difference <61, '60 Days or Less',

If(WO_Days_Difference >0 and WO_Days_Difference <91, '90 Days or Less',

If(WO_Days_Difference >0 and WO_Days_Difference >90, '90 Days or More'))))

, WO_Days_Difference)

[danieloberbilli · Accepted solution]

I would suggest to solve this in the script: create a field for each bucket to flag if the sales goes in this bucket...then use crosstable to combine the fields in one single field.

PFA the qvw.

[#3]

That worked great. Would have been nice to been able to do it in an expression, but whatever works!

[Anonymous]

Thanks for following up Trey- thanks for marking your question as answered which awards points to the members who helped you out.

Best Regards, Sara