How to Remove Buckets from Frequency Distribution and Exclude Breakdown in Event Data?
Query: Frequency Distribution of event. Distribution is in buckets. How can I remove buckets. Exclude breakdown
Query: Frequency Distribution of event. Distribution is in buckets. How can I remove buckets. Exclude breakdown
To remove bucketing and see exact numeric values in a frequency distribution breakdown in Mixpanel Insights, you have two options:
Option 1: Disable Bucketing via Custom Buckets
Open the Custom Buckets modal from the overflow menu (the ... icon) on your numeric breakdown property.
Select None â this disables bucketing and displays all numeric property values as-is, without grouping them into ranges.
Option 2: Typecast the Property to a String
If you want to see exact numeric values, you can typecast the numeric property to a String type. This removes the automatic range bucketing that Mixpanel applies to numeric properties.
To do this, click the "Data Type" option in the overflow menu for the property breakdown and change it to String.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Based on the knowledge sources, here is what Mixpanel documents about Frequency per User as a measurement in Insights (events):
Frequency per User (Events Measurement)
In the Insights report, Frequency per User is available as a measurement under the Events calculation group. It is described as:
"The number of events performed per user. Example: How many videos were watched per user?"
Aggregation options available:
Average
Distribution
Median
Percentiles (P25, P75, P90, P99)
Minimum
Maximum
The default aggregation is Average, but you can click on it to switch to Distribution (which is what produces the bucketed view you're seeing). [Insights Measurements]
How "Per User" calculations work
Frequency per User first calculates the value per user, which then becomes useful when you apply an aggregation on top of that calculation. Selecting Distribution as the aggregation shows how users are spread across different frequency ranges. [Insights Measurements]
Behavioral Properties context
Frequency per User is also available as a Computed Property (labeled with a 'Computed' tag in the query builder). It allows you to segment users by how many times they performed an event, or filter to only users who did an event a certain number of times. [Computed Properties]
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.