Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have this filter pane:
Is it possible to relocate the "> 60000" to the bottom? I tried to play with the sort options but none works.
I would normally add a sort order in Script and then order the filter by that field.
I.e.
Load * inline [
RangeOrder:
5001 - 10000, 1
10000 - 15000,2
>60000,3
];
Range, RangeOrder
Try sorting by expression or creating a master dimension like:
IF([Range]='5001-10000', dual('5001-1000', 1),
IF([Range]='10001-15000', dual('10001-15000', 2),
IF([Range]='>60000', dual('>60000', 3))))