Clarification on Using Formula A+B for Counting Users and Event Duplication
if I want use formual A+B its will be duplicating or will count only users that do both event ?
if I want use formual A+B its will be duplicating or will count only users that do both event ?
In Mixpanel's Insights report, when you use a Formula like A+B, it adds the counts of event A and event B together — it does not deduplicate or filter to only users who did both events.
A+B = total count of event A plus total count of event B (arithmetic addition)
A user who did both events would be counted twice (once for A, once for B)
A user who did only A or only B would still be counted
If your goal is to count users who performed either event A or event B (without double-counting), you should use a Custom Event instead. A Custom Event lets you combine multiple events into a single virtual event, so a user is counted once regardless of which of the combined events they performed. [Custom Events]
In summary:
| Approach | What it does |
|---|---|
| Formula A+B | Adds counts together (can double-count users) |
| Custom Event (A OR B) | Counts unique users who did either event |
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Based on your previous question and this follow-up, it sounds like you want to count users who did both event A and event B (i.e., an intersection/AND condition).
The best way to do this in Mixpanel is with a Cohort. You can define a cohort in the Cohort Builder with conditions like:
User did Event A AND User did Event B
This will give you only the users who performed both events. [Cohorts]
Once you've created that cohort, you can use it as a filter in your Insights report to analyze only those users.
Here's a quick summary of your options:
| Goal | Approach |
| - | - |
| Count A + B (total, may double-count) | Formula A+B in Insights |
| Count users who did A or B (no double-counting) | Custom Event (A OR B) |
| Count users who did both A and B | Cohort with AND condition |
The knowledge sources do not explicitly describe a direct formula approach for an AND intersection count, so using a Cohort filter is the recommended path for your use case.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.