Forum Discussion

saiadithya's avatar
saiadithya
Cloud Apps
02-14-2022

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

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

Replies have been turned off for this discussion
  • 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.
  • harikm007's avatar
    harikm007
    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' ...

     

  • 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.