Is it possible to customize buckets by date in the breakdown for a chart? For example, I want to breakdown everyone with a date >2025 vs. <2025
Hi Elise 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 do this, but not as “date buckets” in the sense of arbitrary calendar ranges; you’d use Custom Buckets on a property that’s treated as a String or Date and define segments like “before 2025” vs “2025 and after.”
From the docs:
- Custom Buckets let you group existing properties into segments on the fly in Insights, Funnels, and Retention reports. [Custom buckets] - They work on String, Numeric, and List data types, and you can typecast a property’s data type first if needed. [Data types; Typecasting + buckets]
To approximate date < 2025 vs date ≥ 2025:
1. Add your date property as a breakdown in an Insights/Funnels/Retention report. 2. If it’s not already a Date/String, use the Data Type menu to typecast it appropriately. https://docs.mixpanel.com/docs/reports#typecasting|[Typecasting] 3. Open Custom Buckets from the breakdown’s overflow menu and define two segments: - Segment 1: values before 2025 - Segment 2: values in/after 2025 (or use “remaining values” for the catch‑all). [[Custom buckets](https://docs.mixpanel.com/docs/features/custom-buckets)]
The docs don’t show an explicit example with a date property split at a specific year, but they do show the same pattern applied to other properties (e.g., age, durations) using typecasting + custom buckets, which is the same mechanism you’d use here. [Typecasting use cases; Numeric buckets]
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.
