Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field with emails, the idea is to have the sum of views that the users are making to some documents.
But I will like to exclude the emails that are like '@gmail.com' for example.
Actually I am summing everything but will like to sum all except for the gmail accounts.
How can I do that?
Hi Roberto,
Maybe something like:
Count({$<email -={'*gmail.com'}>}ViewID)
You will need to change email and ViewID to the fieldnames you are actually using.
Regards
Andrew
May be like Not WildMatch() function. Can you explain a little more if below is not what you are expecting?
IF(Not WildMatch(YourfieldName, '*@*'), 1, 0) As yourNewField
May be like this
=if(SubStringCount(Email,'gmail')=1,0,Count(ID))
I need to use it in an expression, how can I put it there?
May be this?
= Sum(IF(Not WildMatch(YourfieldName, '*@*'), 1, 0))
Hi Roberto,
Maybe something like:
Count({$<email -={'*gmail.com'}>}ViewID)
You will need to change email and ViewID to the fieldnames you are actually using.
Regards
Andrew
Create the flag in script
LOAD *,
if(wildmatch(lower(Email),'*@gmail.com*',1,0) as EmailFlag
FROM Table;
Now you can write the expression in chart like below
=count({<EmailFlag={0}>} ID)
This is what I needed, thank you
Hi Roberto,
Glad to help!!