Latest Contributions by KenBuja

You have a typo in line 21 ("iff" instead of "iif") var avg = iif(totalrows == 0, 0, Floor(total / totalrows)) ... View more

When posting code, please use the "Insert/edit code sample" button. It make it easier to read your code and refer to specific lines. There are a couple of things going on with your code. You have to convert the text to a valid date. Your current code will return a null. The Count function works on arrays, not values, which is what's throwing the error. You want to get the running total of differences and calculate the average outside the loop. You'll have to return a FeatureSet in a Data Expression for an Indicator. Most of these were covered in my reply to your previous post. Give this a try var portal_ = Portal("https://arcgis.com"); var fs = FeatureSetByPortalItem(portal_, "Item ID", 0, ["*"], false); function StringToDate(input) { var arr = Split(input, "/"); return Date(arr[2], arr[0] - 1, arr[1]); } var total; for (var f in fs) { var date_Applied = f["Applied_Date"]; var date_Issued = f["Issued_Date"]; var startDate = DateOnly(StringToDate(date_Applied)); var endDate = DateOnly(StringToDate(date_Issued)); var differences = DateDiff(startDate, endDate, "days"); total += Sum(differences); } var totalrows = Count(fs); var avg = iif(totalrows == 0, 0, Floor(total / totalrows)) return FeatureSet( { fields: [{ name: "Average", type: "esriFieldTypeInteger" }], features: [{ attributes: { Days: avg } }] } );   ... View more

It doesn't matter if you have the layer within a group layer. This works on a test I set up. var fs = FeatureSetByName($map, "USA Census States") var output = Within($feature,FS) return { type : 'text', text : first(output).STATE_NAME } Did you test the code on an actual feature in the Zoning District? Running the code in the editor will use the first feature in the FeatureSet, which may or may not give you a feature within the Zoning District layer. You can use a feature you know will work by filtering the parcel to a specific one. In my example, I can filter the earthquakes to a specific event to test it out. This code  var feat = First(Filter($layer, "id = 'mb90114598'")) var fs = FeatureSetByName($map, "USA Census States") var output = Within(feat,FS) return output return { type : 'text', text : first(output).STATE_NAME } returns this The code in your latest post fails because you're supplying an incorrect name for the FeatureSetByName function, which returns a null. When used in the WIthin function, it's being interpreted as a null feature in the Geometry Within function (which returns a boolean) instead of the FeatureSet Within function (which returns a FeatureSet)   ... View more

What is the actual text in the $feature.Introduction? ... View more

Chrome (140.0.7339.186) and Firefox (143.0.1) work, but Edge (140.0.3485.81) doesn't for me. ... View more

Here's one way to calculate the difference (this shows the number of days since the beginning of the year). Note that the month number in the Date function is 0-based (0 is January) function StringToDate(input) { var arrDate = Split(input, "/"); return Date(arrDate[2], arrDate[1] - 1, arrDate[0]); } var date1 = "01/01/2025"; var date2 = Text(Now(), "DD/MM/Y"); //gives today's date as dd/mm/yyyy Floor(DateDiff(StringToDate(date2), StringToDate(date1), "days")); If your goal is to put this number into an indicator, then you have to return a FeatureSet containing that number function StringToDate(input) { var arrDate = Split(input, "/"); return Date(arrDate[2], arrDate[1] - 1, arrDate[0]); } var date1 = "01/01/2025"; var date2 = Text(Now(), "DD/MM/Y"); //gives today's date as dd/mm/yyyy var days = Floor(DateDiff(StringToDate(date2), StringToDate(date1), "days")); return FeatureSet( { fields: [{ name: "Days", type: "esriFieldTypeInteger" }], features: [{ attributes: { Days: days } }] } );   ... View more

First, check all the field names. I may have overlooked changing one back to your schema. Click the Run button in the Arcade editor to see if it's returning a FeatureSet. Add some Console messages to see what the code is doing a various intervals. This should help you figure out what's going wrong. ... View more

Me too ... View more

It looks like it's selective. I still get the error. ... View more