AnsweredAssumed Answered

Select the top 20% of records.

Question asked by dafiter Champion on Dec 22, 2014
Latest reply on Dec 23, 2014 by rfairhur24

I have converted a raster into points. I have then clipped the raster with my buildings layer.

All buildings have a unique id and all the points in the same building have that id.   (ex. in the image 65379 is the unique id for that building)

 

What I want to do is select the top 20% of points based on an attribute value for each building. Another issue is that the number of points per building changes based on the area.

I know how many points are in each building.

 

I am thinking I need a for each statement but I am not sure.

Capture.PNGCapture.PNG

 

Any help is greatly appreciated.

Outcomes