Filter and breakdown are options that exist across Mixpanel reports, including:
Filter allows you to decide which event data to include in your analysis, either in the query builder or in the results. You can filter by event properties, user profile properties, group profile properties, and cohorts.
Breakdown allows you to group event data in the report results. You can breakdown by event properties, user profile properties, group profile properties, and cohorts.
Filter Query Input
When building an Insights, Funnels, or Impact report you can choose to add a filter to limit the property values that are included in the report.
Add a filter to your query by clicking on the … icon beside an event, profile, cohort, or step.
Then, select a property from the drop down list that appears and specify which values to filter.
In Funnels, filtering a step by a particular property will limit the data you see in the funnel to events with that property value.
You can choose multiple property filters for each item in your query.
Free Mixpanel plans can only apply up to two filters, while paid Mixpanel plans can apply as many filters as they like.
You can select whether you would like the user to match any of these filters, or all of the filters by clicking on and/or beside the filters.
Filter Query Results
When building an Insights, Funnels, Flows, or Impact report you can choose to filter the entire report by properties or cohorts by clicking the Filter button at the bottom of the report. This will filter the results of the entire report to show only data with that property or cohort.
Breakdown groups the results of your Insights, Funnels, Flows, or Retention report by a property or cohort, allowing you to examine which properties or cohorts have a significant impact on your query.
This feature is useful for determining if a group factor, such as browser type, is having an impact on the way users interact with your product. Breakdown will display counts, such as the number of events performed or the conversion rates with that property value.
Select the Breakdown button below the query builder, and select the property or cohort you want to breakdown your results by.
For cohorts, you will be shown groups of users both in and not in the cohort in your results.
It is only possible to either group by properties or group by cohorts, but not both.
Note that in Retention this button is called Segment.
For more information on how to interpret these results, view the following articles: