Solved

Multi-select vs "and where" to identify users in all three cohorts

  • 7 December 2021
  • 1 reply
  • 30 views

In an event segmentation chart, on the right-hand side I am looking for all users who belong to cohort A AND cohort B AND cohort C. (For the event on the left-hand side, I’m using “Any Event”.)

1. I can build this by choosing All Users where Cohort = A, B, C
OR
2. I can build this by choosing All Users where Cohort = A, and where Cohort = B, and where Cohort = C. 

My user count is MUCH larger in 1 than in 2, making me wonder if the build in 1 is actually an OR statement (where Cohort = A or B or C)

So, what is the different between multi-selecting user properties and listing them individually?

icon

Best answer by MikkoKarvonen 8 December 2021, 07:49

View original

1 reply

Userlevel 5
Badge +2

It’s as you suspected, the approach #1 is effectively an OR statement. If the user belongs to any one of those cohorts, they’ll be included. The approach #2 is what you are looking for.

This applies to all the user properties, not just cohorts.

Reply