How to Display Average Daily Time Spent per User in Metrics Format

I'm trying to show the average time spent per user per day in the last 30 days. How can I show it in Metrics format? It is supposed to be 5.6 as in the table below. But after I change from Line chart to Metrics, it become time spent per user per month instead.

🎫1

1 comment

Thena
APP
·
·
Hi Yanisa- Julianne from Mixpanel Support here! I hate to be the bearer of bad news, but I'm afraid that this would be a product gap on our side. At the moment there is no way to view that exact value in metrics format. I'm sorry for this inconvenience. I've gone ahead and submitted a product gap on your behalf for the functionality. As some context, in the line chart view, Mixpanel calculates the number of unique users for each day (or the selected time granularity) and then calculates the average across all the days. On the other hand, in the metric view, Mixpanel looks at the entire date range as a single period and calculates unique users for that entire period. This leads to the behavior seen, where the average time spent per user per day in the last 30 daysis available in the table of the line chart, but not visible in the metric chart.