Latest Contributions by KenBuja

The Intersects function takes a FeatureSet and a Feature. Even though targ_parcel contains only one Feature, it's still considered a FeatureSet. What you have to do is get the First item of that FeatureSet (line 3) to use in the Intersects function. // gets addresses that belong to a single parcel var fs_parcels = FeatureSetByName($map, "parcel layer", ['UPC','OWNER','OWNADD','SITUSADD']) var targ_parcel = First(Intersects(fs_parcels, $feature)) //target parcel from clicking on point of interest //console("returns " + Count(targ_parcel)+ " parcels")//gives me a count of 1, as expected var fs_addr_pts = FeatureSetByName($map, "addr_points",['GeoAddress'])//creates feature set of address points in map console("returns " + Count(fs_addr_pts))//returns 207,000 records found in featureset //the next setp fails and doesn't return any features var parcel_addrs = Intersects(fs_addr_pts, targ_parcel) Console("returns " + count(parcel_addrs) + " addresses")     ... View more

You have single quotes around "Internal_Status". Remove them and it should work. ... View more

This return statement will not give you the information you desire. The logical operator (&&) in the return can only return a true or false. In the if statement, you're checking whether the OBJECTID of the feature is 299. Since that is true, the conditions ($feature.OBJECTID==297) in the return will both be false. You also cannot use the logical operator with a statement that doesn't return a "True" or "False" (I'm assuming $feature.USER_C_UNI_VLAN_ID is the "VLAN ID" in your table). If I'm understanding what you're trying to do, you should add in two additional Arcade field elements to your popup for the other two records. The code would look something like this var feat = First(Filter($layer, "OBJECTID = 297")); return { type: "fields", title: `Record ${feat.OBJECTID}`, fieldInfos: [ { fieldName: "Service Type" }, { fieldName: "Service Medium" }, { fieldName: "VLAND ID" } ], attributes: { "Service Type": feat["Service_Type"], "Service Medium": feat["Service_Medium"], "VLAND ID": feat["USER_C_UNI_VLAN_ID"] } };       ... View more

There are a couple of things going on. The FeatureSet "x" from the first line doesn't contain a "count" field to sort in line 3. Use the "total" field in line 3 Even though DSC in line 3 works, officially you should use DESC The chartValue keys have to be strings, not numbers (although that doesn't seem to be documented anywhere). In my testing dataset, the Year field is numeric Give this a try var x = GroupBy($layer, 'Year', { name: 'total', expression: 'units', statistic: 'SUM' }); var sorted = OrderBy(x, 'total DESC') var chartValues = {} var chartNames = [] for(var f in sorted) { console(f.year) chartValues[`${f.year}`] = f.total Push(chartNames, f.year) }   ... View more

If your goal is to get the agency name for each feature rather than finding the ones that are "DDOT", then you should use this. When(Find('DDOT', $feature.groupNames) != -1, 'DDOT', Find('DPW', $feature.groupNames) != -1, 'DPW', Find("CFSA", $feature.groupNames) != -1, 'CFSA', // add all the other agency names you're looking for 'undefined')   ... View more

Is that field in a domain? If so, you'll need to use the domain code or the DomainName function var level = DomainName($datapoint, "level_of_impact"); var lOI = When( level == "Critical", "#e01d1d", level == "High", "#ff7300", level == "Medium", "#73b2ff", "#ecf229" ); ... View more

What you can do is use Arcade to return unique categories, which would look like this if (IsEmpty($feature.License_Expiration)) return 'No Expiration Date' var span = DateDiff(Date($feature.License_Expiration), Now(), 'days') When (span < 0, 'Expired', span < 120, 'Nearing expiration', 'Not expired') And you would then set the outline colors in the Styles dialog   ... View more

With some more testing, I found a way to get the result faster, using the GroupBy function. Give this a try var portalItem = "RanDOmP0rta1iDNUm85r"; var thisPortal = Portal("https://myserver.mydomain.com/portal"); var inspections = FeatureSetByPortalItem( thisPortal, portalItem, 58, ["InspectionId", "PrjStartDate", "ShopDescription", "DistrictDescription"] ); GroupBy( inspections, "OBJECTID", [ { name: "InspectionID", expression: "1", statistic: "MAX" }, { name: "ShopDescription", expression: "1", statistic: "MAX" }, { name: "District", expression: "DistrictDescription", statistic: "MAX" }, { name: "CycleYear", expression: "MOD(EXTRACT(YEAR FROM PrjStartDate), 5) + 1", statistic: "MAX" } ] );     ... View more

It's because you set the InspectionID field in the dictionary as an esriFieldTypeOID. In testing with my data, if I use an InspectionID field that has unique values, I get the correct number of records. If I use a field without unique records, it only returns the number of unique records. Changing the field type to esriFieldTypeInteger returns all the records, regardless of whether the value are unique or not.   var cycleYears = { 'fields': [{'name':'InspectionID', 'type': 'esriFieldTypeInteger'}, {'name':'ShopDescription', 'type': 'esriFieldTypeString'}, {'name':'District', 'type': 'esriFieldTypeString'}, {'name':'CycleYear','type': 'esriFieldTypeDouble'}], 'geometryType': '', 'features': [] }     ... View more

Line 10 should be return firstPoly.ABC; ... View more