Need help with Arcade expression for symbolizing room vacancy

JDenham

I'm working on a sleeping room web application, and I need help creating a symbology expression to draw attention to rooms with vacant beds available.  My data is polygon data, representing the individual rooms.  I'm planning to use the stock "capacity" field to note how many beds each sleeping room has.    I then have 4 occupant fields (occupant_1, occupant_2 etc.). 

I need an expression that will compare the quantity of non-Null occupant fields with the value in the 'capacity' field.  I'd would like to be able to symbolize the output with Gray for Capacity = 0, Green for Vacancy (the number of non-Null occupant fields is less than 'capacity' value), and Red for Full (number of non-Null occupant fields is equal to 'capacity' value).

I am not familiar with how to assemble Arcade expressions, so any help would be much appreciated.

*Edit to add-  I own the data table, so if it is best to use an arcade expression to calculate a new field as an intermediate before symbolizing, that is a possibility as well.

kenbuja

Give this a try. This loops through the array of field names to count how many aren't empty. Then it returns the result of the When function, which checks if the capacity is empty and if the capacity is greater than the number of occupants or not. And it's good practice to use the Expects function when getting fields from an array like this.

Expects($feature,'capacity', 'occupant_1', 'occupant_2', 'occupant_3', 'occupant_4');
var fields = ['occupant_1', 'occupant_2', 'occupant_3', 'occupant_4'];
var occupants = 0

for(var index in fields) {
  if (!IsEmpty($feature[fields[index]])) occupants += 1;
}

return when ($feature.capacity == 0, 'Gray',
             $feature.capacity > occupants, 'Green',
             'Red');