Arcade Expression to dynamically symbolize based on the lowest value across all features

AustinCanty1 — Thu, 11 Aug 2022 12:50:31 GMT

I have a point feature that has an integer field called 'Sequence'. I'd like dynamically symbolize the point so that it always highlights the lowest value in the sequence.

I can do something like this within the popup, but featuresets are not available in symbology. Is there another way to accomplish this without using a featureset?

var fs = FeatureSetByName($map, "Next Hydrant"), Sequence;
return first(fs).Sequence

Re: Arcade Expression to dynamically symbolize based on the lowest value across all features

JohannesLindner — Thu, 11 Aug 2022 07:01:18 GMT

You could use Graduated Colors, but that wouldn't be dynamic.

You could probably rig something up with a calculation attribute rule. Add an integer field. When you insert/delete a feature or when you update the Sequence field, get the minimum Sequence value of the featureset, then update the new field of all features to 0 or 1, depending on whether their Sequence is the lowest. Symbolize with Unique Values on the new field.

It might be easier to just add the layer to the map a second time and set its definition query:

Sequence IN (Select MIN(Sequence) AS SmallestSequence FROM DatabaseName.DataOwner.TableName)

This will only show the feature(s) with the smallest Sequence value. Then you can use that layer to highlight these features:

topic Arcade Expression to dynamically symbolize based on the lowest value across all features in ArcGIS Field Maps Questions

Arcade Expression to dynamically symbolize based on the lowest value across all features

Re: Arcade Expression to dynamically symbolize based on the lowest value across all features