Hi,
I’m trying to create a cohort of users who share the same user property without having to specify the actual value of the user property.
For example - A user property may be a hashed value of a user’s address. I’d like to create a cohort of users who share the same address as at least one other user.
Is this doable within Amplitude Cohorts ? Appreciate any help on this.
Thank you
Best answer by timothy-permutable
Create a segmentation chart, choose custom formula, then do the difference of uniques and propcount. You’ll need to group the event by the property that you want to count.
+10Interesting use case! I don’t think you can do this, without going through each property value individually (which I’m sure you don’t want to do).
Hi Timothy, Right. Segmentation gives me the table I’m looking for, but unfortunately, I can’t seem to translate that into a cohort.
Thanks for looking into this - much appreciated.
+10perhaps you can download the segmentation table and upload it as as cohort? I know that’s a bit manual, but might be an OK workaround.
Yes, that could be a workaround. For our use-case, we need to know if the user has entered the cohort in closer to realtime, so it isn’t ideal
+10I don’t know if it helps, but you can create a chart that counts the difference between counts of unique property values and unique users. So monitoring that would tell you when your case occurs, but not for which user.
+10Create a segmentation chart, choose custom formula, then do the difference of uniques and propcount. You’ll need to group the event by the property that you want to count.
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.
