Data Functions

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. 

InsightsBuild4.png

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.

Sep-30-2019_13-42-53.gif

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]

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

 

Is this article helpful?

Comments

0 comments

Article is closed for comments.