AnsweredAssumed Answered

Symbology based on seperate Table/Layer

Question asked by louiszook on Feb 1, 2019

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.

Outcomes