--- title: "Multi-dimensional analysis with Data Tables" description: Build a custom analysis using multiple metrics in several different dimensions product: analytics token_estimate: 1719 --- # Multi-dimensional analysis with Data Tables > For AI agents: a documentation index is available at [/docs/llms.txt](/docs/llms.txt). Append `.md` to any page URL for markdown, or send `Accept: text/markdown`. Amplitude Data Tables compare multiple metrics across multiple dimensions in a single view. Use Data Tables when you need to compare metrics across dimensions. Use Event Segmentation instead when you need a time-series view of event behavior. Use Data Tables for: - Marketing [attribution](https://amplitude.com/docs/analytics/charts/data-tables/data-tables-attribute-credit) (total visits, page views, and conversion rate by UTM source) - Market segment analysis - Experiment analysis - Trend investigation - Comparing time periods across multiple metrics (metric A, metric B, and metric C, broken down by category, compared to last quarter) Sort columns in ascending or descending order by clicking the metric header, drag or resize columns, and highlight, copy, and paste any number of cells from your Data Table. > **Note:** Display limits > > When you apply group-bys, Data Tables display the top 100 results for a single group-by, or up to 500 results for multiple top-level group-bys. Metrics with attribution have a 20-row limit. These are display limits. Amplitude processes all your data but shows only the top results. Export limits vary by metric type. For complete details, review [Results limits and sorting logic in Data Tables charts](https://amplitude.com/docs/analytics/charts/data-tables/data-tables-results-and-sorting-logic). ## Plan availability Data Tables is available on all plans. Go to [Amplitude pricing](https://amplitude.com/pricing) for plan details. _Availability reflects the latest Amplitude plans. If your organization is on an older plan, your access may differ. Check your plan under [Plans & Billing in your organization settings](/docs/admin/account-management/account-settings#organizational-settings), or contact your Amplitude account representative._ ## Create a Data Table To create and use a Data Table: 1. Go to _Create > Chart > Data Table_. 2. In the empty Data Table panel, click **Add an event or metric** and select the event or metric you want. 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. You can [create a new metric](https://amplitude.com/docs/analytics/charts/data-tables/data-tables-create-metric) at this point if you need to. 3. To break out your events and metrics by property values, such as country, platform, or week, click **Select property…** in the leftmost column of the table and choose the property. 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. > **Note:** > > When you do a top-level group-by in a Data Table and include a Formula Metric, the results are consistent with measuring by a Formula in Event Segmentation and grouping by an Event property (as opposed to grouping by a Segment in Event Segmentation). 4. After you add a group-by property, run a secondary group-by on that row of your Data Table. For example, 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. > **Note:** > > When using a time dimension as a group-by property, the time dimension must be the last group-by you add: `group by: country`, then `group by: day of week`. Adding these group-bys in the reverse order doesn't generate correct results. 5. Add [user segments](https://amplitude.com/docs/analytics/charts/build-charts-add-user-segments) if you want. Saved segments are accessible. Multiple segments appear in the table as separate columns within the same metric. After you configure the data table, you can manage and manipulate your data in several ways. In any cell, click the Options icon to: - **Open as chart** to open a new tab with the chosen metric applied. - **Create cohort** to save the chart's data points as a [cohort](https://amplitude.com/docs/analytics/behavioral-cohorts). - **Copy** the data to paste elsewhere, or export the data as a CSV file. In any column header, click the Options icon to: - **Add Filter** to apply a filter to the chosen field. - **Duplicate** or **remove columns**. - **Rename** a column for clarity or consistency. > **Note:** > > To reset a display name to its original name, choose **Reset to Original Name** from the column's Options icon. - **Save as metric** to use the metric in other analyses. - **Attribution** to apply an [attribution model](https://amplitude.com/docs/analytics/charts/data-tables/data-tables-attribute-credit) to the chosen field or all fields. - **Sort** values from low to high (ascending) or high to low (descending). ### Use metrics in Data Tables In Data Tables, including a "-" character in any cell included in your formula's calculation results in an error. Using Uniques as a metric type in combination with group-bys can produce results that look counterintuitive. When you add a group-by to the event in the left column, the total sum for the event in the top row isn't a sum of the rows below. Because the event uses a group-by, 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 may be fewer than the sum of the rows below. 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 appears in the cell. When you add a group-by, the breakdown shows the conversion rate for each grouped value. For details on how Amplitude calculates the denominator for relative percentage of total, refer to [Calculate relative percentage of total](https://amplitude.com/docs/analytics/charts/data-tables/data-tables-create-metric#calculate-relative-percentage-of-total). ## Transpose rows and columns You can transpose columns and rows of a Data Table when: - you've toggled on a period over period comparison, - segments exist in your chart definition, - you've added top-level group-bys to your data table, or - time properties exist. Transposing isn't possible if: - nested group-bys exist, or - you've unchecked **Absolute numbers**. > **Note:** > > Transposed Data Tables don't support the display options **Relative % for totals**, **Data bars in cells**, or **Color % delta**. To transpose a Data Table: 1. Add events or metrics to the horizontal axis. 2. Add top-level group-bys to the vertical axis. 3. Change the **Columns** dropdown to rows to flip the axes. > **Note:** > > Transposed Data Tables are read-only.