For example, I want to review all the accounts that have more than 1 active user. We have account_id and user_id properties on the events, but how do I filter out accounts that only have 1 active user_id.
Best answer by Saish Redkar
View original
What is the best way to create a segment/cohort that tracks accounts with more than 1 unique user?
Userlevel 7
+10
Hi
Are you using the account add-on to instrument your accounts as groups?
If yes, then a cohort definition like this can help to identify orgs with 1 active user_id
That’s it. I was looking for something like that “distinct values of property”. Thank you!
Userlevel 5
+9
Hello,
Thank you Saish for stepping into this thread and providing a solution!
-Eddie
P.S. Checkout upcoming events and user meetups on our events page.
Thank you Saish for stepping into this thread and providing a solution!
-Eddie
P.S. Checkout upcoming events and user meetups on our events page.
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.