Skip to main content
Solved

Average of two events

  • October 28, 2022
  • 1 reply
  • 265 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

Best answer by Saish Redkar

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.

View original
Did this topic help you find an answer to your question?

1 reply

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1371 replies
  • Answer
  • October 28, 2022

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings