Custom/descending order in Domain Filters

0

When selecting a field from a domain for filtering the distinct values are preorderd ascending. How can i change that? I would like them to either be descending or if possible to follow a custom sorting order based on another ranking field in the same table.

I tried pre-filters in the Data Chooser but even there selecting the distinct values the order is ascending and can't be changed. 

How can i achieve this in a Domain?

Alex42's picture
122
Joined: Dec 7 2016 - 4:24am
Last seen: 1 year 3 months ago

Hi,

Move to your report dataset. Click "Edit Query, filter  ans sort options" button. You are able to view sorting option in down. Click the sorting option and in right side Add button will be there. Use that to add the field whatever you want to sort. Default it was an ascending order. If you want to change the order, click the order option to change it to desending.

loyolafranklin67 - 2 years 10 months ago

2 Answers:

0

Hi,

Move to your report dataset. Click "Edit Query, filter  ans sort options" button. You are able to view sorting option in down. Click the sorting option and in right side Add button will be there. Use that to add the field whatever you want to sort. Default it was an ascending order. If you want to change the order, click the order option to change it to desending.

loyolafranklin67's picture
Joined: Dec 19 2017 - 10:06pm
Last seen: 2 years 3 months ago
0

Thanks  fot the reply, i think i wasn't detailed enopugh in my question. I an using Ad-hoc Views, not reports. I would like sorting functionality, either descending or based on ordering column in Ad-hoc views 

Alex42's picture
122
Joined: Dec 7 2016 - 4:24am
Last seen: 1 year 3 months ago
Feedback
randomness