https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1129251#M5579 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/363906">@jcarlson</a>&nbsp;, one more question, from the two layers, I want to get a shared field as a long list. For example, I want to have a list of all object IDs from both layers. any idea to edit the expression?</P> Tue, 28 Dec 2021 20:06:29 GMT SayedWali 2021-12-28T20:06:29Z https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1127958#M5520 <P>I want to create an indicator to count items from multiple layers. Is there any arcade expression example or any reference? Any idea will be appreciated.</P> Tue, 21 Dec 2021 10:19:25 GMT https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1127958#M5520 SayedWali 2021-12-21T10:19:25Z https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1127998#M5524 <P>There are a number of examples on ESRI's Arcade expressions GitHub repo. Here's one that counts items from multiple layers for a chart:</P><P><A href="https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/CombineMultipleLayers(SerialChart).md" target="_blank">https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/CombineMultipleLayers(SerialChart).md</A></P><P>If you haven't used a Data Expression before, they can look a lot more complicated than they really are. The linked example should apply just as easily to an Indicator widget.</P> Tue, 21 Dec 2021 14:18:06 GMT https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1127998#M5524 jcarlson 2021-12-21T14:18:06Z https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1129138#M5570 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/216231">@SayedWali</a>-&nbsp; Just to recap and post the solution here, rather than in a private message:</P><LI-CODE lang="javascript">var portal = Portal('https://npaid.maps.arcgis.com'); var FAR = FeatureSetByPortalItem( portal, '56db417ebbc541bcbb6ccf9c49524cc9', 0, ['*'], false ) var PDIA = FeatureSetByPortalItem( portal, '56db417ebbc541bcbb6ccf9c49524cc9', 0, ['*'], false ) var total_count = Count(FAR) + Count(PDIA) var outDict = { fields: [{ name: 'total', type: 'esriFieldTypeInteger'}], geometryType: '', features: [{attributes: {total: total_count}}], }; // Return dictionary cast as a feature set return FeatureSet(Text(outDict));</LI-CODE><P>&nbsp;</P> Tue, 28 Dec 2021 13:54:50 GMT https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1129138#M5570 jcarlson 2021-12-28T13:54:50Z https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1129237#M5574 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/363906">@jcarlson</a>&nbsp;, Thank you very much!</P> Tue, 28 Dec 2021 19:43:08 GMT https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1129237#M5574 SayedWali 2021-12-28T19:43:08Z https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1129251#M5579 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/363906">@jcarlson</a>&nbsp;, one more question, from the two layers, I want to get a shared field as a long list. For example, I want to have a list of all object IDs from both layers. any idea to edit the expression?</P> Tue, 28 Dec 2021 20:06:29 GMT https://community.esri.com/t5/arcgis-dashboards-questions/expression-to-count-total-from-multiple-layers/m-p/1129251#M5579 SayedWali 2021-12-28T20:06:29Z