topic Re: Showing Most Recent and Unique Values in ArcGIS Web AppBuilder Questions https://community.esri.com/t5/arcgis-web-appbuilder-questions/showing-most-recent-and-unique-values/m-p/556546#M14761 <HTML><HEAD></HEAD><BODY><P>Anyone? <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span>&nbsp;</P></BODY></HTML> Tue, 26 Mar 2019 11:36:58 GMT Luiz_AmadeuCoutinho 2019-03-26T11:36:58Z Showing Most Recent and Unique Values https://community.esri.com/t5/arcgis-web-appbuilder-questions/showing-most-recent-and-unique-values/m-p/556545#M14760 <HTML><HEAD></HEAD><BODY><P>hi guys</P><P></P><P>Maybe it´s a basic question, but i´m getting confuse how to do this. I have one hosted feature layer from Survey123 to collect asset numbers in the field (barcode or qrcode from Rooms and Spaces on my Campus University), It´s working fine.</P><P></P><P>Sometimes&nbsp;I got duplicate asset numbers and it´s normal because the equipment was moved to another room. Here a sample.</P><P></P><P><IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/440146_EXCEL_iwJr3i7WTS.png" /></P><P></P><P>I built a simple app using WAB to show the collected record, that´s ok I can see all assets per room. But I need to show only one unique asset number (the latest one) in case of duplicate numbers.&nbsp;</P><P></P><P>Using the query widget&nbsp; it´s impossivel to create a query using Select Distinc based on field latest_edited_date.&nbsp;</P><P></P><P>So, any suggestion how to create this query on WAB or another way?</P><P></P><P>Thank you.&nbsp;</P></BODY></HTML> Fri, 22 Mar 2019 09:48:40 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/showing-most-recent-and-unique-values/m-p/556545#M14760 Luiz_AmadeuCoutinho 2019-03-22T09:48:40Z Re: Showing Most Recent and Unique Values https://community.esri.com/t5/arcgis-web-appbuilder-questions/showing-most-recent-and-unique-values/m-p/556546#M14761 <HTML><HEAD></HEAD><BODY><P>Anyone? <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span>&nbsp;</P></BODY></HTML> Tue, 26 Mar 2019 11:36:58 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/showing-most-recent-and-unique-values/m-p/556546#M14761 Luiz_AmadeuCoutinho 2019-03-26T11:36:58Z