To calculate how many users performed a given number of events (e.g., in buckets of 10) in the last 30 days in Mixpanel, you can use JQL (JavaScript Query Language) with the mixpanel.numeric_bucket() function. This function allows you to group users by the number of events they performed, bucketed into intervals (such as 0–9, 10–19, etc.).
Here’s an example JQL query that does this:
```
function main() {
return Events({
from_date: "2024-05-01", // set to 30 days ago
to_date: "2024-05-30", // set to today
event_selectors: [{event: "Your Event Name"}] // replace with your event
})
.groupByUser(mixpanel.reducer.count())
.groupBy(
[mixpanel.numeric_bucket('value', {bucket_size: 10, offset: 1})],
mixpanel.reducer.count()
);
}
LBKS- Replace `"Your Event Name"` with the event you want to analyze.
- Adjust the `from_date` and `to_date` as needed for your 30-day window.
This query will return the number of users in each bucket (e.g., how many users performed 1–10, 11–20, etc. events in the last 30 days) [Docs: JQL Builtins](https://docs.mixpanel.com/docs/reports/apps/jql#mixpanelnumeric_bucketaccessor-buckets-spec).
If you prefer to use the Mixpanel UI, you can use the Insights report with the "Frequency per User" measurement and select the "distribution" aggregation to visualize a similar breakdown, but the JQL approach gives you more control over bucket sizes [Docs: Insights Measurements](https://docs.mixpanel.com/docs/reports/insights#measurements).
