Creating a Filter for 'deploy' in Mixpanel Properties
I'm trying to create a property in Mixpanel that filters for 'action title' property which only contains the string 'deploy'. How can I do this, what is the syntax?
I'm trying to create a property in Mixpanel that filters for 'action title' property which only contains the string 'deploy'. How can I do this, what is the syntax?
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 create a property in Mixpanel that filters for the event property action title containing the string deploy, you can use the filter functionality in reports or create a custom property using Mixpanel’s formula builder.
If you are filtering in a report: - Add a filter to your event (e.g., in an Insights report). - Select the action title property. - Use the contains operator and enter deploy as the value.
If you want to create a custom property that evaluates to true when action title contains deploy, you can use the split or regex_replace functions, but the knowledge sources do not provide a direct contains function in the custom property formula builder. However, you can use the split function to check if deploy is present, for example:
```
len(filter(X, split([action title], " "), X == "deploy")) > 0
LBKSBut this only works if deploy is a separate word in the action title. For a substring match, the knowledge sources do not explicitly mention a contains function for custom properties.
For segmentation expressions (e.g., in the Query API), you can use:
LBKS```
properties["action title"] == "deploy"
or for an exact match, but for substring matching, the knowledge sources do not provide a direct contains operator. You may need to use regex_replace or similar functions if available, but this is not clearly documented for substring matching in custom properties.
In summary: - For report filters, use the contains operator in the UI. - For custom properties, substring matching is not explicitly documented in the knowledge sources, so you may be limited to exact matches or workarounds using split if deploy is a separate word.
References: - Custom Properties: Functions - Reports Overview: Filters
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.