This seems like a pretty straight forward question, but I can't seem to find the answer online so I am hoping someone can help me.
1) I have a field in an attribute table, lets call it Index_values and I would like to find the range of values within that field.
My plan was to use the min() and max() function, giving me the lowest and highest value.
2) Then I would like to break this range up into 5 equal categories.
How I was going to do this was max - min, then divide that by 5
example max = 12, min = 2
12 - 2/5 = 2
Then I would add 2, to the min value and go up from there...
Therefore, that categories would be:
2-4
4-6
6-8
8-10
10-12
However, my problem is, I cannot get the min/max function to look through the Index_value field within that table.
Is there something I am missing, or an easier way to find the range and divide that range into categories?
Thanks!
Jeremy