topic Re: Filter a layer using a dynamic relative-value in ArcGIS Online Questions

Filter a layer using a dynamic relative-value

RobertoRossi — Mon, 16 Sep 2024 16:03:02 GMT

In a map I’m using a dynamic layer (WFS) which updates daily, containing rain gauge data.

I would like to filter the layer (using the rain amount numeric filed) in order to show only the highest precipitation value feature. When I try to filter the layer using the numeric field I just find only absolute filter expressions:

which apply to a particular value.

Is there a workaround to filter by the greatest value (like Relative-date filters do)?

Roberto

Re: Filter a layer using a dynamic relative-value

KimOllivier — Tue, 17 Sep 2024 22:20:45 GMT

I appears that the field item is not recognised as numeric. I am also wrestling with WFS feeds being read only and intermittent. My idea is to copy the WFS feed to a real Feature Layer daily that you have full control over the schema and also filters. This is easy from Pro, but not ideal and not automated. So maybe a AGOL Notebook with a Task to refresh each night?

I found Arcade is disabled for WFS layers so that is not an option.

Re: Filter a layer using a dynamic relative-value

RobertoRossi — Tue, 17 Sep 2024 22:33:08 GMT

Thank you @KimOllivier , In one version of my Map I already designed a join from a Feature Layer from CSV to a Feature Layer using Data Pipelines: this is the Output Feature Layer: https://arcg.is/eX1qO

The problem is that it seem impossible to filter the layer using the maximum value of numeric field.

Maybe it is possible a workaround using Arcade configuring an expression in styles (or even labels), but I need some help with Arcade...

Re: Filter a layer using a dynamic relative-value

KimOllivier — Wed, 18 Sep 2024 01:56:52 GMT

"Not all Arcade functions are suitable for every profile. For example, profiles that execute expressions for all features in a layer (e.g. visualization and labeling) don't allow expressions to access data via FeatureSet functions."

I don't think you are allowed to use Arcade in a map filter because of the overhead implied. You will have to process the highest value earlier before the data is in a MapView.

Re: Filter a layer using a dynamic relative-value

RobertoRossi — Wed, 18 Sep 2024 08:13:20 GMT

:@KimOllivier , you are right, Arcade is not available in map filters: that's way I was wondering there could be a workaround via styles or labelling...

Re: Filter a layer using a dynamic relative-value

KimOllivier — Wed, 18 Sep 2024 23:56:49 GMT

The only way I have done this is by using the Python API and Pandas to find the maximum value and then update a field