Alternative to slider using listbox

[#1]

I want to have a listbox display the values 0, 100k, 500k, 5m, 10m, 100m. I want the selections in this listbox to tie to another value: Sales.

So if the user drags 100k to 5m the page will only show sales between these two values.

In all, I want it to work the same as if I just had a Sales listbox on the page but I'd rather do this than have thousands of sales numbers in the listbox. I can't use a slider. Thanks!

[vgutkovsky]

You would make the listbox over an "expression" and the expression would be something like:

if(Sales<=100000,
'100K',
if(Sales<=500000,
'500K'

etc. But it might be better to create a bucket in your script instead of in the front end. Just move this IF logic to the script and create a new "bucket" field that would be associated with each row of Sales.

Cheers,

[johnw]

I agree with the bucket approach, and with creating it in the script. I'd probably then make the values include the range to be clear what range you're selecting when you pick '100k'.

<100k
100k-<500k
500k-<5m
5m-<10m
10m-<100m
100+m

Or however you want it displayed.