https://community.esri.com/t5/arcgis-online-questions/display-highest-1100-features-based-on-field/m-p/1000830#M37327 <DIV>I need a map displaying the top 1100, top 1500 and top 2000 features based on a field.&nbsp;</DIV><DIV>I am not sure how to do this on AGOL.&nbsp;</DIV><DIV>&nbsp;</DIV> Wed, 18 Nov 2020 00:23:46 GMT RickeyFight 2020-11-18T00:23:46Z https://community.esri.com/t5/arcgis-online-questions/display-highest-1100-features-based-on-field/m-p/1000830#M37327 <DIV>I need a map displaying the top 1100, top 1500 and top 2000 features based on a field.&nbsp;</DIV><DIV>I am not sure how to do this on AGOL.&nbsp;</DIV><DIV>&nbsp;</DIV> Wed, 18 Nov 2020 00:23:46 GMT https://community.esri.com/t5/arcgis-online-questions/display-highest-1100-features-based-on-field/m-p/1000830#M37327 RickeyFight 2020-11-18T00:23:46Z https://community.esri.com/t5/arcgis-online-questions/display-highest-1100-features-based-on-field/m-p/1002384#M37406 <P>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 :<BR /><BR /></P><P>&nbsp;</P><LI-CODE lang="python">[field] IN (SELECT TOP 1100 [field] FROM [layer] order BY [field])</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>The problem now is that I want the order reversed. I want to pick the top. Is there a way to reverse the order?&nbsp;</P> Wed, 18 Nov 2020 00:25:08 GMT https://community.esri.com/t5/arcgis-online-questions/display-highest-1100-features-based-on-field/m-p/1002384#M37406 RickeyFight 2020-11-18T00:25:08Z