I want to measure the number of unique users per month who performed EITHER of several events. Do I just use
UNIQUES(A)+UNIQUES(B)+UNIQUES(C)
or would that still hold duplicate users (counts per event and just adds, or deduplicate as well)?
I want to measure the number of unique users per month who performed EITHER of several events. Do I just use
UNIQUES(A)+UNIQUES(B)+UNIQUES(C)
or would that still hold duplicate users (counts per event and just adds, or deduplicate as well)?
Hey
Creating a custom event will be the ideal approach to measure the “number of unique users per month who performed EITHER of several events” use case.
I believe that the formula approach of UNIQUES(A)+UNIQUES(B)+UNIQUES(C) will just perform pure arithmetic sum of the unique counts without any deduplication.
Let me know if I have interpreted your use case correctly. Hope this helps.
Yes, played with this some more after posing here, you are right (both as to the custom event approach, and as to the “pure arithmetic sum” my original solution does).
Thanks
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.