How to Create an Insights Report for Property Comparison
I want to create an insights report to show a specific event where property 1 equals property 2. both properties are numbers. how to do it
Hi Zeyad Y., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To create an Insights report in Mixpanel where you want to show events where two numeric properties are equal, you can use Custom Properties to create this comparison. Here's how to do it:
Creating a Custom Property for the Comparison
1. Start by creating a new Insights report 2. Expand the Event dropdown and select your specific event 3. Click on the "Filter" button to add a filter 4. Instead of using a regular property filter, you'll need to create a custom property: - Click on the "+" button next to the search bar in the property selector - This will open the Custom Property creation interface5. In the Custom Property formula field, use the comparison operator "==" to check if the two properties are equal:
```LBKS Where "property1" and "property2" are the actual names of your numeric propertiesLBKS6. Name your custom property (e.g., "Properties Are Equal") 7. Save the custom propertyLBKS8. Now filter your event by this new custom property where the value equals "true"LBKSThis approach leverages Mixpanel's comparison operators in custom properties, which allow you to create boolean conditions based on property comparisons. The "==" operator specifically checks if two values are equal, which is exactly what you need in this case.LBKSIf you're on a Growth or Enterprise plan, you can save this custom property for reuse in other reports. Free plan users can still create the custom property but only use it locally within the current report.LBKSFor more information about comparison operators in custom properties, you can refer to the [Custom Properties documentation](https://docs.mixpanel.com/docs/features/custom-properties#comparison-operators).kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.