Hey! I had a question about using not in logic - getting myself confused with De Morgan's logic. When building a cohort, I want to exclude anyone in who is in any of the cohorts A or B or C. Which is the right logic to use: (User not in Cohort A Cohort B Cohort C) - I get 1,688 users returned. (User not in Cohort A) and (User not in Cohort B) and (User not in Cohort C) - I get 435 users returned. I suspect it's the latter which is correct but wanted to see if anyone else has any ideas...
Hi Fred- Julianne from Mixpanel Support here!
Diving right in, the latter logic is the correct one to use if you want to exclude anyone who is in any of the cohorts A, B, or C.
When you use the logic (User not in Cohort A Cohort B Cohort C), it's an 'OR' operator. This means it's filtering for users not in A OR not in B or not in C. If a user is part of one cohort but not the other, they will still qualify since they meet one of the criteria. For example, if a user is only in cohort A, they would still be included in the report since they are 'not in cohort B'.
On the other hand, when you use the logic (User not in Cohort A) and (User not in Cohort B) and (User not in Cohort C), it's an 'AND' operator. This means that it will only include users who are not in any of the cohorts A, B, or C. If a user is in any one of these cohorts, they will be excluded from the results, which is what it sounds like you're interested in.
Let me know if you have any questions!
