I am trying to break down app open event by number of times orders were placed. I am bucketing these users by 0 and >=1. I am getting a third set which is "non numeric" values. what is the meaning of "non numeric" stand for? It should be wither 0 or >=1.
What "Non-Numeric Values" Means in Custom Buckets
The (non-numeric values) bucket appears when some of your event data has values for that property that were sent as a non-numeric data type (e.g., strings like "N/A", "unknown", "", or other text) rather than actual numbers. In other words, even though your "number of orders placed" property is intended to be numeric, some events were tracked with a value that Mixpanel cannot interpret as a number. [Custom Buckets FAQ] Here's the distinction between the three categories you're seeing:
Bucket | Meaning |
0 | Events where the property value is the number 0 |
≥1 | Events where the property value is a number ≥ 1 |
(non-numeric values) | Events where the property value was sent as a non-numeric type (e.g., a string like "none" or "0") |
(not set) | Events where the property was not sent at all |
What to do
Investigate your tracking implementation — Check if there are cases where the "number of orders" property is being sent as a string (e.g., "0" instead of 0) or with placeholder text values.
Use typecasting — You can typecast the property to a Numeric type in the Mixpanel UI, which will attempt to interpret string numbers (like "0") as actual numbers. [Typecasting]
Fix at the source — The best long-term fix is to ensure your tracking always sends this property as a proper numeric value.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
