how do I view a metric result in a table by week over 3 months?
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
To view a metric result in a table by week over 3 months in Mixpanel: 1. Select Your Metric in Insights: Go to the Insights report and choose or define the metric you want to analyze (e.g., event count, unique users, etc.) Insights: Visualize trends and compositions within your data.2. Set the Date Range: Use the date range selector to choose "Last 3 months" or set a custom 3-month range. This ensures your data covers the desired period Date Range.3. Set the Time Interval to Week: In the report settings, set the time interval to "Week." This will bucket your metric results by week within the selected date range.4. Change the Visualization to Table: In the chart type options, select "Table chart." This will display your weekly metric results in a tabular format Insights: Basic Features.This setup will show your metric broken down by week, displayed in a table, for the last 3 months. You can further sort or filter the table as needed.If you need more advanced breakdowns or want to analyze by different segments, use the breakdown and filter options available in the Insights report interface.
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 can't find where to set the time interval to week, is that in the 'breakdown' section?
Let me check the knowledge base for you again. One moment! 📚
No, setting the time interval to "week" is not done in the "breakdown" section. Instead, you adjust the time interval (such as day, week, or month) using the date and time controls in the report interface, typically near the date range selector or in the advanced submenu. The "breakdown" section is used to segment your data by properties or cohorts, not to set the time granularity.To set the time interval to "week," look for the time granularity or interval option in the report settings—this is separate from the breakdown feature. If you do not see this option, try checking the advanced date and time selectors in the Insights report or the report’s main settings area Reports Overview Query Builder Features.If you still cannot find the interval setting, it may be due to UI changes or permission restrictions, but it is not part of the breakdown section according to the documentation.
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.