Group-bys: How Amplitude prunes and orders chart results

Feature Experiment Web Experiment

SDKs APIs

Find the right chart for your analysis Chart basics in Amplitude Build charts in Amplitude: Add events Build charts in Amplitude: Add user segments Build charts in Amplitude: Modify a user segment Microscope: Explore individual data points in your charts Event Explorer: View event streams in real time Review chart data with the breakdown table Customize your chart's colors Charts

Identify users with similar behaviors

Define a new cohort

Compare and manage your behavioral cohorts

Create cohorts with Microscope, file import, or the Segmentation module

Track changes in your cohort populations over time

Historical Count, part 1: Track user behavior for different instances of each user action

Historical Count, part 2: Order of operations

Historical Count, part 3: Funnels and behavioral cohorts

Customize the Home page Search: Find charts, dashboards, cohorts, and notebooks Workspace: Find your charts and track your work Bulk manage charts with Chart Cleanup Releases: See how users respond to changes in your product

Create, edit, and manage dashboards

Filter your dashboards

Change your dashboard's display preferences

Turn your dashboard into a template

Subscribe to a dashboard

Collaborate on your analyses using spaces Notebooks: Explain important insights to teammates and stakeholders Templates: Re-use your analyses Out-of-the-box Marketing Analytics Out-of-the-box Product Analytics Out-of-the-box Metrics

Share dashboards within your company Share charts, dashboards, and notebooks with stakeholders outside your company Use Atlassian Smart Links with Amplitude Embed Amplitude charts in Notion documents Integrate Miro with Amplitude Integrate Slack with Amplitude Sync your Amplitude data to Google Drive and Sheets

Account-level reporting in Amplitude Plan your Accounts Instrumentation Set up account-level reporting

Anomaly + Forecast: Find anomalies in your data Insights: Spot anomalies in your metrics quickly with alerts Root Cause Analysis: Track down anomalies in your data Debug Analytics Use Domain Proxy to Relay Events Look up event data for individual users

Use sessions, channels, and attribution to drive marketing analytics

Ask Amplitude

Analytics

Charts

Group-bys: How Amplitude prunes and orders chart results

This article helps you:

Understand when and why Amplitude Analytics truncates group-by query results
Understand how Amplitude Analytics prioritizes group-by results

In its basic form, Amplitude's group-by feature is a tool for categorizing events for aggregation.

For example, when you want to count the number of events by country, you'd use a group-by:

Check out this article for a more detailed look at group-by visualization in Amplitude's Event Segmentation charts.

Group-by result limits

For performance purposes, Amplitude sets a maximum limit on the number of groups a query result can return. When this limit is exceeded, the top groups are kept, while the rest are pruned from the query result. The top groups are determined in accordance with the table below.

With a single group-by in the Event Segmentation chart, results may be limited to 100 group-by results. For double group-bys, results may be limited to 500 group by results, in which each group by value pair is counted as a single result.

See this article for more details about limits in Amplitude.

Group ordering

This table shows how Amplitude prioritizes group-bys for display in the Breakdown Table:


Metric	Ordering
Uniques	Number of unique users
Totals	Total number of events
% Active	Number of unique users
Average	Total number of events
Frequency	Number of unique users
Distribution of Property Value	Total number of events
Sum of Property Value	Sum of property values
Average of Property Value	Sum of property values
Distinct Property Values Per User	Total number of (user, property value) pairs
Formulas: Percentile	Total number of events
Formulas: Frequency Percentile	Total number of events
Formulas: Property Count	Number of unique properties
Formulas: Property Count Average	Total number of (user, property) pairs
Formulas: Default	Number of unique users

Formulas with group ordering

For formulas without a group-by, this ordering is only used if every metric in the formula uses the same ordering. Otherwise, Amplitude uses the default formulas ordering.

For formulas with a group-by, Amplitude ranks the groups by the largest overall values per group summed across all formulas in a single expression.

Note

If group-by pruning occurs with multiple formula terms combined with operators, formulas may take longer to load because Amplitude runs additional queries to make sure that all formula terms are querying the same groups.

Was this page helpful?

July 5th, 2024

Need help? Contact Support

Visit Amplitude.com

Have a look at the Amplitude Blog

Learn more at Amplitude Academy