topic Creating a Temp Feature Set for Stacked Serial Chart in ArcGIS Dashboards Questions

topic Creating a Temp Feature Set for Stacked Serial Chart in ArcGIS Dashboards Questions https://community.esri.com/t5/arcgis-dashboards-questions/creating-a-temp-feature-set-for-stacked-serial/m-p/1130624#M5625 <P>I want to stack three different layers and group them by their own date field. For some reason, my Arcade code is working but no data is showing in the data table below. I am assuming this is a small tweak to the code but wasnt sure.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JohnnyHarley232_0-1641336271726.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/30778i6D1477EE99EEBBD2/image-size/medium?v=v2&px=400" role="button" title="JohnnyHarley232_0-1641336271726.png" alt="JohnnyHarley232_0-1641336271726.png" /></span></P><P> </P><P> </P><P>I currently have the following arcade code, modeling as a template from this presentation <A href="https://www.esri.com/arcgis-blog/products/ops-dashboard/analytics/enhancing-dashboard-elements-using-data-expressions-part-1/" target="_self">https://www.esri.com/arcgis-blog/products/ops-dashboard/analytics/enhancing-dashboard-elements-using-data-expressions-part-1/</A> </P><LI-CODE lang="markdown">var portal = Portal("https://planetscapeai.maps.arcgis.com/"); var alerts = GroupBy( FeatureSetByPortalItem(portal,"9b11dda1c0804f13a72136a8bf71b93c",0,["*"],false), ["Date"], [ { name: "Alerts1" ,expression: "FID", statistic:"COUNT" } ] ); var imagery = GroupBy( FeatureSetByPortalItem(portal,"d70d948dd59c451bb56cc12a8f7aeb96",0,["*"],false), ["Date"], [ { name: "Alerts2" ,expression: "FID", statistic:"COUNT" } ] ); var survey = GroupBy( FeatureSetByPortalItem(portal,"f18f6b7a0447412083228d6ce554f042",0,["*"],false), ["CreationDate"], [{ name: "Alerts3", expression: "objectid", statistic: "COUNT" }] ); var combinedDict = { fields: [ { name: "Type", type: "esriFieldTypeString" }, { name: "CompletedDate", type: "esriFieldTypeDate" }, { name: "NumberOfAlerts", type: "esriFieldTypeInteger" }, ], geometryType: "", features: [], }; var i = 0; // Loop through each FeatureSet and store its attributes for (var m in alerts) { combinedDict.features[i++] = { attributes: { Type: "Alerts", CompletedDate: m["Date"], NumberOfAlerts: m["Alerts1"], }, }; } for (var p in imagery) { combinedDict.features[i++] = { attributes: { Type: "Imagery", CompletedDate: p["Date"], NumberOfAlerts: p["Alerts2"], }, }; } for (var j in survey) { combinedDict.features[i++] = { attributes: { Type: "Survey", CompletedDate: j["CreationDate"], NumberOfAlerts: j["Alerts3"], }, }; } // Return dictionary cast as a FeatureSet return FeatureSet(Text(combinedDict)); </LI-CODE><P> </P> Tue, 04 Jan 2022 22:38:05 GMT JohnnyHarley232 2022-01-04T22:38:05Z Creating a Temp Feature Set for Stacked Serial Chart https://community.esri.com/t5/arcgis-dashboards-questions/creating-a-temp-feature-set-for-stacked-serial/m-p/1130624#M5625 <P>I want to stack three different layers and group them by their own date field. For some reason, my Arcade code is working but no data is showing in the data table below. I am assuming this is a small tweak to the code but wasnt sure.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JohnnyHarley232_0-1641336271726.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/30778i6D1477EE99EEBBD2/image-size/medium?v=v2&px=400" role="button" title="JohnnyHarley232_0-1641336271726.png" alt="JohnnyHarley232_0-1641336271726.png" /></span></P><P> </P><P> </P><P>I currently have the following arcade code, modeling as a template from this presentation <A href="https://www.esri.com/arcgis-blog/products/ops-dashboard/analytics/enhancing-dashboard-elements-using-data-expressions-part-1/" target="_self">https://www.esri.com/arcgis-blog/products/ops-dashboard/analytics/enhancing-dashboard-elements-using-data-expressions-part-1/</A> </P><LI-CODE lang="markdown">var portal = Portal("https://planetscapeai.maps.arcgis.com/"); var alerts = GroupBy( FeatureSetByPortalItem(portal,"9b11dda1c0804f13a72136a8bf71b93c",0,["*"],false), ["Date"], [ { name: "Alerts1" ,expression: "FID", statistic:"COUNT" } ] ); var imagery = GroupBy( FeatureSetByPortalItem(portal,"d70d948dd59c451bb56cc12a8f7aeb96",0,["*"],false), ["Date"], [ { name: "Alerts2" ,expression: "FID", statistic:"COUNT" } ] ); var survey = GroupBy( FeatureSetByPortalItem(portal,"f18f6b7a0447412083228d6ce554f042",0,["*"],false), ["CreationDate"], [{ name: "Alerts3", expression: "objectid", statistic: "COUNT" }] ); var combinedDict = { fields: [ { name: "Type", type: "esriFieldTypeString" }, { name: "CompletedDate", type: "esriFieldTypeDate" }, { name: "NumberOfAlerts", type: "esriFieldTypeInteger" }, ], geometryType: "", features: [], }; var i = 0; // Loop through each FeatureSet and store its attributes for (var m in alerts) { combinedDict.features[i++] = { attributes: { Type: "Alerts", CompletedDate: m["Date"], NumberOfAlerts: m["Alerts1"], }, }; } for (var p in imagery) { combinedDict.features[i++] = { attributes: { Type: "Imagery", CompletedDate: p["Date"], NumberOfAlerts: p["Alerts2"], }, }; } for (var j in survey) { combinedDict.features[i++] = { attributes: { Type: "Survey", CompletedDate: j["CreationDate"], NumberOfAlerts: j["Alerts3"], }, }; } // Return dictionary cast as a FeatureSet return FeatureSet(Text(combinedDict)); </LI-CODE><P> </P> Tue, 04 Jan 2022 22:38:05 GMT https://community.esri.com/t5/arcgis-dashboards-questions/creating-a-temp-feature-set-for-stacked-serial/m-p/1130624#M5625 JohnnyHarley232 2022-01-04T22:38:05Z