count of one record

[jobillborf]

Hi, I really did not know what to call the subject. In our database we have a field called addresskey.
This field is numeric.

Though out the day we can get calls from the same address. I would like to do a count of the number of unique calls received during a time period.

In other words is addresskey 1001 calls three times I would only like to count it once. Thank you for your help

 

[Naith]

You can use the distinctcount function:

DistinctCount({AddressKey})

Naith