topic Re: Arcade custom symbology in ArcGIS Online Questions

Arcade custom symbology

Ed_ — Fri, 08 Dec 2023 15:45:07 GMT

Based on the sample data how can I create a new column/variable, A&B, based on when certain conditions are met from two columns using Arcade and then assign colors to the new column's categorical values accordingly?

I am using Pro 3.1.

Sample data:

ID A B A&B 1 Present Present A Present & B Present 2 Absent Present A Absent & B Present 3 Present Absent A Present & B Absent 4 Absent Absent A Absent & B Absent 5 Present Present A Present & B Present 6 Absent Present A Absent & B Present 7 Present Absent A Present & B Absent 8 Absent Absent A Absent & B Absent

Color conditions:

If A Present & B Present then color red.
If A Absent & B Present or A Present & B Absent then color orange.
If A Absent & B Absent then color yellow.

Re: Arcade custom symbology

Ed_ — Fri, 08 Dec 2023 15:50:17 GMT

@KenBuja happy Friday, hope all is well, when you have the time, can you please have a look into this? Cheers!

Re: Arcade custom symbology

jcarlson — Fri, 08 Dec 2023 15:57:33 GMT

You don't necessarily need to calculate a whole new field for this, but you could. Whether you calculate the field or use this expression directly in the symbology settings, it is the same.

This is simple enough in Arcade. Note, however, that the expression won't directly set the color. Rather, it will return a value that your symbology settings will use for categories. You can call them 'red', 'orange', and 'yellow', but they may as well be 'a', 'b', and 'c' for all the different it makes. Colors are set separately from the expression.

Here are your color conditions in Arcade

return when( $feature.A == 'Present' && $feature.B == 'Present', 'red', ($feature.A == 'Absent' && $feature.B == 'Present') || ($feature.A == 'Present' && $feature.B == 'Absent'), 'orange', $feature.A == 'Absent' && $feature.B == 'Absent', 'yellow', 'other' )

However, you don't really need all this. Since it doesn't matter which value is absent/present, just the count, we can simplify matters.

// this will create a 2-item array of either True or False var present = [ $feature.A == 'Present', $feature.B == 'Present' ] return when( All(present), 'red', // matches when both are 'Present' Any(present), 'orange', // matches when either are 'Present', but only evaluates if the first check is false; in other words, when only 1 is 'Present' 'yellow' // logically anything else will be when both are 'Absent', so we don't actually need any conditions )

Re: Arcade custom symbology

KatClifton — Thu, 05 Sep 2024 17:58:53 GMT

@Ed_ and @jcarlson , hoping I can get some insight from you both on a similar issue.

I have a field named "Status" that has about six or seven values defined by a domain. I would like to categorize these values into a smaller number of values using Arcade and then use those three values for defining the symbology.

When I use the code on a field that does not have a domain applied, I use var reviewStatus = $feature.reviewstatus and it works fine.

However, when I attempt to use the code below on a field that DOES have domain applied, all items return as Complete. However, I can look in the data and see some values that are Needs Review or Pending.

Here's what I have:

var reviewStatus = DomainName($feature,"reviewstatus")

if (reviewStatus == "")
{
return "Needs Review"
}

if (IsEmpty(reviewStatus))
{
return "Needs Review"
}

if (reviewStatus == "Avoid")
{
return "Needs Review"
}

if (reviewStatus == "High Priority")
{
return "Needs Review"
}

if (reviewStatus == "In Progress")
{
return "Needs Review"
}

if (reviewStatus == "Needs Review")
{
return "Needs Review"
}

if (reviewStatus == "Pending")
{
return "Pending"
}

else
{
return "Complete"
}

Re: Arcade custom symbology

jcarlson — Thu, 05 Sep 2024 18:04:03 GMT

You need to check the values of the fields based on the domain code, not the domain name. I'm assuming the value "In Progress" might be stored as "in_progress" or something like that? You'd need to check if(reviewStatus == 'in_progress') if that's the case.

To check against the description itself, you need to use DomainName($feature, 'reviewStatus') to pull the text name.

Re: Arcade custom symbology

KatClifton — Thu, 05 Sep 2024 19:07:01 GMT

@jcarlson , thanks for your prompt reply! Just looked at the domain code, and I see that one of the values is truncated.

So, I will update my Arcade code to refer to the domain code (not the name) and update the Arcade to consider the truncated values in the code field.

Much appreciated!!!