Combining Conditions for column definition expression in Analytics Report
I'm facing a challenge in Analytics reports while trying to create a column definition expression that combines multiple conditions. I have two distinct expressions for counting contact records with a non-null email address and a unique phone number.
I am seeking assistance in combining them into a single expression, where I aim to retrieve the count of records with both a unique phone number and a non-null email address.
Here are the individual expressions used in each column definition :
Count of records with email address: sum(if(contacts.email is not null, 1, 0))
Count of records with unique phone number: count(distinct contacts.ph_asst)
0