I have a data set which has entities that (among other things) have a location. I am interested in counting the number of occurrences per location and put them on a map that I have created using a geographic adornment. To that end I created one note for each location and put the latitude and longitude into each of them. They nicely display on the map.
What I now want to do is to put the number of occurrences into the note on the geographic adornment?
I know I can do that via a display expression using some code magic, but In that last part I do not know how to proceed. Say my notes are in a container names “Notes” and the variable that gives the location is in “City”. How would I count the number of occurrences for each location when each note on the geographic adornment is named after a location?
I think that I should best do this via a rule which first calculates that count and puts it into a Display Attribute in each note. Then I could easily reference that for the display expression.
Any ideas how to proceed? I’d be most grateful for any pointers!