Allow a Single Return Arcade Expression in the Layout as a Dynamic Text Option

592
0
09-20-2022 10:42 AM
Status: Open
Labels (1)
feralcatcolonist_old
Occasional Contributor II

Currently, within the Layout a user is able to embed an ArcGIS Arcade Expression as an Insert Table Attribute, this is great for returning multiple delimited items but not great when they just want a single item returned.

The following image shows a single return that was created by isolating the result to a single OBJECTID; however, this approach requires a user to know/verify that a single OBJECTID exists ahead of time because you cannot write a SQL query like: OBJECTID = MIN(OBJECTID)

feralcatcolonist_0-1663695335960.png

feralcatcolonist_3-1663695716457.png

For this example, we are tallying up votes in a protest map. Without a definition query to a single record, we'd end up with the results per record or per visible record.

Ideally, we could use a Table Statistic to set to an Arcade Expression

feralcatcolonist_1-1663695440577.png

feralcatcolonist_2-1663695574787.png

That's it!