Step-by-Step Guide to Display Daily Statistics for User Actions
Explain to me step by step how to display statistics per each day of the week, like how many users did a specific action on all Fridays compared to all Tuesdays in the last 180 days
Hi Ilya L., 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
I'll explain how to display statistics per each day of the week in Mixpanel, showing how many users performed a specific action on different days of the week (like comparing Fridays to Tuesdays) over the last 180 days.
Step-by-Step Guide to Analyze Day of Week Statistics in Mixpanel
Step 1: Open Insights Report
Start by creating a new Insights report, which is Mixpanel's flexible tool for visualizing trends and compositions in your data.
Step 2: Select Your Event
Choose the specific action (event) you want to analyze: 1. Click "Select Event" in the query builder 2. Find and select the event that represents the action you're interested in
Step 3: Set the Time Range
1. Set your date range to the last 180 days using the date picker in the top right
Step 4: Apply the Day of Week Breakdown
This is the key step to segment your data by day of the week: 1. Click the "Breakdown" button in the query builder 2. Search for and select "Time" as your breakdown property 3. When prompted for the time unit, select "Day of Week"As mentioned in the documentation, you can "break down your results by the 'Time' event property and break down by Hour, Day, Week, Month, Quarter, Year, Hour of Day, or Day of Week" Query Builder Features.
Step 5: Choose the Right Visualization
1. For comparing days of the week, a bar chart works well: - Click on the chart type selector (top right of the visualization area) - Select "Bar" or "Column" chart
Step 6: Analyze Your Results
The report will now show you: - A breakdown of your selected event by day of the week - Each bar representing the count of users who performed the action on that day of the week - You can easily compare metrics between different days (e.g., Fridays vs. Tuesdays)
Step 7: Refine Your Analysis (Optional)
You can further customize your analysis: 1. Change the measurement type from "Unique Users" to "Total Events" if you want to see total occurrences rather than unique users 2. Add filters to focus on specific user segments 3. Add additional breakdowns if you want to see day-of-week patterns across different user groupsThis approach will give you a clear visualization of how user behavior varies by day of the week across your entire 180-day period, making it easy to identify patterns like whether certain actions are more common on weekdays versus weekends, or specifically on Fridays compared to Tuesdays.
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.