https://community.esri.com/t5/arcgis-dashboards-questions/sql-clause-for-quot-show-unique-quot-in-dashboard/m-p/1097888#M5081 <P>Hi David,</P><P>You might want to try Data Expressions:</P><P><A href="https://doc.arcgis.com/en/dashboards/get-started/create-data-expressions.htm" target="_blank">https://doc.arcgis.com/en/dashboards/get-started/create-data-expressions.htm</A></P><P>You could utilise the Distinct Arcade function in a data expression:</P><P><A href="https://developers.arcgis.com/arcade/function-reference/data_functions/#distinct" target="_blank">https://developers.arcgis.com/arcade/function-reference/data_functions/#distinct</A></P><P>&nbsp;</P> Tue, 14 Sep 2021 03:09:33 GMT mdonnelly 2021-09-14T03:09:33Z https://community.esri.com/t5/arcgis-dashboards-questions/sql-clause-for-quot-show-unique-quot-in-dashboard/m-p/1097872#M5080 <P><SPAN>I'm helping a researcher using AGO Dashboards for their project site. My first time dealing with Dashboards. </SPAN></P><P><SPAN>The table that drives the dashboard list output has duplicate locations in it (where they have multiple projects at a single partner location). They would like this list to show only unique partner names instead. Is there an SQL clause to show only unique? Distinct? Not sure if this is possible, or if this even an SQL clause&nbsp;window.&nbsp;</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="thumbnail_image001.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/22896iD864D93C2F83C5AC/image-size/large?v=v2&amp;px=999" role="button" title="thumbnail_image001.png" alt="thumbnail_image001.png" /></span></SPAN></P> Tue, 14 Sep 2021 00:42:47 GMT https://community.esri.com/t5/arcgis-dashboards-questions/sql-clause-for-quot-show-unique-quot-in-dashboard/m-p/1097872#M5080 DavidMedeiros 2021-09-14T00:42:47Z https://community.esri.com/t5/arcgis-dashboards-questions/sql-clause-for-quot-show-unique-quot-in-dashboard/m-p/1097888#M5081 <P>Hi David,</P><P>You might want to try Data Expressions:</P><P><A href="https://doc.arcgis.com/en/dashboards/get-started/create-data-expressions.htm" target="_blank">https://doc.arcgis.com/en/dashboards/get-started/create-data-expressions.htm</A></P><P>You could utilise the Distinct Arcade function in a data expression:</P><P><A href="https://developers.arcgis.com/arcade/function-reference/data_functions/#distinct" target="_blank">https://developers.arcgis.com/arcade/function-reference/data_functions/#distinct</A></P><P>&nbsp;</P> Tue, 14 Sep 2021 03:09:33 GMT https://community.esri.com/t5/arcgis-dashboards-questions/sql-clause-for-quot-show-unique-quot-in-dashboard/m-p/1097888#M5081 mdonnelly 2021-09-14T03:09:33Z