I want to have a mixpanel report that has a widget with a metric. I want that metric to show static data from the last month - e.g. June 1 - June 30. Then when Aug starts, I want the metric to show static data from July 1 - July 31 (previous month). So, a rolling update of the previous month. Is this possible with Mixpanel?
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> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Yes, you can achieve this in Mixpanel by using the date range selector with a rolling window that always shows the previous full month.
To do this:
1. In your report, click on the date range selector. 2. Choose the Custom option. 3. Select the “Last” option and set it to “1 month”. 4. Use the + Ending button to shift the window back by 1 month.
This setup will always display data for the previous full month. For example, if it’s August, the report will show data from July 1 to July 31. When September starts, it will automatically update to show August 1 to August 31, and so on. This is a rolling date range, so the report will always reflect the previous calendar month without manual updates. If you save this report as a bookmark or add it to a dashboard, the date range will continue to update dynamically as described above Date Range.
If you want the data to remain static (not update) after the month ends, you would need to use the “Fixed” date range option and manually update it each month. But for your use case—a rolling previous month—the “Last 1 month, ending 1 month ago” configuration is the recommended approach.
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.
I get this message "change month to days to select the ending date", so I don't think this works for months. I just see the current month, not last month.
Let me check the knowledge base for you again. One moment! 📚
Thank you for pointing this out. According to the Mixpanel documentation, the + Ending button (which allows you to shift a rolling window back) is available for rolling date ranges, but the documentation specifically shows this for days, not months. The message you received—"change month to days to select the ending date"—indicates that shifting the window back is only supported for day-based ranges, not for months.
Therefore, based on the available documentation, Mixpanel does not currently support a dynamic, rolling "previous full month" date range out-of-the-box. If you want your report to always show the previous calendar month, you would need to manually update the date range at the start of each month using the "Fixed" date range option, selecting the exact start and end dates for the previous month Date Range.
I'm sorry, but there's no information in the knowledge sources indicating that Mixpanel supports an automatic rolling previous month window for reports.
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.
when I choose to view the widget as a line or column, I see the visual representation, and below it in the settings is a table, showing the values for June and July. But when I select to view the widget as a table, I only get the total amount for both months - how can I segment the values in the table to show for June and July so it's displayed in the report?
kapa.ai when I choose to view the widget as a line or column, I see the visual representation, and below it in the settings is a table, showing the values for June and July. But when I select to view the widget as a table, I only get the total amount for both months - how can I segment the values in the table to show for June and July so it's displayed in the report?
Let me check the knowledge base for you again. One moment! 📚
To display segmented values for June and July in the table view of your Mixpanel report, you need to break down your metric by Time and select the appropriate time granularity (e.g., Month). Here’s how you can do it:
1. In your report, click the Breakdown button. 2. Select the Time property. 3. Choose Month as the breakdown granularity.
This will segment your metric by month, so in the table view, you’ll see separate rows (or columns, depending on the configuration) for June and July, rather than just a total for both months. This approach works for both the visual chart and the table view, ensuring consistency in how your data is displayed Reports Overview.
If you do not apply a breakdown by time, the table view will only show the aggregate total for the selected date range, not the segmented values per month.
If you have already applied a time breakdown and still do not see the segmented values in the table view, please ensure you are not using a metric chart or a configuration that only supports totals, as some chart types aggregate the data by default Insights: Basic Features.
If you need to further customize the table (e.g., sorting, number of segments shown), you can use the sorting and "View N" controls described in the documentation Insights: Sorting.
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.
