I have an attribute table containing "Joint_Count" and Raster ID (A1, A2, etc), where Join_Count refers to the sum of points per raster ID.
If the sum of all Join_Count represents 100%, how do I retrieve the threshold values to represent 20% and 30% of all values?
FID Shape Join_Count Y_Index X_Index 0 Polygon 0 A 1 1 Polygon 1 A 2 2 Polygon 2 A 3 3 Polygon 3 A 4 4 Polygon 4 A 5 5 Polygon 5 A 5 6 Polygon 6 A 5 7 Polygon 7 A 5 8 Polygon 8 A 5 9 Polygon 9 A 5 10 Polygon 10 A 5 The sum of all Join_Count is 55, corresponding to 100%.
20% and 30% of all valus are:
55*0.2 = 11 and 55*0.3 = 16.5. Next all Join_Count cells with a sum < 11 ( 16 (>30%) red.
In the above example, this corresponds to Join_Count values < 4 (5 (>30%).
Any suggestions how this can be done? I'm using ArcGIS 10.3.
I tried to add a new field and run cumsum(!Joint_Count!) in a first step, but I get an unknown error. Also searched through StackExchange, but couldn't find the solution.
أكثر...
If the sum of all Join_Count represents 100%, how do I retrieve the threshold values to represent 20% and 30% of all values?
FID Shape Join_Count Y_Index X_Index 0 Polygon 0 A 1 1 Polygon 1 A 2 2 Polygon 2 A 3 3 Polygon 3 A 4 4 Polygon 4 A 5 5 Polygon 5 A 5 6 Polygon 6 A 5 7 Polygon 7 A 5 8 Polygon 8 A 5 9 Polygon 9 A 5 10 Polygon 10 A 5 The sum of all Join_Count is 55, corresponding to 100%.
20% and 30% of all valus are:
55*0.2 = 11 and 55*0.3 = 16.5. Next all Join_Count cells with a sum < 11 ( 16 (>30%) red.
In the above example, this corresponds to Join_Count values < 4 (5 (>30%).
Any suggestions how this can be done? I'm using ArcGIS 10.3.
I tried to add a new field and run cumsum(!Joint_Count!) in a first step, but I get an unknown error. Also searched through StackExchange, but couldn't find the solution.
أكثر...