I am using a filter widget in experience builder that I want to automatically select the minimum value of an attribute field (for the sake of this post, let's say it's OBJECTID). The reason for this being that as the feature layer in the map updates, the filter widget will reduce what's visible on the map in experience builder to whichever row has the lowest OBJECTID value.
I could write this in SQL easy enough, the problem I'm encountering is that SQL Expressions for filtering can only be constructed in the SQL Expression Builder, which does not enable filtering by minimum / maximum values. Interestingly, I can see the SQL code underneath the SQL Expression Builder after making other filters, but cannot edit it.
Is there a way to edit this code, and if not, does anyone have any recommendations on how to use the filter widget to select the minimum OBJECTID value in a feature layer? Thank you for any advice.
At this time you cannot write/edit the SQL in the filter widget, though it has been suggested already as an idea, so I definitely recommend going over and giving it a kudo because it would be really useful!
A workaround could be the following:
Great workaround! Thanks for sharing and instructing. I've used data views similarly to make workaround text indicators numbers and feature boxes. I miss Dashboard indicators!