Mixpanel Community Icon

Home
Groups
Members

Announcements
Community Questions
Mixpanel Bot
Product Ideas
Resources

Community Guidelines

Docs & Guides
Events & Webinars
Contact Us

Powered by Tightknit

Creating a Line Graph for Daily Sum of App Opens | Mixpanel Community

Creating a Line Graph for Daily Sum of App Opens

·Aug 27, 2025 10:29 PM·

I have an event that has a field on it. Say users and appOpens. I want to see a line graph for the sum of all appOpens per day. I know how to graph the # of users, but not sure about the sum

2 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Hi Mark N., 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
kapa.ai
APP
·
·
Use Insights with the “Aggregate Property” measurement: - Select your event (e.g., “App Opened”). - Change the measurement from “Unique Users” to “Aggregate Property” → Sum. - Pick the numeric event property that holds the count (e.g., appOpens). - Set the time interval to Day to see a daily line chart.“Aggregate Property → Sum” totals a numeric property across all instances of the event for each time bucket (day/week/month) in Insights (Aggregate Property). You can also smooth or cumulate via Analysis Settings if needed (Analysis Settings).If you prefer the API, use the Query API “segmentation/sum” endpoint with on set to your property path (e.g., properties["appOpens"]) to get daily sums (Numerically Sum).
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.