Review chart data with the breakdown table

Sometimes visualizing data in a chart isn't enough for all analyses. To review, interact with, and export the data that makes up your charts in Amplitude Analytics, use the breakdown table, which appears below your chart.

Some charts—including Data Tables, Personas, Pathfinder, Pathfinder Users, Compass, and Experiment Results—don't have a breakdown table.

Sort your table's fields

The columns, or fields, in your breakdown table depend on multiple factors, such as:

• The type of chart you use for analysis.
• The type and number of events.
• The type of measurement.
• Whether you use segment or group-by properties.

Some columns in your breakdown table are fixed. A fixed column appears at the far left, highlighted in blue, and Amplitude adds or appends it depending on your analysis. For example, adding an additional event, segment, or segment group-by creates a new fixed column, but adding an additional group-by to an event only appends the event's group-by fixed column. Resize a fixed column by dragging the divider between the columns to the right or the left.

Click a column name in your breakdown table to sort the column in descending or ascending order.

Change the summary column

Some charts, such as Segmentation and User Sessions charts, include a summary column. Modify the summary column by choosing a row aggregate in the dropdown menu. Select from average, median, change (first row minus last row values), or sum (available only for event totals, properties, and formulas).

Set the number of series to display

Each breakdown table interacts with your charts, and vice versa. A change to the breakdown table, such as clicking the checkbox by a row name, modifies the chart by removing the unclicked series. Clicking checkboxes near the far-left field name selects or unselects all rows, and modifies the chart by adding or removing all data.

Modify the table breakdown

Select the specific number of series or rows you want to display in your breakdown table. Click the Breakdown by: dropdown to choose a default or enter a numerical value between 1-30. As long as it's saved, the Breakdown by: selection persists through sorting and refreshing, and applies to any dashboards that include your chart. When Amplitude receives new data, the top values or events update automatically.

To turn off a Breakdown by: selection, ensure only the values and events you want to keep maintain a checkmark. Your Breakdown table then notes that only a specific number are selected. Turn it back on by clicking the Reset to top... hyperlink.

Export to .CSV

Click to export your breakdown table as a .CSV file. There are .CSV download limits that depend on the type of chart and group-by in use.

Search for values

Use the search bar to search for any values in your breakdown table. Searches start automatically once you enter a value, and update when you modify or remove the value. A search result doesn't impact the chart or the data you can export.