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?
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.
Thanks Saish Redkar, i’ll give this a try!
Hi Saish Redkar ,
Does Amplitude still not support direct comparison between different event properties? I want to subtract one property value from another and see the difference, and I saw that this was an issue two years ago.
Thanks!
A workaround is using computed properties (if available) or creating a custom event with the comparison already applied. Another option is exporting the data and doing the comparison in a BI tool or database.
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!
Hi, I’m trying to create a chart in Amplitude using the Page Viewed: Cart event, measured as Uniques, over the past 7 days. However, I keep getting this error on the graph: "An error occurred while loading your data. (400 status code)" Other events seem to load fine, so it looks specific to this event or configuration. Has…
