Grouping for each Red Dot

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

Reporting

Spatial Analysis

Accepted answers

csmith11

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.

Year Count.yxmd

All comments

csmith11

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.

Year Count.yxmd

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?

Quick Links

This months top contributors

mceleavey 382

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262