Setting Up Mixpanel to Limit Displayed Numbers in Insights Reports

In an Insights report, I'm returning a number from two dates. The numbers in theory have no upper limit, and Mixpanel is putting everything from 7 and above into one row. I want the maximum number to be 28, then anything 29> in a value.

2 comments

kapa.ai
APP
·
·
Hi Zoë E., 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
kapa.ai
APP
·
·
To address your specific need in an Insights report, you can use Mixpanel's Custom Buckets feature. This feature allows you to create custom ranges for numeric properties, which is perfect for your situation. Here's how you can set it up:1. In your Insights report, add a breakdown for the numeric property you're analyzing. 2. Click on the overflow menu (usually three dots or an ellipsis) next to the property name. 3. Select "Custom Buckets" from the menu. 4. In the Custom Buckets modal, choose "Varied Bucketing". 5. Enter your desired bucket ranges. In your case, you would create buckets for 0-6, 7-27, and 28+.Here's a more detailed explanation from the Mixpanel documentation:Custom Buckets explains how to use Varied Bucketing:1. Open the custom buckets modal 2. Since you're looking for specific buckets with varied bucket ranges, choose Varied Bucketing 3. Enter the 'segment' breakpoint values in each row and click apply. You can preview the bucket as you enter values in the line item below.For your specific case, you would enter: - 0 (this will create a 0-6 bucket) - 7 (this will create a 7-27 bucket) - 28 (this will create a 28+ bucket)This setup will give you the exact breakdown you're looking for, with everything from 0 to 6 in separate buckets, 7 to 27 grouped together, and 28 and above in the final bucket.Remember, Mixpanel will automatically generate both a lower-end and upper-end bucket to ensure your breakdown always adds up to 100%.By using this Custom Buckets feature, you can create the precise numeric ranges you need for your analysis, overcoming the default bucketing that Mixpanel applies to high-cardinality numeric properties.
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.