Symbology based on seperate Table/Layer

LouisZook — Sat, 02 Feb 2019 06:29:52 GMT

I was thinking of something a little to crazy before.. But now found if possible a easier and better way to do what I want.

So Idea.. see if you all can help me out with the expressions.

Feature Layer (MAIN DATA)

Lists Locations Visited

Columns:

Location

POC

Address

Comments

Second Feature Layer/Stand alone (Visits)

Columns:

Location

Visited Date

Ranking

I want the symbology for MAIN DATA feature layer to be based on two things

Size:

Based on how many times the Location shows up in the Visits Layer/Table

Color:

Based on total ranking of all visits for that location divided by the amount of times the location is in the visits layer/table.

Is there a way to write this expression and/or what not to make this work? Relate the table ? any ideas? really stumped and have tried things left and write to include maybe database and query from that ect.. but I think symbology expression i think would be the safest bet.

topic Symbology based on seperate Table/Layer in ArcGIS Pro Questions

Symbology based on seperate Table/Layer