topic Re: Is there a widget that displays a count of unique values in a given field? in ArcGIS Dashboards Questions

Is there a widget that displays a count of unique values in a given field?

Anonymous User — Sun, 26 Feb 2017 22:21:46 GMT

I have a field in a webmap called 'deviceId' that displays a unique string for each device that pushes data into it.

Ideally, I want a widget in an Operations Dashboard that displays a count of the number of unique devices.

I can see how to display a count of features, but can't see how to create a query that filters by unique value.

In a round-a-bout way, a bar graph achieves something similar, by displaying a unique bar for each deviceId with counts of the number of features for that deviceId, but it's not the effect I want. I just need a single count figure.

Any ideas?

Re: Is there a widget that displays a count of unique values in a given field?

YorladyVela2 — Wed, 22 Mar 2017 15:37:41 GMT

You could start by using the Query widget to help identify any unique devices and then create a counter that takes the query results and displays them according to count per unique device in a summary widget . I hope it works for you.

Re: Is there a widget that displays a count of unique values in a given field?

MattFlowerday — Thu, 23 Mar 2017 05:27:38 GMT

Hi there

thanks for the reply.

Can you elaborate please on how you would create the query?

When specifying the query criteria, it allows you to choose a field, an operator and a value. The operators are contains, equal, not equal, is blank and is not blank. None of those seem to allow you to specify unique values and I can't see how you would use any of those to get a count of unique features.

Re: Is there a widget that displays a count of unique values in a given field?

YorladyVela2 — Mon, 03 Apr 2017 16:14:41 GMT

My suggestion is the as follows:

First Create a query widget and insert a query by atribute.

Then create a resumen widget. In the source dataset shoose the results of the query widget.

When you execute a query, the resume widget shows the count given the query.

Suggestion

Re: Is there a widget that displays a count of unique values in a given field?

Anonymous User — Mon, 03 Apr 2017 21:20:14 GMT

Hi Yorlady

Thanks for replying.

I might not be explaining myself properly though. Take the following sample table data:

objectid | deviceId

1 | ABCDEFG

2 | ABCDEFG

3 | ABCDEFG

4 | ZYXWVUT

You can see that there are four records, but three have the same deviceid. I want the summary count to report the count as '2', because there are two unique deviceid's in the table.

I understand the 'summary' (resume in Spanish?? ) widget, but cannot see any way, using the standard query tools that are available, to create a query that returns unique values.

The equivalent SQL query would be something like: 'SELECT DISTINCT deviceId from.....' .

I don't think it can be done using the standard tools, but still hoping someone might suggest a way so we don't have to custom write something...!

Re: Is there a widget that displays a count of unique values in a given field?

deleted-user--W0njQoLz5cX — Tue, 18 Jul 2017 19:36:23 GMT

Hi Paul,

Just to check did you find the solution to the above ? I am also stuck on the same issues, and any help from you will be appreciated.

Thanks,

Amit Prakash

Re: Is there a widget that displays a count of unique values in a given field?

Anonymous User — Tue, 18 Jul 2017 21:12:51 GMT

No, not out of the box.

Re: Is there a widget that displays a count of unique values in a given field?

deleted-user--W0njQoLz5cX — Fri, 21 Jul 2017 16:41:28 GMT

Hi Paul,

Any idea , how can we achieve this by custom ?

Thanks and Regards,

Amit Prakash

Re: Is there a widget that displays a count of unique values in a given field?

Anonymous User — Sun, 23 Jul 2017 20:57:55 GMT

No. I passed it on to a dev team to look into, I don't think they even used Ops Dashboard.

Re: Is there a widget that displays a count of unique values in a given field?

deleted-user--W0njQoLz5cX — Mon, 24 Jul 2017 18:57:23 GMT

Ok , thanks for the information.

Thanks and Regards,

Amit Prakash

Bristow Group Inc.

2103 City West Blvd., 2nd Floor

Houston, TX 77042

Office: +1-713-267-7659

Mobile: +1-346-228-4258

Re: Is there a widget that displays a count of unique values in a given field?

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

Hi all, just bumping this question again. It's been over a year, and a major release update of Ops Dashboard since then.

I still can't find any way to get a count of distinct unique values in a field. Can anyone confirm if this is possible yet or not?

EDIT:

I have created an 'Idea' that you can find and up-vote here:

https://community.esri.com/ideas/14948-operations-dashboard-widget-to-display-count-of-distinct-unique-values

Thanks if you do up-vote it.

Cheers,

-Paul

Re: Is there a widget that displays a count of unique values in a given field?

KelaineRavdin — Tue, 18 Aug 2020 22:50:39 GMT

Bumping this one to see if there is anything new. I too would very much like to be able to do this.

Re: Is there a widget that displays a count of unique values in a given field?

MattPawson — Mon, 31 May 2021 02:07:31 GMT

If anyone comes across this post, I think this has been implemented in the new 'ArcGIS Dashboards' (this is not implemented in 'ArcGIS Dashboards Classic').

See https://www.esri.com/arcgis-blog/products/ops-dashboard/announcements/making-it-count-with-arcgis-dashboards-beta/

Sidenote, I stumbled across this post as I'm having issues in getting distinct values using an arcade feature set as an input. Using a normal feature layer works fine though.

Re: Is there a widget that displays a count of unique values in a given field?

Luiz_RobertoArueira_da_Silva — Wed, 02 Jun 2021 13:05:31 GMT

Bom dia,
Você pode selecionar o campo 'deviceId' e criar uma tabela resumo com a contagem de registros por 'deviceId'.

Em seguida, se for esse o seu desejo, pode selecionar 'deviceId da tabela resumo e criar um card KPI.
Espero ter ajudado.