Excluding 2 values in set analysis

[Anonymous]

Hi everyone,

I have looked in multiple questions and none of the answers for excluding has worked for me.

Below is the expression I am testing.

I want to count all the unique emails and not include the two fields with values as bot.

count({<locale=- {bot}, signup_source =-{bot} >} DISTINCT email)

I hope this makes sense.

Thanks!

[Anonymous]

Hi Sunny,

Everything works great now.

I forgot to change the field name to matchup to my field name.

Also I made one slight change to your expression.  I changed the or to an and

=Count({<email = {"=locale <> 'bot' and signup_source <> 'bot'"}>} DISTINCT email)

That gives me a more accurate answer.

As always I appreciate your assistance