how do I create a mixpanel table arranged by month

Hi Stevan V., 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> 👋

To create a Mixpanel table arranged by month, you can use the grouping or breakdown features in Mixpanel reports. Specifically, in the Insights report, you can break down your results by the “Time” event property and select "Month" as the granularity. This will arrange your data into monthly buckets, displaying metrics (such as event counts or unique users) for each month.Here’s how you can do it: 1. Open an Insights report. 2. Add the event(s) you want to analyze. 3. Click the Breakdown button. 4. Select the “Time” property and choose "Month" as the breakdown interval.Alternatively, if you are using JQL (JavaScript Query Language), you can use the built-in mixpanel.numeric_bucket() function with mixpanel.monthly_time_buckets to group events by calendar month. Here’s an example JQL query: LBKSfunction main() { return Events({ from_date: "2016-01-01", to_date: "2016-06-30", }).groupBy([ mixpanel.numeric_bucket('time', mixpanel.monthly_time_buckets) ], mixpanel.reducer.count()); }LBKSThis query will return a count of events grouped by each calendar month in the specified date range Docs: JQL Builtins - numeric_bucket.If you are exporting data to a warehouse like BigQuery, you can also use SQL to group by month using the appropriate date functions on the event timestamp column Docs: Schematized BigQuery Pipeline - Queries.Let me know if you need steps for a specific Mixpanel interface or export method!

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.