Select to view content in your preferred language

Sort order in Filter Widget

16823
14
02-02-2022 01:38 PM
RhettZufelt
MVP Notable Contributor

Is there a way to change the sort order in the filter widget, especially to Natural Sort?

I have set up an expression using the unique values option.  Nice as it gives me the list of values to filter on, but they are sorted alphabetically, and I need a natural sort option.

Really confusing the the user when things are way farther down the list than expecting.

W1 and W2 should come before 10, and so on.

Looks like thisWant to look like this
W10-1W1-1
W11-1W2-4
W1-1W10-1
W2-4W11-1
14 Replies
kmsmikrud
Frequent Contributor

Hello,

I was trying to migrate a dashboard to EB for the sole reason of the filter option being able to have more flexibility in the statements. I need a filter that will select values from within a list so it was suggested to use EB.

Similar to other posts here, I am finding the sort options not great. For instance, I would like to be able to filter the data by year and so I'm using all unique values. However I would like it to open with the most recent year as the default value.  I tried creating a view with year values sorted descending but the filter still shows the years ascending. I also don't see an option to have the last year be the default. Is this possible?

The frustrating thing is the dashboard selectors allow default values with first and last and apparently more functionality than the filter widget EB. However the dashboard selectors only have equal/does not equal for options hence the reason I'm trying to now use EB. Now I'm struggling with sort and default values in the EB filter. Hopefully I'm just overlooking settings.

Thanks!,

Kathy

LAG155
by
Occasional Contributor
Hello, the same thing is happening to me with the months of the year.
I tried using the default values ​​however the widget sorts it automatically without respecting the order of the given list.

PLEASE TAKE INTO ACCOUNT THE IMPROVEMENT


 

BrittanyBurson
Frequent Contributor

BrittanyBurson_0-1704486483747.png

BrittanyBurson_1-1704486501120.png

Super unfortunate this is a thing. We need control over the sorting order, can't just be alphabetical.

 

 

RyanBohan
Frequent Contributor

Please consider upvoting the Idea to add this functionality to Experience Builder. Filter Widget | Option to display order of predefi... - Esri Community

ryan_grammer
Esri Contributor

Hello all, this has been logged as ENH-000150684: "In the ArcGIS Experience Builder Filter widget, provide the ability to keep the order of the predefined values."

Please reach out to Esri Technical Support and open a case to have your account added to this enhancement request. The support ticket request can be submitted as, "I am running into a known limitation when trying to change the display order of predefined values in the Filter widget (ArcGIS Experience Builder). There is an enhancement for this issue, ENH-000150684, and I would like to be added to it."

Thank you,

Ryan Grammer | ArcGIS Enterprise Support Analyst