SQL clause for "show unique" in dashboard list?

467
1
09-13-2021 05:42 PM
DavidMedeiros
Occasional Contributor III

I'm helping a researcher using AGO Dashboards for their project site. My first time dealing with Dashboards.

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 window. 

 

 

thumbnail_image001.png

0 Kudos
1 Reply
mdonnelly
Esri Contributor

Hi David,

You might want to try Data Expressions:

https://doc.arcgis.com/en/dashboards/get-started/create-data-expressions.htm

You could utilise the Distinct Arcade function in a data expression:

https://developers.arcgis.com/arcade/function-reference/data_functions/#distinct

 

Regards,
Mark
0 Kudos