Hi, I have an attribute table that has a column for rivers, each river has many rows and each row is related to a specific year. I have another column for values, each value is related to a river and its rows. What I need to do is group the river and its rows together and calculate the average value for each river. Then using the symbology feature create 5 categories for the rivers using natural breaks. Finally I need to rank each river based on the natural breaks categories.
I am able to perform each of these tasks but on a manual basis. Such as highlighting each river and rows, and using the statistics feature document in a newly created column the average for that river. I can do the same with the ranking by adding a new column and manually entering a rank based on the results of the symbology.
What I am wondering is if there is a simpler way to do this.