Community
Select to view content in your preferred language

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

1203
0
09-20-2022 10:42 AM
Status: Open
Labels (1)
Labels
feralcatcolonist_old
by
Frequent Contributor

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.pngferalcatcolonist_0-1663695335960.png

feralcatcolonist_3-1663695716457.pngferalcatcolonist_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.pngferalcatcolonist_1-1663695440577.png

feralcatcolonist_2-1663695574787.pngferalcatcolonist_2-1663695574787.png

That's it!