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](https://docs.mixpanel.com/docs/features/custom-buckets#overview)]
- They work on String, Numeric, and List data types, and you can typecast a property’s data type first if needed. [[Data types](https://docs.mixpanel.com/docs/data-structure/property-reference/data-type#overview); [Typecasting + buckets](https://docs.mixpanel.com/docs/features/custom-buckets#typecasting-property-use-cases)]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](https://docs.mixpanel.com/docs/features/custom-buckets#typecasting-property-use-cases); [Numeric buckets](https://docs.mixpanel.com/docs/features/custom-buckets#numeric-property-use-cases)]
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.
