Count unique values

[Sunil_Kenth]

Hi,

I need some help with an expression.

How can i count the number of unique and not unique email addresses in my data.  The email field is called EMAIL.

Thanks for your help.

Sunil

[#2]

Hi,

   use "Count" aggr function with "Distinct" for respective field.

-Jai

[its_anandrjs · Accepted solution]

Hi,

You want to count unique values so for that you need to count by =Count(Distinct EMAIL) which gives count of unique values. and for duplicate values you need to count how much time it is repeated like =Count( EMAIL).

Regards,

Anand

[kaushiknsolanki]

Hi,

    Try count(distinct EMAIL) for unique Mail ID

    and

    Count(Email) for over all Mail ID

Regards,

Kaushik Solanki