https://community.esri.com/t5/arcgis-dashboards-questions/count-multiple-layers-data-expression/m-p/1549684#M10409 <P>I'm trying to come up with a data expression to create a bar graph to simply show the count (number of records) within 5 different data layers. The layers represent the same type of data, just range from records from 2020-2024.</P><P>I'd like to end up with something like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ONMaps_0-1729194592488.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/117496i5095AAD0456FF7D3/image-size/medium?v=v2&amp;px=400" role="button" title="ONMaps_0-1729194592488.png" alt="ONMaps_0-1729194592488.png" /></span></P><P>Thanks for any guidance!</P> Thu, 17 Oct 2024 19:50:34 GMT ONMaps 2024-10-17T19:50:34Z https://community.esri.com/t5/arcgis-dashboards-questions/count-multiple-layers-data-expression/m-p/1549684#M10409 <P>I'm trying to come up with a data expression to create a bar graph to simply show the count (number of records) within 5 different data layers. The layers represent the same type of data, just range from records from 2020-2024.</P><P>I'd like to end up with something like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ONMaps_0-1729194592488.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/117496i5095AAD0456FF7D3/image-size/medium?v=v2&amp;px=400" role="button" title="ONMaps_0-1729194592488.png" alt="ONMaps_0-1729194592488.png" /></span></P><P>Thanks for any guidance!</P> Thu, 17 Oct 2024 19:50:34 GMT https://community.esri.com/t5/arcgis-dashboards-questions/count-multiple-layers-data-expression/m-p/1549684#M10409 ONMaps 2024-10-17T19:50:34Z https://community.esri.com/t5/arcgis-dashboards-questions/count-multiple-layers-data-expression/m-p/1549919#M10410 <P>There's a GitHub site that contains many different types of data expressions for Dashboard, including <A href="https://github.com/Esri/arcade-expressions/blob/master/dashboard/dashboard_data/CombineMultipleLayers(SerialChart).md" target="_self">one</A> showing how to combine different dataset.</P><P>Here's a script that combines two different dataset, each with a Date field. I'm selecting all the dates that aren't null to populate the table. You can expand this to your five data sets.</P><LI-CODE lang="javascript">var portal = Portal("your portal"); var fs1 = FeatureSetByPortalItem( portal, "itemId for first dataset", 0, ["Date"], false ); var fs2 = FeatureSetByPortalItem( portal, "itemId for first dataset", 0, ["Date"], false ); var features = []; var feat; function populateFeatures(fs) { for (var i in fs) { if (!IsEmpty(i.Date)) { feat = { attributes: { Year: Year(i.Date) } }; Push(features, feat); } } } var featureSets = [fs1, fs2] for (var fs in featureSets) { console(featureSets[fs]) populateFeatures(featureSets[fs]); } var combinedDict = { fields: [{ name: "Year", type: "esriFieldTypeInteger" }], geometryType: "", features: features }; return FeatureSet(combinedDict);</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Snag_6d4b20.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/117542i17C1657F9FCB754E/image-size/medium?v=v2&amp;px=400" role="button" title="Snag_6d4b20.png" alt="Snag_6d4b20.png" /></span></P> Fri, 18 Oct 2024 14:03:08 GMT https://community.esri.com/t5/arcgis-dashboards-questions/count-multiple-layers-data-expression/m-p/1549919#M10410 KenBuja 2024-10-18T14:03:08Z