kapa.ai I’m trying to analyze a long-term trend in my data using the Insights report. To do this, I would like to apply a rolling average (or data smoothing) to my line chart to smooth out the weekly fluctuations. I have looked for this option in the chart type settings (under the “Line” chart dropdown) and also in the “Chart” settings tab next to the “Query” tab, but I couldn’t find the feature. Could you please guide me on where to find the rolling average setting in the current user interface?
Please stand by Chansol L. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
You’ll find Rolling Average in the measurement’s Advanced settings—not in the chart type or Chart tab.How to access it: - In your Insights report, click the measurement selector (e.g., “Unique Users”), then open the Advanced section. - Enable Rolling Average and choose the window (Mixpanel defaults to a 7-interval rolling average based on your selected time interval). This smooths the line chart over time (Analysis Settings).
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.
but what i am tracking is calculted by a formula tho kapa.ai
Let me check the knowledge base for you again. One moment! 📚
Yes—you can still apply Rolling Average when your metric is a Formula. Rolling Average is set on the metric’s measurement via Advanced settings, and it smooths whatever series the metric outputs (including formulas). Open the metric’s measurement menu and enable Rolling Average there; Mixpanel uses a rolling window based on your chosen time interval (defaults to 7 intervals) (Analysis Settings). Note: You can’t nest a formula inside another formula, but that doesn’t affect applying Rolling Average to a formula metric (Advanced / Formulas).
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.
