Latest Contributions by KenBuja

If they both have the unique ID in the field BUILDINGKEY, then line 5 should be var destinationRow = first(Filter(fs, "BUILDINGKEY = @ID"));   ... View more

Take a look at the Reusing Pro Commands documentation page ... View more

There's a GitHub site that contains many different types of data expressions for Dashboard, including one showing how to combine different dataset. 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. 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);     ... View more

There were a couple problems with your code. In lines 13-15, you have the values in an array. You should push the feat into the array inside the for loop (switch lines 18 and 19). The correct field type for strings is esriFieldTypeString in line 24. This should work // get beds data by shelter var cabq_agol = Portal("https://cabq.maps.arcgis.com/"); var fs_shelters = FeatureSetByPortalItem(cabq_agol, '4ebc62fe425c42ad909b1f30029ded55',['*']); var sh_feats = []; var feat; for (var shelter in fs_shelters) { var bed_tot = Sum(shelter['female_total'],shelter['male_total'],shelter['couples_total'],shelter['family_total'], shelter['youth_total'], shelter['open_mf_total']) var bed_occ = Sum(shelter['female_occupied'],shelter['male_occupied'],shelter['couples_occupied'],shelter['family_occupied'], shelter['youth_occupied'], shelter['open_mf_occupied']) var avail_bed = bed_tot - bed_occ feat = { 'attributes': { 'sh_name':shelter['name'], 'bed_tot':bed_tot, 'bed_occ':bed_occ, 'avail_bed':avail_bed } } Push(sh_feats, feat) } Console(sh_feats)//this returns a correct array of values // corrected the issue with the brackets i was seeing initially by adding in a closing single quote ( ' ),that was left off after esriFieldTypeInteger var shelterDict = { 'fields': [{'name':'sh_name','type':'esriFieldTypeString'}, {'name':'bed_tot','type':'esriFieldTypeInteger'}, {'name':'bed_occ','type':'esriFieldTypeInteger'}, {'name':'avail_bed','type':'esriFieldTypeInteger'}], 'geometryType':'', 'features':sh_feats }; return FeatureSet(shelterDict); // this gives me a 'Test execution error: Unknown Error. Verify test data.' warning so something isn't getting working ... View more

That is based off the title you've set in the popup configuration in the web map. Change this to use the point's name field. ... View more

You were missing a comma and a close parenthesis on lines 4 and 12 FeatureSetByPortalItem(agol,'****************************',15,['*'],false), ... View more