This article helps you:
Build a custom analysis using multiple metrics in several different dimensions
Analyze Multiple Metrics at Once with Data Tables
Learn how to do multi-dimensional analysis with Data Tables.
Learn Data TablesWhen analyzing a rich dataset, analysts often need to compare multiple metrics at once, and slice and dice that data by different dimensions to generate a custom analysis. Amplitude’s Data Tables enable multi-metric, multi-dimensional analyses in a single view.
Data Tables are useful for:
Sort columns in ascending or descending order (just click the metric header), drag or resize columns, and highlight, copy and paste any number of cells from your Data Table.
For more information, see Results limits and sorting logic in Data Tables charts.
To create and use a Data Table, follow these steps:
Navigate to Create > Chart > Data Table.
In the empty Data Table panel, click Add an event or metric and select the event or metric you’re interested in. A new Data Table opens, with your chosen event or metric in the first column. Add more by clicking + Add Event or Metric in the rightmost column in the Data Table.
You can create a new metric at this point, if you need to.
To break out your events and metrics by property values—country, for example, or platform, or week—click Select property… in the leftmost column of the table and choose the property you’re interested in.
This runs a group-by on your events and metrics, grouping by the property you selected. You can include up to five top-level group-bys in a single Data Table.
After you add group-by property, you can run a secondary group-by on that row of your Data Table. For example, you can break your events and metrics out by the Day of Week
property nested within Country
.
Click the Bar icon in the rightmost group-by column and select the property you’re interested in.
group by: country
, then group by: day of week
. Adding these group-bys in the reverse order doesn't generate correct results.Next, add user segments, if desired. Saved segments are accessible. Multiple segments show up in the table as separate columns within the same metric.
When you're done configuring the data table, there are several options you can use to manage and manipulate your data.
Within any cell, click the Options icon to:
Within any column header, click the Options icon to:
With Data Tables, including a "-" character in any cells included in your formula's calculation results in an error.
Sometimes, using Uniques as a metric type in combination with group-bys can generate results that appear counterintuitive at first. For example, when you add a group-by to the event in the left column, the total sum for the event (as seen on the top row) isn't a sum of each of the rows below. Because there's a group-by applied to the event, the same user can exist in multiple rows.
The same logic applies to the Session Totals metric. When you add a group-by in the left column, the total number of sessions in the top row can be fewer than the sum of the rows below. This is because the chart counts a session containing property values X and Y under both X and Y groups.
When you add conversion metrics to your data table, the conversion rate displays in the cell. When you add a group-by, the breakdown displays the conversion rate for each grouped value.
You can transpose columns and rows of a Data Table when:
Transposing isn't possible if:
To transpose a Data Table, follow these steps:
April 1st, 2025
Need help? Contact Support
Visit Amplitude.com
Have a look at the Amplitude Blog
Learn more at Amplitude Academy
© 2025 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.