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