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:
IF(CONTAINS(your_property, "deploy"), "Contains deploy", "Other")
- 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.
3. Click "Apply" to use the custom property in your local analysis, or "Save" to make it reusable in other reports.
This 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.
If 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.
