Customizing Bucket Sizes for User Property Distribution Analysis
When aggregating property per user, for a distribution, is there a way to customise the size of the buckets?
When aggregating property per user, for a distribution, is there a way to customise the size of the buckets?
Hi Howard A., 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, when aggregating a property per user and viewing the distribution in Mixpanel Insights, you can customize the size of the buckets. By default, Mixpanel will auto-bucket high-cardinality numeric properties into even-sized ranges, but you have the option to edit these buckets using the “Custom Buckets” feature.
To do this:
1. Add a breakdown on your numeric property. 2. Open the overflow menu and select Customize Buckets. 3. You can choose: - Even Bucketing: Set uniform bucket sizes and define the min/max range. - Varied Bucketing: Define specific breakpoints for custom-sized buckets. - None: See all values as-is, with no grouping.
This allows you to tailor the distribution buckets to your analysis needs, whether you want even intervals or custom ranges (e.g., <10, 10–20, 20–50, 50–100, ≥100). Note that both lower-end and upper-end buckets are auto-generated to ensure your breakdown always adds up to 100% <https://docs.mixpanel.com/docs/features/advanced#numeric-property-use-cases|Custom Buckets - Numeric property Use Cases>.
If you want to see the exact numeric values without any bucketing, you can typecast the property to a string, which removes the range bucketing Typecasting.
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.
Let me check the knowledge base for you again. One moment! 📚
When using Aggregate Property per User (such as the distribution of the maximum value per user) in Mixpanel Insights, you can view the distribution of these per-user aggregates. By default, Mixpanel will bucket these numeric results into ranges.
You can customize these buckets by using the Custom Buckets feature. After selecting your measurement (e.g., "Maximum" of a property per user) and choosing "Distribution" as the aggregation, you can:
1. Open the overflow menu on the breakdown axis. 2. Select Customize Buckets. 3. Choose between Even Bucketing (uniform bucket sizes) or Varied Bucketing (custom breakpoints for each bucket).
This allows you to define the exact bucket sizes or ranges for your distribution, even when working with per-user aggregates like maximum, sum, or average. This approach is supported for numeric properties and is designed to help you analyze the distribution in a way that fits your needs Custom Buckets - Numeric property Use Cases Insights Measurements.
If you want to see all values as-is (no bucketing), you can select "None" in the custom buckets modal. If you need to see exact values, you can also typecast the property to a string, which removes automatic bucketing Typecasting.
Summary: Yes, you can customize the size and range of buckets for the distribution of an aggregate property per user (such as maximum) using the Custom Buckets feature in Mixpanel Insights.
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.