Latest Contributions by KenBuja

This expression will filter out the records from the current year. The original dataset has 493721 records, with 2550 records for 2025 var fs = FeatureSetByPortalItem( Portal("https://www.arcgis.com"), "79461a1ec0974301bde274177c7108bd", //a layer from the Living Atlas to test 0, ["place", "mag", "time"], false ); return Filter(fs, `EXTRACT(YEAR from time) = ${Year(Now())}`); //time is the Date field Then, in the Indicator, use the Statistic value type and Count. ... View more

You can insert calculated values into new fields easily. I've just added lines 16, 23, 44, and 56. You also don't need all the null assignment in the registry loop. If they're not assigned, they will be set to null automatically. // Set portal var portal = Portal("https://arcgis.com/"); // Create featureset from registry (include all fields) var unfilteredregistry = FeatureSetByPortalItem(portal, '', , ['*'], false); // Filter registry to only include rows where "Batch_Number" is not null var registry = Filter(unfilteredregistry, "Batch_Number IS NOT NULL"); // Create featureset from batch submission (include all fields) var batchsubmission = FeatureSetByPortalItem(portal, '', 0, ['*'], false); // Initialise empty feature array var features = []; var feat; var batchCount = count(registry); // Iterate through batch submission for (var b in batchsubmission) { feat = { attributes: { OBJECTID: b["objectid"], Batch_Number: b["batch_number"], // <- map lowercase field to consistent name Batch_Count: batchCount, Batch_Submission_Date: b["date_of_batch_submission_for_si"], Site_Assessment_Complete: b["date_of_site_assessment_complet"], Batch_Review_Priority: b["BatchReviewPriority"], Registry_Acquisition_St: b["RegistryAcquisitionStart"], Registry_Acquisition_Co: b["RegistryAcquisitionComplete"], Batch_Acquirer: b["BatchAcquirer"], Elapsed_Time: b["RegistryAcquisitionElapsedTim"], Registry_Acquisition_Status: b["Registry_Acquisition_Status"], Site_Assessment_Status: b["Site_Assessment_Status"] } }; Push(features, feat); } // Iterate through registry for (var r in registry) { feat = { attributes: { OBJECTID: r["OBJECTID"], Batch_Number: r["Batch_Number"], Batch_Count: batchCount } }; Push(features, feat); } // Create structured dictionary for Featureset var combinedDict = { fields: [ { name: "OBJECTID", type: "esriFieldTypeObjectID"}, { name: "Batch_Number", type: "esriFieldTypeString" }, { name: "Batch_Count", type: "esriFieldTypeInteger" }, { name: "Batch_Submission_Date", type: "esriFieldTypeDate" }, { name: "Site_Assessment_Complete_Date", type: "esriFieldTypeDate" }, { name: "Batch_Review_Priority", type: "esriFieldTypeString" }, { name: "Registry_Acquisition_Start", type: "esriFieldTypeDate" }, { name: "Registry_Acquisition_Complete", type: "esriFieldTypeDate" }, { name: "Batch_Acquirer", type: "esriFieldTypeString" }, { name: "Elapsed_Time", type: "esriFieldTypeInteger" }, { name: "Registry_Acquisition_Status", type: "esriFieldTypeString" }, { name: "Site_Assessment_Status", type: "esriFieldTypeString" } ], geometryType: "", features: features }; // Return combined feature set return FeatureSet(combinedDict);   ... View more

When using '${}' syntax, you have to use a back tick instead of a regular quote. This is called a template literal  Push(result, `${type} ---- ${Round(p, 2)}% or ${Round(a, 2)} acres`) ... View more

The Point of Interest markers use preset colors, so you'll have a limited choice in colors. You can use the Pins markers under the Vector Symbols to give you more control over color, transparency, etc. If you want that exact pin shape, you can use the Animated shape but turn off the animation.   ... View more

I didn't include all the lines of the code in my reply, only the ones that were changed. You didn't return the dictionary as a FeatureSet at the end of the code. // Return dictionary cast as a feature set return FeatureSet(joinedDict); One other thing. I forgot to switch the FeatureSet to be Memorized var plots = FeatureSetByPortalItem(portal, "xyz", 0, ["*"], false); var grades = Memorize(FeatureSetByPortalItem(portal, "xyz", 0, ["*"], false));   ... View more

It sounds like you just need to reverse the logic for (var p in plots) { var tableID = p["UCode"]; var feat = { attributes: { UCode: tableID, Vineyard_Name: p["Vineyard_Name"], BlockCode: null, FinalGrade: null, SelectedEURs: null, last_name: null } }; for (var g in Filter(grades, "BlockCode = @tableID")) { feat.attributes.BlockCode = g["BlockCode"]; feat.attributes.FinalGrade = g["FinalGrade"]; feat.attributes.SelectedEURs = g["SelectedEURs"]; feat.attributes.last_name = g["last_name"]; } Push(features, feat); } var joinedDict = { fields: [ { name: "UCode", type: "esriFieldTypeString" }, { name: "Vineyard_Name", type: "esriFieldTypeString" }, { name: "BlockCode", type: "esriFieldTypeString" }, { name: "FinalGrade", type: "esriFieldTypeString" }, { name: "SelectedEURs", type: "esriFieldTypeString" }, { name: "last_name", type: "esriFieldTypeString" } ], geometryType: "", features: features };   ... View more

The first When statement is missing the DefaultValue When( $feature.status == 'action', 'Action Stage', $feature.status == 'minor', 'Minor Flood Stage', $feature.status == 'moderate', 'Moderate Flood Stage', $feature.status == 'major', 'Major Flood Stage', 'N/A') ... View more

Here's one way to do it. This uses a function to return the color, which can be used in multiple columns. This shows how it can be used to change the textColor and the backgroundColor attributes. function setColor(value) { When( value < 20, "#dedede", value < 30, "#C1C1C1", value < 60, "#D18E8E", "#f00000" ); } return { cells: { //Other cells "First Choice": { displayText: Text($datapoint["First Choice"]), textColor: setColor($datapoint["First Choice"]), //backgroundColor: setColor($datapoint["First Choice"]), textAlign: "right", iconName: "", iconAlign: "", iconColor: "", iconOutlineColor: "" }, "Second Choice": { displayText: Text($datapoint["Second Choice"]), textColor: "", backgroundColor: setColor($datapoint["Second Choice"]), textAlign: "right", iconName: "", iconAlign: "", iconColor: "", iconOutlineColor: "" }, // More cells } };   ... View more