Skip to main content
I have 2 events, I need to calculate the average number of events per user. I don't know how to use the number of users in the formula. Or can I use merge events? My formula should look something like this: (event A + event B) / All userThanks for the help

Hey @Archch 

I would go with creating a custom event for this use case.

Assuming you create a custom event C defined for Event A | Event B ( evaluated as OR clause ).

TOTALS(C) should be evaluated as TOTALS(A) + TOTALS(B) imo ( you can verify before proceeding )

Using this you can either try AVG(C) formula or TOTALS(C)/UNIQUES(C) to get your average per user.

Let me know if that works out.

Reply


Terms & ConditionsCookie settings