nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Anonymous User

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?

Find more posts tagged with

Accepted answers

All comments

YorladyVela2

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.

MattFlowerday

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.

YorladyVela2

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

Anonymous User

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

Anonymous User

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

KelaineRavdin

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

MattPawson

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.

Luiz_RobertoArueira_da_Silva

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.