Grouping for each Red Dot

[Anish123]

So as seen above, each red dot has a number of years attached to it. Some of them have 2, others have like 10. My problem is that I want to make the data concise but I am unsure about how. Essentially, I would like it such that each dot has a year and a count (ex. a dot with 2020, 2020, 2020, 2021, 2019 would be 2019 (1), 2020 (3), 2021 (3)). Would it be possible to do something like this for each dot? Currently, all I have is the workflow counting the total times the year shows up in all dots rather than each dot.

Sample of what my workflow looks like

[csmith11 · Accepted solution]

It sounds like you just need to concatenate the string together. The Year and the Count amount. Then Group by the DotID and Concatenate the "Year and the Counts" Together into a single string.

[csmith11]

If your data is all in a single spatial field, consider using the poly split tool to parse them out into separate rows before using the example I shared.

If you could provide any data samples of what you are working with, I'll be able to help more.

[Anish123]

Hello csmith11. Your solution is giving me exactly what I wanted. Thank you!

Out of curiosity, wdym by a single spatial field? And how would that affect the output?

[csmith11]

Glad to hear that! Mind marking it as the solution so other users can quickly identify it as such?

Once you put it all into a map tools I imagine it would just show every dot on the map same as before.

[Anish123]

Thanks for reminding me, just did it. 

I did want every dot on the map, just without all the clutter of having a label for every single event that occured. Each dot is an event with its own sub-events (represented by year subevent took place). It's a bit hard to see but there are dots layered upon dots. I just wanted to erase the 10+ labels per dot and reduce it to 3 or so, which your solution resolved. If that explanation makes sense (?)

As you can see, instead of having 30+ labels on the map, it's been organized neatly into groups of year.

[csmith11]

Incredible! Awesome to see the solution implemented. Thanks for sharing!