Hi,
I am trying to create a segmentation chart where I filter out events in which two different event properties are equal; an equivalent SQL filter would be WHERE event_prop1 <> event_prop2. Is something like this possible?
Best answer by Saish Redkar
View original
+10
Hey
Afaik, Amplitude currently doesn’t support direct comparison between different event properties on a given event. We can only use the comparison for the actual property values like event_prop1 = ‘stringABC”.
The closest thing possible which I have used to comparing two event properties in Amplitude in some context is the relative count feature in a cohort as follows. Not sure if this will help you in your case
Let me know if I have interpreted your use case correctly. Hope this helps.
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
