<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Allow a Single Return Arcade Expression in the Layout as a Dynamic Text Option in ArcGIS Pro Ideas</title>
    <link>https://community.esri.com/t5/arcgis-pro-ideas/allow-a-single-return-arcade-expression-in-the/idi-p/1214289</link>
    <description>&lt;P&gt;Currently, within the Layout a user is able to embed an ArcGIS Arcade Expression as an&amp;nbsp;&lt;EM&gt;Insert Table Attribute&lt;/EM&gt;, this is great for returning multiple delimited items but not great when they just want a single item returned.&lt;/P&gt;&lt;P&gt;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)&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_0-1663695335960.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51654i50935041DD9711DC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_0-1663695335960.png" alt="feralcatcolonist_0-1663695335960.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_3-1663695716457.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51657iCFB8071115D6959F/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_3-1663695716457.png" alt="feralcatcolonist_3-1663695716457.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Ideally, we could use a&amp;nbsp;&lt;EM&gt;Table Statistic &lt;/EM&gt;to&amp;nbsp;set to an Arcade Expression&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_1-1663695440577.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51655iD4415F6366418FCC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_1-1663695440577.png" alt="feralcatcolonist_1-1663695440577.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_2-1663695574787.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51656i810AC3012D9A8770/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_2-1663695574787.png" alt="feralcatcolonist_2-1663695574787.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;That's it!&lt;/P&gt;</description>
    <pubDate>Tue, 20 Sep 2022 17:42:58 GMT</pubDate>
    <dc:creator>feralcatcolonist_old</dc:creator>
    <dc:date>2022-09-20T17:42:58Z</dc:date>
    <item>
      <title>Allow a Single Return Arcade Expression in the Layout as a Dynamic Text Option</title>
      <link>https://community.esri.com/t5/arcgis-pro-ideas/allow-a-single-return-arcade-expression-in-the/idi-p/1214289</link>
      <description>&lt;P&gt;Currently, within the Layout a user is able to embed an ArcGIS Arcade Expression as an&amp;nbsp;&lt;EM&gt;Insert Table Attribute&lt;/EM&gt;, this is great for returning multiple delimited items but not great when they just want a single item returned.&lt;/P&gt;&lt;P&gt;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)&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_0-1663695335960.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51654i50935041DD9711DC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_0-1663695335960.png" alt="feralcatcolonist_0-1663695335960.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_3-1663695716457.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51657iCFB8071115D6959F/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_3-1663695716457.png" alt="feralcatcolonist_3-1663695716457.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Ideally, we could use a&amp;nbsp;&lt;EM&gt;Table Statistic &lt;/EM&gt;to&amp;nbsp;set to an Arcade Expression&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_1-1663695440577.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51655iD4415F6366418FCC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_1-1663695440577.png" alt="feralcatcolonist_1-1663695440577.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_2-1663695574787.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/51656i810AC3012D9A8770/image-size/medium?v=v2&amp;amp;px=400" role="button" title="feralcatcolonist_2-1663695574787.png" alt="feralcatcolonist_2-1663695574787.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;That's it!&lt;/P&gt;</description>
      <pubDate>Tue, 20 Sep 2022 17:42:58 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-ideas/allow-a-single-return-arcade-expression-in-the/idi-p/1214289</guid>
      <dc:creator>feralcatcolonist_old</dc:creator>
      <dc:date>2022-09-20T17:42:58Z</dc:date>
    </item>
  </channel>
</rss>

