Use Data Functions in Mixpanel reports to find the total, unique, average, median, min, max, DAU, WAU, MAU, P99, and P99 for a data set. Most of the following functions are only available in the Insights report. Functions available in the Funnels and Retention reports are indicated in the table below.
Select Data Functions
Data Functions compute aggregate values of your event and property data, including totals, uniques, and averages.
In Insights, you can change the data function by selecting the dropdown that displays Total beside the event selector. When you first create an Insights report, the query will default to total.
Add an Aggregation by clicking on the three dots and selecting Add aggregation from the drop-down list, then selecting a property. The property you select will be typecast to a numerical property for the calculation.
Click on Sum to view the data functions available.
In the Funnels report, you can toggle between totals or uniques, while Retention queries can only be calculated using unique values.
Data Functions Table
| Function |
Event Calculation |
Property Calculation |
|
Total/Sum Insights Funnels |
Total count of [event] performed |
Total of [property value] across all events |
|
Unique Insights Funnels Retention |
Count of unique users performing [event] |
Unique count of [property value] across all events |
|
Average Insights |
Average count of [event] performed across all users |
Average [property value] across all events |
|
Median Insights |
Median count (middle number) of [event] performed across all users |
Median count (middle number) of [property values] across all events |
|
Min Insights |
Minimum count of [events] across all users |
Minimum of [property value] across all events |
|
Max Insights |
Maximum count of [events] across all users |
Maximum of [property value] across all events |
|
P90 Insights |
N/A |
90th percentile of [property value] across all events |
|
P99 Insights |
N/A |
99th percentile of [property value] across all events |
|
DAU/WAU/MAU Insights |
Daily Active User (DAU), Weekly Active User (WAU), or Monthly Active User (MAU) count of users performing [event] |
N/A |
Daily, Weekly, and Monthly Active Users
Daily Active Users (DAU)
Select DAU to calculate the number of unique users in the previous day (24-hour) period that have performed the selected event.
Weekly Active Users (WAU)
Select WAU to calculate the number of unique users in the previous week (7-day) period that have performed the selected event.
Monthly Active Users (MAU)
Select MAU to calculate the number of unique users in the previous month (30-day) period that have performed the selected event.
Note on DAU, WAU, and MAU calculations
If you select the DAU, WAU, or MAU 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). For example, today is April 25th, and it’s 4:22 PM. If you make a query to show WAU and you select “current day” as your date range, the query will return the count of unique users between April 19 at 12:00:00 AM and April 25 at 11:59:59.
DAU, WAU, and MAU functions are currently in BETA for all users and are subject to change.
Comments
Article is closed for comments.