I want to group a a property to divide the results in ones that contain the string 'deploy' and all others, how can I create a custom property to do this in Mixpanel?
Hi Stevan V., 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 group a property in Mixpanel so that results are divided into those that contain the string "deploy" and all others, you can use a custom property with a formula that checks for the presence of "deploy" in the property value.Here’s how you can do it: 1. Click the plus button to the right of the search bar in your report and select "Event Property" or "User Property" to open the property builder.
2. In the formula bar, use a formula that checks if your property (let’s call it your_property
) contains the substring "deploy". For example, you can use an IF statement with a string function:
```LBKSLBKS - Replace `your_property` with the actual property name you want to evaluate.
- This formula will create a new property that is "Contains deploy" if the original property includes "deploy", and "Other" otherwise.LBKS3. Click "Apply" to use the custom property in your local analysis, or "Save" to make it reusable in other reports.LBKSThis approach leverages Mixpanel’s custom property feature, which allows you to create new properties using Excel-like formulas for flexible segmentation and analysis [Custom Properties: Calculate new properties on the fly](https://docs.mixpanel.com/docs/features/custom-properties#creating-a-custom-property).LBKSIf you want to use this segmentation only temporarily, you can also use Custom Buckets in the Breakdown menu, but for more control and reusability, a custom property as described above is recommended [Custom Properties: Calculate new properties on the fly](https://docs.mixpanel.com/docs/features/custom-properties#creating-a-custom-property).
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.