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: LBKSlen(filter(X, split([action title], " "), X == "deploy")) > 0LBKS
But 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: LBKSproperties["action title"] == "deploy"LBKS
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.