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.
Selecting 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.
In the Funnels and Formulas reports, you can toggle between totals or uniques, while Retention queries can only be calculated using unique values.
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.
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.
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.
Along with total, unique, and average, Insights includes other data functions.
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: