Latest Contributions by KenBuja

The variable substitution sqlExpression in line 39 is not correct. You'd have to do something like this var globalId = p.globalid var related = Filter(comments, "projectguid = @globalId");   ... View more

You can add an Arcade Element to your popup with this code. It loops through each field in the feature and returns only the fields that contain a value. This also includes a variable (exceptedFields) that contains fields you don't want to show in the field list. Note that those field names are case sensitive. Expects($feature, "*"); var fields = Schema($feature).fields; var attributes = {}; var fieldInfos = []; var exceptedFields = ["OBJECTID", "GlobalID"]; //case sensitive! for (var f of fields) { if (!Includes(exceptedFields, f.name)) { if (Trim($feature[f.name]) != "") { attributes[f.alias] = $feature[f.name]; Push(fieldInfos, { fieldName: f.alias }); } } } return { type: "fields", fieldInfos: fieldInfos, attributes: attributes };   ... View more

It seems like there are some incompatibilities with the latest version of Firefox and Esri's products https://community.esri.com/t5/community-feedback/map-viewer-issues-when-using-firefox-version-145-0/m-p/1665688#M6016 https://community.esri.com/t5/arcgis-enterprise-portal-questions/issue-with-layer-widget-display-in-experience/m-p/1665001 ... View more

In the Indicator tab, turn off the Unit prefix option ... View more

OK, this should give you what you're trying to do, but I haven't tested it. It loops through each tract, gets the intersecting lakes for that tract, then gets the intersecting area for each lake. Then it gets the total lake count. Note that the area is rounded to two decimal places. It will take a while to process. You could test whether "Memorizing" the tracts and lakes layers makes it any faster. var port = Portal("https://www.arcgis.com"); // Load layers var tracts = FeatureSetByPortalItem(port, "b9fcbedac0384e32bc3dba6aec1a8cf6", 0); var lakes = FeatureSetByPortalItem(port, "5564b2e702364aefba08df8c95216a1f", 0, ["OrgKeyID"]); var lakesfilt = Filter(lakes, "OrgKeyID > 0"); var totalAcres = 0; var arrTracts = []; for (var tract in tracts) { var intersectingLakes = Intersects(lakesfilt, tract); Push(arrTracts, tract); for (var intersectingLake in intersectingLakes) { var lakePart = Intersection(tract, intersectingLake); totalAcres += Area(lakePart, "acres"); } } var lakeCount = Count(Intersects(lakesfilt, Union(arrTracts))) return FeatureSet( { fields: [ { name: "LakeCount", type: "esriFieldTypeInteger" }, { name: "Acres", type: "esriFieldTypeDouble" } ], features: [ { attributes: { LakeCount: lakeCount, Acres: Round(totalAcres, 2) } } ] } );   ... View more

You have the order of the DateDiff parameters reversed if the ExpDate is in the future. For those dates, your expression returns a negative number. Here's an easier way to write your expression, using the When function. This assumes that the ExpDate field is a date field. if (IsEmpty($feature.Expdate) return "Expiry Date Unavailable" var diff = DateDiff($feature.Expdate, Now(), "days"); When(diff <= 0, "Expired", diff <= 30, "Expires within 30 days", diff < 100, "Expires between 30 to 100 days", "Expires in more than 100 days" );   ... View more