Solved

Average of two events

  • 28 October 2022
  • 1 reply
  • 87 views

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
icon

Best answer by Saish Redkar 29 October 2022, 00:50

View original

1 reply

Userlevel 7
Badge +10

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