idea Operations Dashboard widget to display count of distinct unique values in ArcGIS Dashboards Ideas

Operations Dashboard widget to display count of distinct unique values

Anonymous User — Mon, 07 May 2018 02:16:59 GMT

The idea is to create a new widget or make an enhancement to an existing widget to display a count of the distinct/unique values in a field.

The basic indicator widget allows you to display a total count of records, or statistics such as minimum, maximum, average etc. But currently not the ability to display the count of unique values.

e.g. given the following values in a hypothetical field 'FirstName':

Paul

John

Fred

John

The count of unique values would be 3, for 'Paul', 'John' and 'Fred'.

Ironically, when you try to set a filter on the basic 'Indicator' widget where the value is equal to something, the widget provides a drop down list of all available distinct values - so it is likely already performing the necessary query! All we need if for it to do this and return the count of those as the actual result of the widget.

Re: Operations Dashboard widget to display count of distinct unique values

JackCibor — Thu, 02 May 2019 16:49:56 GMT

The same functionality would be helpful in WAB

Re: Operations Dashboard widget to display count of distinct unique values

TI — Mon, 24 Aug 2020 23:58:36 GMT

Ditto... I need this in Web App Builder (we use WAB instead of ops dashboard).

Re: Operations Dashboard widget to display count of distinct unique values

OSACAfrica — Fri, 25 Sep 2020 01:17:21 GMT

David Nyenhuis David Nyenhuis‌ Any update on this?

Re: Operations Dashboard widget to display count of distinct unique values

DavidNyenhuis1 — Fri, 16 Oct 2020 19:10:52 GMT

Hi OSAC Africa,

The count distinct option is currently available in ArcGIS Dashboards Beta.

Vivek Malleshappawrote a good blog on this.

Re: Operations Dashboard widget to display count of distinct unique values

OSACAfrica — Fri, 16 Oct 2020 19:19:41 GMT

Apologies for lack of original clarity: for distinct count for lists in Beta.

Re: Operations Dashboard widget to display count of distinct unique values

souzadias — Thu, 08 Apr 2021 22:17:53 GMT

@DavidNyenhuis1 this is true only for some widgets like Indicator. I would like to be able to count distinct values in a pie chart. This is not possible even in beta.

Re: Operations Dashboard widget to display count of distinct unique values

DavidNyenhuis1 — Thu, 08 Apr 2021 23:11:11 GMT

Hi @souzadias,

In the upcoming release of ArcGIS Online (next week), count distinct will become available in the pie chart and serial chart elements of dashboards.

Re: Operations Dashboard widget to display count of distinct unique values

souzadias — Thu, 08 Apr 2021 23:13:30 GMT

@DavidNyenhuis1

Awesome!! Thanks for the update 🙂

Re: Operations Dashboard widget to display count of distinct unique values - Status changed to: Implemented

patrickb — Wed, 14 Apr 2021 18:35:28 GMT

Count Distinct has now been released and is available for the elements in the previously mentioned blog post. For elements not mentioned, Arcade functions like GroupBy(), Count(), and Distinct() can now be used in the context of another exciting new feature: Data expressions

Re: Operations Dashboard widget to display count of distinct unique values

JessicaFraver1 — Tue, 11 May 2021 18:59:05 GMT

I now see the Distinct option, however, it is not working as I had hoped. I have a CIP Project Location feature layer which is referenced. Projects can have multiple locations, so I not only want to display a location count (N = 330), I also want to display a project count (N= 105) . I added a Survey123 dataset and got it to work. Does Distinct only work on hosted feature layers? That would be disappointing. Or do I need to create a newer version of the referenced layer to get it to work with this newer functionality?

I tried saving the Classic map in the new Map Viewer platform and then creating a dashboard from the new map, but that did not work either. I also tried creating a new map from scratch and added other hosted and referenced layers. It works on some fields, not all, with hosted - some give the incorrect overall total count instead of distinct count of values. Referenced gives a No Data result.

I have not yet checked out data expressions. Thanks for the suggestion @patrickb.