I’m trying to get the number of users who performed all three specific events so I can work with that number in the formula bar… I tried UNIQUES(A,B,C) and UNIQUES(A+B+C)
Is there a way to do this?
Best answer by Saish Redkar
View original
Userlevel 7
+10
Hi
Formula approach won’t help much here since it is more suitable for getting the total of uniques who performed those 3 events individually rather than uniques users who performed all 3 events.
e.g this demo chart - https://analytics.amplitude.com/demo/chart/new/srqy32n
Per the formula in the chart, you will get the daily arithmetic sum of uniques performing the 3 events separately.
If you want to get unique user count who have performed all three specific events over a given time frame, then a segment or cohort approach will be helpful.
eg. this chart - https://analytics.amplitude.com/demo/chart/new/9mdth0m. In this chart, you get your unique count of users who did all those 3 events during the last 30 days.
Make sure you are using the same time frame for each of the performed clauses as results may differ accordingly.
Hope this helps.
Thanks!
Reply
Welcome to the Amplitude Community!
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're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
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.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.