I did a one to many spatial join and ended up with an attribute table as follows: Lets say we have 5 different IDs that have numerical values in 500 rows. I need to sum the values for each ID, and end up with 5 rows of data containing the ID and the total of all values that had that ID. Is group by the right tool for this? If so, how exactly do I use it?
Please note that these numbers are simplified and the actual number of rows is much larger.