Data Functions

Use Data Functions in Mixpanel reports to find the total, unique, average, median, min, max, DAU, WAU, MAU, P25, P75, P90, 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.

Screen_Shot_2019-10-17_at_11.27.36_AM.png

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]	N/A
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
P25 Insights	25th percentile of [events count] across all users	25th percentile of [property value] across all events
P75 Insights	75th percentile of [events count] across all users	75th percentile of [property value] across all events
P90 Insights	90th percentile of [events count] across all users	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.