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.