Update Arcade Profiles to include Visualization (symbology) based off related records
Please allow Arcade visualization profile to incorporate feature set functionality!
I am working with a parcel base. Within that parcel base I have a related table of single check fire services. Some parcels have just 1 related service record, others have upwards of 10. Field staff go into the field using Survey123 to check these services and update the attributes for that related record. This means that with every parcel, there can be updated data AND non-updated data within the related records. I.e. the field crew can go to a parcel, check 2 services one day, but not check the other 3 related records until the next day.
I'd like to symbolize the parcels by the status of "Assessment Complete", "Partially Assessed", and "Not Assessed" from the related records. These values are created using an updated field in the related records table with a simple Arcade expression:
var relate = FeatureSetByRelationshipName($feature, "To_Table", ['Assessed'], false) //get related records
var cnt = Count(relate) //count related records
var val = Find("Yes", relate,0) //find all related records where Assessments have been performed
// if no records have been assessed, return Not Assessed. If all records have been assessed, return Completely Assessed, and if there are some yesses, return Partially Assessed
if (val < 0){
return "Not Assessed"
}
else if (val == cnt){
return "Completely Assessed"
}
else if (val > 0){
return "Partially Assessed"
}
To my extreme surprise, this functionality is not available in AGOL nor enterprise. In AGOL, I get the returned expression accurately tested when run, however I have no way to save and apply the expression, as there is still an error stating that the FeatureSetByRelationshipName is not defined, even though it tested correctly. The "Done" button in the bottom right of the expression window is greyed out.
In Portal, I simply get the ! that it's not available.
After some digging, I found some interesting information explaining that Arcade's visualization profile does not support feature set functionality. So I am, as my grandmother would say, 'writing a lettahhh' to those who would listen. Please upvote this idea if you can see yourself utilizing this kind of functionality, as this would be fantastic to have!
