topic Re: Displaying unique values on the list in ArcGIS Dashboards Questions

Displaying unique values on the list

MuhammadYasir — Tue, 26 Nov 2019 21:45:53 GMT

Hi there,

I am trying to display unique values (no duplicate) in the list. I looked into filter and there is no function that removes the duplicates. Could you please guide me how to display unique value in the list? or is there any other way of displaying unique values (apart from list)? Waiting for your reply.

Regards

Yasir

Re: Displaying unique values on the list

DustinBaumbach1 — Wed, 17 Jun 2020 20:32:56 GMT

Hi Muhammad Yasir‌,

Have you figured out a solution to this problem? I am currently running into the same problem where I have multiple rows of duplicates within a list widget and I'd only like to display the unique two, but still have them connected to other attributes for displaying the correct value once the user clicks on another layer on the map.

Thank you

Re: Displaying unique values on the list

IlianaGalarza — Thu, 20 Aug 2020 20:42:46 GMT

Did you guys figured out how to remove duplicates (multiple rows) within a list widget?. I am trying to create a category selector where i will pull a list of unique names rather than each instance of the same name. Creating a static list won't work for two reasons: 1. The performance will be affected since is a list of 12,000 names and will be static list 2. I only want to display the names of who has submitted a form in Survey123.

Re: Displaying unique values on the list

DustinBaumbach1 — Thu, 03 Sep 2020 19:58:51 GMT

Hi Illiana. Nothing has been figured out to date. Maybe in the next iteration of the ArcGIS Dashboards‌? Let's keep watching this post.

Thank you,

Dustin

Re: Displaying unique values on the list

MollyWatson1 — Thu, 03 Sep 2020 20:48:31 GMT

I'd like to see this functionality added too. I can remove duplicates if I set up my category selector to use "grouped values" instead of "features." The problem with this method is that the "features" selection does not allow for the map actions like zoom, pan or show pop-up window. So if I want to enable those actions, I have to have duplicates in my category selector which is confusing to the user and looks bad.

Re: Displaying unique values on the list

TijsLips — Wed, 14 Apr 2021 15:08:31 GMT

Hi,

Had the same problem but finally found the way to do this:

Make sure you are using the new Dashboard (ex-Beta) version
Add the list widget and select "Data expressions"
Get your feature's itemId and layerId from the ArcGis Assistant.
Use this example from Esri and change the parameters to your details in step 3. The key is in the GroupBy, where you can choose your desired 'unique' feature column.
You can then use your unique/grouped list to filter the rest of your dashboard!

Re: Displaying unique values on the list

dcross — Tue, 16 Nov 2021 20:30:15 GMT

Thanks for the update here. This approach looks very promising but in the latest version of the Dashboard I do not seem to be able to use the function as suggested in the ESRI example.

FeatureSetByPortalItem

I'm looking in the List widget configuration. I can enable advanced formatting, and that provides access to arcade expressions. Unfortunately it does not support many functions, including FeatureSetByPortalItem (indicated in the screenshot below as "Not available"). Am I missing something or has the dashboard changed such that this no longer works?

Re: Displaying unique values on the list

TijsLips — Wed, 17 Nov 2021 10:15:26 GMT

Hi,

You shouldn't be trying this in the Advanced Formatting section. Immediately after selecting the 'List' widget in your dashboard you'll get an overview of the available layers for the list. In that window there is a section that says 'Data Expression'. There is where you should be.

Hope this helps.

Re: Displaying unique values on the list

OliverIshmael — Fri, 25 Mar 2022 03:13:25 GMT

I believe the code example that TijsLips provided came from this article, which describes the process in more detail. Hopefully it helps someone: Introducing Data Expressions in ArcGIS Dashboards (esri.com)

Re: Displaying unique values on the list

SteveF — Fri, 31 Mar 2023 13:44:16 GMT

The arcade suggestion while it works, still doesn't enable the pan, zoom etc... action, it only supports filter

Re: Displaying unique values on the list

Juan_Toro-Killion — Tue, 09 May 2023 16:54:44 GMT

this is a massive problem I'm experiencing right now. How does Esri expect you to be able to list unique values from fields and still have the same level of functionality in our dashboards?

You would think 'calling' the geometry in the Arcade expression would allow the Pan and Zoom actions to exist, but it doesn't make a difference.

Re: Displaying unique values on the list

SteveF — Mon, 14 Aug 2023 15:24:18 GMT

Seems like the typical approach is to offer a new product with new capabilities instead of fixing existing products. Currently, if I wanted to actually offer a solution to customers, I'd have to provide them with multiple apps to get all the capability that is needed. I get that ESRI holds the market share, but this is not the way to do business.