Sizing Symbology Based on repeated entries

[NathanMichalewicz]

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

[NathanMichalewicz]

Also, I have tried using the cluster tool, but it does not work for my instance for two reasons: 1) I cannot get the clusters to change with the time scale, and change over time is very important on this project; 2) I have important data points (places) in close proximity to one another that get combined into a single cluster, eliding some of my data. 

[NathanMichalewicz]

I input my data into ArcGIS online hoping to find another way to do what I want, and I think I have screenshots to explain what I want to do. Below is the data in ArcGIS Online. 

 As you can see, when I change the style of the feature to place, it counts the number of instances for each place. 

 I simply want to make the symbols sized in a graduated way based on that number. I want to do this in ArcGIS pro rather than online (mainly because online is not recognizing the temporal aspects of my data and I have better luck with this in ArcGIS Pro), but I will use whichever platform is ideal. I assume there must be an arcade formula to use in the symbology section, I just have no clue what it might be. Please help. 

Thanks,

Nate

 

[XanderBakker]

Hi @NathanMichalewicz ,

You probably have to aggregate the data (on Place, sum the Duration and average the Lat and Long coords) and visualize the resulting table (display XY events) using the coordinates in the table.