Latest Contributions by KenBuja

Hooray! Batch editing is here! ... View more

Good use of the Case statement in the GroupBy function. I always overlook that as a possible solution. I believe you'll still have to loop through the grouped Featureset to calculate the percentage.  var investigated = "CASE WHEN Status = 'Investigated' THEN 1 ELSE 0 END"; var pending = "CASE WHEN Status = 'Pending' THEN 1 ELSE 0 END"; var grouped = Groupby( fs, ["Person"], [ { name: "Total", expression: "Status", statistic: "COUNT" }, { name: "Investigated", expression: investigated, statistic: "SUM" }, { name: "Pending", expression: pending, statistic: "SUM" } ] ); var fields = Schema(grouped).fields; Push(fields, { name: "Percentage", type: "esriFieldTypeDouble" }); var features = []; for (var g in grouped) { push( features, { attributes: { Total: g.Total, Investigated: g.Investigated, Pending: g.Pending, Percentage: Round(g.Investigated / g.Total * 100) } } ); } return FeatureSet({ fields: fields, features: features }); ... View more

Use Javascript, since Arcade is based on that language. ... View more

That code should work perfectly fine. It works in the Playground with some testing data. You should look at one of the attributes in the related_data object to see if it changes (line 8 ) Console(feat.OBJECTID) ... View more

Here's one way to do that. I used a dummy dataset to test it out, so substitute your actual dataset. var fs = FeatureSet( { fields: [ { alias: "Person", name: "Person", type: "esriFieldTypeString" }, { alias: "Status", name: "Status", type: "esriFieldTypeString" } ], features: [ { attributes: { Person: "Person 1", Status: "Investigated" } }, { attributes: { Person: "Person 1", Status: "Investigated" } }, { attributes: { Person: "Person 1", Status: "Pending" } }, { attributes: { Person: "Person 1", Status: "Investigated" } }, { attributes: { Person: "Person 2", Status: "Investigated" } }, { attributes: { Person: "Person 2", Status: "Pending" } }, { attributes: { Person: "Person 2", Status: "Pending" } }, { attributes: { Person: "Person 2", Status: "Pending" } }, { attributes: { Person: "Person 2", Status: "Investigated" } }, { attributes: { Person: "Person 2", Status: "Investigated" } }, { attributes: { Person: "Person 3", Status: "Investigated" } }, { attributes: { Person: "Person 3", Status: "Investigated" } }, { attributes: { Person: "Person 3", Status: "Pending" } } ] } ); var statuses = ["Investigated", "Pending"]; var people = GroupBy(fs, "Person", { name: "Total", expression: "1", statistic: "Count" }); var peopleandstats = GroupBy(fs, ["Person", "Status"], { name: "Total", expression: "1", statistic: "Count" }); var features = []; for (var p of people) { var person = p.Person; var attr = {}; attr["Person"] = person; for (var status of statuses) { var s = First(Filter(peopleandstats, "Person = @person AND Status = @status")); attr[status] = s.Total; if (status == "Investigated") attr["Percentage"] = Round(s.Total / p.Total * 100, 0); } attr["Total"] = p.Total; Push(features, { attributes: attr }); } var fields = [ { name: "Person", type: "esriFieldTypeString" }, { name: "Investigated", type: "esriFieldTypeInteger" }, { name: "Pending", type: "esriFieldTypeInteger" }, { name: "Total", type: "esriFieldTypeInteger" }, { name: "Percentage", type: "esriFieldTypeInteger" } ]; return FeatureSet({ fields: fields, features: features }); which returns this table   ... View more

Are the values Null, an empty string (""), or a space (" ")? ... View more

Your links goes to this discussion thread ... View more

You just need to convert day to a Text string to use it in the HasKey function (line 19). Note that your original line was "Weekday(dateVal) - 1", which is incorrect. The Weekday function returns the day using values ranging from 0 (Sunday) to 6 (Saturday). This also only counts that incidents that are outside the hours of 9 am and 5 pm (line 18) var portal = Portal("https://www.arcgis.com/"); var fs = Top( FeatureSetByPortalItem( portal, "b7a7144cda9046a5bfc6b36fa88e0477", 0, ["DateTime"], false ), 10 ); var dayCounts = { "0": 0, "1": 0, "2": 0, "3": 0, "4": 0, "5": 0, "6": 0 }; for (var f in fs) { var dateVal = f["DateTime"]; if (!IsEmpty(dateVal)) { if (Hour(dateVal) < 9 || Hour(dateVal) >= 17) { var day = Text(Weekday(dateVal)); if (HasKey(dayCounts, day)) { dayCounts[day] += 1; } } } } var outDict = { fields: [ { name: "Day", alias: "Day of Week", type: "esriFieldTypeInteger" }, { name: "Count", alias: "Incident Count", type: "esriFieldTypeInteger" } ], geometryType: "", features: [] }; // Add the results as features for (var k in dayCounts) { Push( outDict.features, { attributes: { Day: Number(k), Count: dayCounts[k] } } ); } return FeatureSet(Text(outDict)); ... View more

Here's one I use to concatenate fields. It uses GroupBy to get the required fields and counts, then creates a new featureset with the concatenated fields. My original dataset has the field Strat_Num, which is a unique combination of Habitat, Depth, Subregion, and Admin. I wanted to group by Stratum Number, concatenate the other values, and get their count. This is the code I came up with var fs = FeatureSetByPortalItem( Portal("https://www.arcgis.com/"), "itemId", 0 ); var grouped = GroupBy( fs, "Strat_Num", [ { name: "Habitat", expression: "Habitat", statistic: "Max" }, { name: "Depth", expression: "Depth", statistic: "Max" }, { name: "SUBREGION", expression: "SUBREGION", statistic: "Max" }, { name: "ADMIN", expression: "ADMIN", statistic: "Max" }, { name: "Count", expression: "1", statistic: "Count" } ] ); var features = []; for (var i of grouped) { Push( features, { attributes: { Number: i.Strat_num, Stratum: `${i.Habitat} ${i.Depth} ${i.SUBREGION} ${i.Admin}`, Count: i.Count } } ); } return FeatureSet( { fields: [ { name: "Number", type: "esriFieldTypeInteger" }, { name: "Stratum", type: "esriFieldTypeString" }, { name: "Count", type: "esriFieldTypeInteger" } ], features: features } ); which gives me this table     ... View more

Your logic works using this testing data, so I would use @ZenMasterZeke's suggestion to use Console (use the Run button to see the results in the Arcade window) to see what's not working // Replace with your actual Portal item IDs var fuelItemID = "774019f31f8549c39b5c72f149bbe74e"; // states var compItemID = "5f31109b46d541da86119bd4cf213848"; // zip codes // Access both layers var fuelLayer = FeatureSetByPortalItem(Portal("https://www.arcgis.com"), fuelItemID, 0, ["STATE_ABBR", "STATE_FIPS"],false); console(fuelLayer) var compLayer = FeatureSetByPortalItem(Portal("https://www.arcgis.com"), compItemID, 3, ["State", "POPULATION", "ZIP_CODE"],false); console(compLayer) // Array to store joined features var joinedFeatures = []; // Join loop for (var fuel in fuelLayer) { console(fuel["STATE_ABBR"]) var lid = fuel["STATE_ABBR"]; var match = First(Filter(compLayer, "State = @lid")); if (!IsEmpty(match)) { console(match["POPULATION"]) var attributes = { COMPNO: fuel["STATE_FIPS"], FUELLOADS: match["POPULATION"], Plantation: match["ZIP_CODE"] }; Push(joinedFeatures, { attributes: attributes }); } } // Define output FeatureSet schema var fields = [ { name: "COMPNO", type: "esriFieldTypeString" }, { name: "FUELLOADS", type: "esriFieldTypeInteger" }, { name: "Plantation", type: "esriFieldTypeString" }, { name: "District", type: "esriFieldTypeString" }, { name: "SuperDistrict", type: "esriFieldTypeString" } ]; // Return a proper FeatureSet return FeatureSet({ fields: fields, geometryType: "", features: joinedFeatures });   ... View more