I have session event which has duration property (time spent in app). However, I can't find a way to get an overview of total time spent in app per day, and then an average time per user. Is it possible?
Best answer by michael
Michael from Mixpanel Support here.
In order to find the total or average of a specific numeric event property over time (such as duration) you will want to head into the Insights report.
There, in the report's dropdown, select the "properties" button next to the event that has your desired duration property.
Once you select the duration property, you will then have the option to choose one of multiple operators (total, average, median, min, max, etc) that you can then use to calculate the total time spent in the app, and average time per user.
Hope this helps!