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 RedkarView original
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.
@Saish Redkar, i’ll give this a try!