What's new in Customer Journeys?

Connect and learn more! ×
Combining Conditions for column definition expression in Analytics Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Combining Conditions for column definition expression in Analytics Report

Received Response
43
Views
2
Comments
edited Dec 12, 2023 12:24PM in Reporting & Analytics for B2C Service 2 comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!