How to get Average DAU of past 7 days

Hi Abhijeet S., 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 get the Average Daily Active Users (DAU) for the past 7 days in Mixpanel, you can follow these steps: 1. Navigate to the Insights report in Mixpanel 2. Set up your query to measure "Unique Users" 3. From the measurement dropdown, click on the advanced options (> arrow) and select "Daily Active Users (DAU)" 4. Set your date range to "Last 7 days" using the date range selector 5. Choose "Line" visualization to see the DAU trend over timeIf you want to see the average of these 7 days as a single number, you can use the "Rolling Average" analysis setting: 1. Go to the advanced section of the measurement menu 2. Select "Rolling Average" as your analysis setting 3. This will calculate the rolling average of your DAU valuesAccording to the documentation, DAU measures "the number of users who performed [event] within the last 24 hours" Mixpanel Insights Measurements.For a more detailed breakdown of your active users, you might also consider looking at the stickiness metrics like the DAU/MAU ratio, which helps measure how frequently users engage with your product MAU, WAU, and DAU Blog.Remember that when you select the DAU function for a date range that includes the current day, the query will take the end of the current day as the end of the query's time segment, even though it's in the future.I hope this helps you analyze your user engagement patterns!

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