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.
You might want to try Data Expressions:
You could utilise the Distinct Arcade function in a data expression: