Table reference

Tables display your data in a grid of rows and columns. Each column represents a dimension or metric, while each row is one record of your data.

Learn how to add charts to your reports.

In this article:

• Tables in Looker Studio
• Table examples
• Configure the chart
  • Set up the chart data
  • Stylize the chart
• Limits of tables
• Related resources

Tables in Looker Studio

Tables in Looker Studio automatically group your data. Each row in the table displays the unique combination of all the dimensions included in the table definition. Each metric in the table is aggregated according to the aggregation type for that metric (sum, average, count, etc.).

Table examples

Here is some sales data for a fictional pet store. The store sells items for dogs, cats, and birds, with several products in each category.

A simple Looker Studio table showing just the category dimension and quantity metric looks like this:

Example table 1

In example 1, Looker Studio has aggregated the quantities sold per category. Since there are only 3 categories in the data set, the table shows just 3 rows.

Now let's add the Item dimension to the table:

Example table 2

In example 2, the table contains 6 rows, 1 for each item. The quantity sold metric is now aggregated per item.

Add a table to your report

To add a table to a report:

1. Edit your report.
2. At the top, click Add a chart.
3. Select a default table style.
   1. For example, you can add a standard table, a table where the metrics are displayed as bars, or a table with a heatmap applied.
4. Drag the chart to the desired location on the page and resize it to the desired dimensions.
5. Use the properties panel on the right to add metrics and dimensions and to style the table.

Adjust column size

To manually change the size of individual columns in the table, click a column divider and drag it. To resize multiple columns at once, hold the Shift key while dragging a column divider.

To apply automated column resizing, right-click the table, then select one of the Resize columns option:

• Fit to data sizes each column in the table to the optimum width according to the data.
• Distribute evenly makes all the columns equal width.

Watch a demonstration of resizing table columns

Show summary row

The Show summary row option toggles the display of a row at the bottom of a table that summarizes each metric column.

Sort your data

Viewers of your reports can sort the data by clicking on a column header. Each click reverses the sort order. For example, click once to sort in ascending (lowest to highest) order, and click again to sort in descending (highest to lowest) order. Viewers can still sort the chart even if the editor has defined a default sort.

If a viewer changes the sort order of a chart, and that chart was sorted by a metric not displayed in the chart, refreshing the page restores the default sorting.

When a secondary sort field is selected, the primary and secondary sort fields are numbered in the table 1 and 2, respectively. Sorting by any other field (by clicking the field name in the table header) removes the primary and secondary sorts.

Ignore canvas filters in summary row

When the Ignore canvas filters in summary row option is enabled, the summary row displays a complete total, ignoring any viewer-applied filters, such as controls. The total row still includes filter properties.

Limits of tables

The number of dimensions and metrics you can add depends on the data source used by that table:

• Tables based on "fixed schema" data sources, such as Google Analytics, Google Ads, Display & Video 360, and other Google marketing products data sources can have up to 10 dimensions and 20 metrics.
• Tables based on "flexible schema" data sources, such as Google Sheets, BigQuery, and SQL databases can have up to 100 dimensions and 100 metrics.

Related resources