jeremytibbetts

Min and Max values in an attribute table

Discussion created by jeremytibbetts on Jan 27, 2012
Latest reply on Jan 30, 2012 by curtvprice
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

Outcomes