Display highest 1100 features based on field

324
1
11-12-2020 11:01 AM
RickeyFight
MVP Regular Contributor
I need a map displaying the top 1100, top 1500 and top 2000 features based on a field. 
I am not sure how to do this on AGOL. 
 
Tags (2)
0 Kudos
1 Reply
RickeyFight
MVP Regular Contributor

At this point I am just trying to get it to work in arcgis pro. I was able to get the bottom 1100 scores using definition query SQL :

 

[field] IN (SELECT TOP 1100 [field] FROM [layer] order BY [field])

 

 

The problem now is that I want the order reversed. I want to pick the top. Is there a way to reverse the order? 

0 Kudos