Joined /Added fields not showing up in advanced symbology

Question

I am currently dealing with an issue where my joined fields (GAS, OIL_COAL_COKE, OTHER_NO) show up in the attribute table, but they do not show up in the fields for graduated colors.

Info about the joined/added fields:

GAS = UTIL_GAS + TANK_LP_GAS

OIL_COAL_COKE = OIL_KEROSENE + COAL_COKE

OTHER_NO = OTHER + NO_FUEL

While the joined fields do not appear in the dropdown menu for field under graduated colors for advanced symbology, the original individual fields do (UTIL_GAS, TANK_LP_GAS, OIL_KEROSENE, COAL_COKE, OTHER, NO_FUEL)

missing joined fields .jpg

Screenshot 2024-08-09 141245.png

AnnaSloan · Answer

Nevermind. I just tried adding a "+" in between them and that worked. For anyone else wondering it would look like this - "Number($feature.UTIL_GAS+$feature.TANK_LP_GAS)"

AnnaSloan · Answer

Hi,

I am having the same issue as OP. I was wondering what would the expression look like if we were to add multiple fields into one new numeric field. For example, I need to add the text fields UTIL_GAS and TANK_LP_GAS into the new numeric field "GAS," but every time I try to add them the way you showed previously, it says there is an error. Thanks!

JA7 · Answer

Your GAS, OIL_COAL_COKE, and OTHER_NO fields are text and not numbers. Looking at your screenshot they are all left justified, while numeric fields are right justified. Graduated colors will only work with numeric values.

You will need to add 3 additional number fields to your data. Then calculate the field (right-click on the field header and select calculate field) using Arcade to transform the appropriate value to a number. Do this for each of your three fields. You will then be able to use the graduated colors symbology on these new fields.