Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Report to count only if 'yes' is the value across multiple fields

edited Oct 28, 2015 11:42PM in Reporting & Analytics for B2C Service 1 comment

Content

We have a number of Opt-in fields that record different customer preferences. e.g. does the customer want to receive (field 1) Brochures - Yes/No, (field 2) SMS - Yes/No, (field 3), Emails - Yes/No. We then have a separate menu field for a product dimension (A or . Obviously the two are not actually related in the system, but they can be loosely correlated as you can only be interested in A or B at any one time. So I can select that I am interested in Brochures and Emails for Product A. 

I've been asked to build a report that shows the number of contacts who have selected Yes (in this case, optin yes) for each preference. Output expected is:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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