Solved

How to compare two event properties in a chart's where clause

  • 1 December 2021
  • 2 replies
  • 203 views

Badge

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?

 

 

icon

Best answer by Saish Redkar 1 December 2021, 06:03

View original

2 replies

Userlevel 7
Badge +10

Hey @lance

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.

Badge

Thanks @Saish Redkar, i’ll give this a try!

Reply