cancel
Showing results for 
Search instead for 
Did you mean: 

filter options displays not in ascending order, Ages <16 displays at the end of the list

saiadithya
8 - Cloud Apps
8 - Cloud Apps

Hi All,

I am wondering if there is any possibility to sort the list in the filter. the values are shown by default in assending order but if one of the value has a special charater like greater than, can we bring it on top of the list. 

Please let me know your thoughts.

Thanks,

Ayantek

4 REPLIES 4

harikm007
13 - Data Warehouse
13 - Data Warehouse

@saiadithya ,

I'm not sure whether we can apply sorting in filter popup window. 

One solution is to change 'Ages < 16' to 'Ages 0-15'. 

Otherwise prefix sequential numbers on each items

example : '1. Ages < 16', '2. Ages 16-19' ...

 

saiadithya
8 - Cloud Apps
8 - Cloud Apps

This could be a good option, i was wondering if we can use any customizations to see that on the top. thanks for the suggestion.

bayram-kapti
8 - Cloud Apps
8 - Cloud Apps

Hi there, 

This is the answer we received from Professional Services when we inquired about this:

  1. Instead of adding prefixes like 1, 2, 3 and so on, you can add spaces to those values. For Example, Monday becomes ' Monday' (with 1 space), Tuesday becomes '  Tuesday' (with 2 spaces), Wednesday becomes '   Wednesday' (3 spaces) and so on.
  2. Remove the '' marks from the above logic.
  3. Sisense removes the trailing spaces in the filter scope but still sorts it using that.
  4. Note that we will be shown the spaces if we download the data as csv.

This saved my life! Thank you!