Data Functions

Use Data Functions in Mixpanel reports to find the total, unique, average, max, median, min, DAU, WAU, or MAU for a data set. This article describes which functions are available in which reports.

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 function by selecting the dropdown that displays SHOW TOTAL above the event selector. When you first create an Insights report, the query will default to total.

data-functions-1.png

In the Funnels and Formulas reports, you can toggle between totals or uniques, while Retention queries can only be calculated using unique values.

Total

Select TOTAL to calculate the number of instances of the selected event performed in a given time range. For example, if 1 user performs an event 50 times, a total query will return a value of 50.

Unique

Select UNIQUE to calculate the number of distinct_id values that performed the selected event in a given time range. For example, if 1 user performs an event 50 times, a unique query will return a value of 1.

If you query an event by uniques, and segment by a property, Mixpanel will return the number of unique users per segment. Therefore, a user can show up in more than one segment.

Average

Select AVERAGE to calculate the average number of times a user performs an event. The average value is calculated by taking the total count of an event and dividing it by the number of unique users who performed that event.

View 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 18 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.

 

 

Example

User with distinct_id 123 fired Event A 50 times. User with distinct_id 456 fired Event A 100 times. User with distinct_id 789 fired Event A 300 times.

In Insights, you will see the following values in this example when looking at Event A for that day:

Total: 450

Unique: 3

Average: 150

Is this article helpful?
51 out of 77 found this helpful

Comments

0 comments

Article is closed for comments.