distinct with set analysis question

[gerrycastellino]

Trying to add a simple set analysis to this distinct expression:

Count(   DISTINCT [account_uuid ])

would like it to count distinct only when sfdc_account_id  is NOT NULL.

I've tried changing this to;

Count(   DISTINCT {< sfdc_account_id > {''} >}   [account_uuid ])

something's missing, it won't take it:

G.

[sunny_talwar · Accepted solution]

Try this:

Count(DISTINCT {<sfdc_account_id = {'*'}>} [account_uuid ])

[sfatoux72]

T‌ry this :

count({<sfdc_account_id={"*"}>} DISTINCT account_uuid)

[sunny_talwar]

Why the = sign Sébastien Fatoux‌? I have never seen this, so just curious

[sfatoux72]

‌it was an error that I corrected just after sending

But in your expression, you use simple quote. I thing it's better to use double quote to use search syntax.

[sunny_talwar]

But this is a single string, would it really matter?