Using String Operations on Property Filters in Data Management
how can i apply string operations like length count on property filters?
how can i apply string operations like length count on property filters?
Hi Tobias, 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
You can’t apply arbitrary string functions directly inside standard report filter UI fields, but there are two supported ways to do “length/count”-style string logic based on the docs:
1. Use a Custom Property with len, left, right, mid, split, etc.
Create a Custom Property that computes what you need, then filter on that new property.
For example, to get the length of a string property A:
``` text len(A)
LBKS`len` returns the length of a string (or list), so this custom property becomes numeric and can be used in filters and breakdowns (e.g. `len(A) > 10`).[[Custom property functions](https://docs.mixpanel.com/docs/features/custom-properties#functions)]
Other useful string operations in custom properties:
- `left(A, 3)` – first 3 characters
- `right(A, 3)` – last 3 characters
- `mid(A, 1, 4)` – substring from position 1, length 4
- `split(A, "/", 2)` – 2nd piece after splitting on `/`[[Custom property functions](https://docs.mixpanel.com/docs/features/custom-properties#functions)]
You then use this custom property in any report filter as you would a normal property.
2. Use Segmentation Expressions in the Query API (advanced)
If you are using the Query API (/segmentation, /funnels with where / on), you can write an expression (not just a simple equals filter) using the expression grammar. Supported operations include:
- arithmetic: + - ** / %
- comparisons: == != > > = < <=
- logical: and or not
- regex / in
- typecasts: boolean() number() string()
- floor, round, ceil<https://github.com/mixpanel/docs/blob/main/reference/Mixpanel%20APIs/segmentation-expressions.md|[Segmentation expressions>]
However, in the segmentation-expression grammar there is no len() or substring function documented, so you cannot directly compute string length there; you would still need to precompute length (e.g., as a property or via custom properties in the UI) and then reference that numeric property in the where clause.
So to “apply string operations like length count on property filters” in the UI: define a *Custom Property using len, left, right, mid, or split, then filter on that derived property. There is no direct len() in plain filter fields or in segmentation-expression grammar per the provided docs.
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.
