I'm working with ArcGIS Pro to build a map that represents the presence of diplomats located abroad historically. I want to size the symbology based on repeated instances someone is present in a specific city. In other words, I want it to count each time someone is in London, for instance, and increase the size of the point accordingly. I tried count($feature.Place), but that only counts the number of individual places--not the number of people in each place. I tried to create a sum expression based on duration (each 1 references 1 year present there), but that got me nowhere. Perhaps the problem is how I'm constructing my data, or I do not know how to construct the right custom expression in arcade, using graduated symbols.
I attached a screenshot of my table in case it helps. The goal is to create a map that represents the total number of years diplomats were present in different places (so if 2 diplomats were present in London in the same year, each one would give a value of 1 for that year) over a specific period of time. I'm basically just trying to get ArcGIS to count each time a place is listed in the table and size the symbol relative to that number. The point is also for the representation to change over time with the time scale.
If you cannot tell, I'm new to this, so I really appreciate any help possible.
Many thanks in advance,
Nate
