Is it possible to exclude data record value = 0 ?
Hi Yanisa S., 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
Yes, you can exclude records where a property’s value is 0, but how you do it depends on where you’re working: - In reports (e.g. Insights, Funnels): use a filter on that property with a condition like “is not 0”. Filters can be applied globally to the whole report or inline to a specific event/step. [Reports filters]- With Custom Buckets on numeric properties: 0 will fall into one of the numeric ranges you define; you can simply not include that bucket in your analysis (e.g. only select buckets for values > 0). [Custom buckets FAQ]The docs don’t show a specific “exclude 0” button, but any numeric filter or bucket setup that only includes values > 0 (or != 0) will effectively exclude records where the value is 0.
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.
