Table reference

How to use and configure tables.

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.

In this article:

Tables in Data Studio

Tables in Data Studio automatically summarize your data. Each row in the table displays the summary for each unique combination of the dimensions included in the table definition. Each metric in the table is summarized according to the aggregation type for that metric (sum, average, count, etc.). A Data Studio table can have up to 10 dimensions and 20 metrics.

Example:

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.

Date Item Category Qty Sold

10/1/2016

Happy Cat Catnip Cat 1

10/1/2016

Healthy Dog Dog Food Dog 3

10/1/2016

Pretty Bird Bird Seed Bird 5

10/2/2016

Pretty Bird Bird Seed Bird 3

10/2/2016

Happy Cat Catnip Cat 2

10/3/2016

Playful Puppy Toy Dog 6

10/5/2016

Pretty Bird Bird Seed Bird 7

Data continues...

... ... ...

 

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

Category Qty Sold
Bird 28
Dog 27
Cat 12

Example table 1

In example 1, Data 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:

Category Item Qty Sold
Bird Pretty Bird Bird Seed 20
Dog Healthy Dog Dog Food 17
Dog Playful Puppy Toy 10
Bird Parrot Perch 8
Cat Happy Cat Catnip

4

Cat Hungry Kitty Cat Food 3

Example table 2

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

The metric's aggregation type depends on how the data source is configured. Learn how to change a metric's aggregation type.

Add a table to your report

To add a table to a report:

  1. Edit the 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.

You can also apply automated column resizing:

  • Right-click the table, then select 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.
You can also simply double-click on a column divider to apply the Fit to data option.

Watch a demonstration of resizing table columns

Demonstration of column resizing

Data options

The options in a table's DATA properties panel affect how the data is organized and displayed.

Dimension and metrics

Add columns to the table by dragging fields from the Available Fields panel on the right. You can also click Add dimension or Add metric in the Data tab. 

Tables can have up to 10 metrics. The number of dimensions you can add depends on the data source used by that table. Tables using the following connectors can have up to 20 dimensions:

  • Google Sheets
  • Google BigQuery
  • File Import
  • Google Cloud Storage
  • Extracted data sources
  • Blended data views  

Tables based on other data sources can have up to 10 dimensions.

Sort your data

Viewers of your reports can sort the data by clicking on a column header. Each click reverses the sort order: e.g., click once to sort in ascending (lowest to highest) order, click again to sort in descending (highest to lowest) order. In the example above, the table is sorted by Qty Sold in descending 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.

Set the default sort

The Sort and Secondary sort options in the chart's DATA properties panel control the default sorting behavior. You can select any metric in the chart's data source, or any dimension currently displayed in the chart, to use as the primary or secondary sorting field.

The Secondary sort option only appears when there is an appropriate combination of dimensions and metrics in the chart.
When specifying a metric as a sort field, you can edit the field's aggregation. For example, you could include a numeric field in the chart as a SUM, but sort on that same field's AVERAGE value.
 

Rows per page

Use the Rows per page option to control how many table rows to display per table page. Show pagination must be enabled for this to take effect.

Show summary row

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

Style options

The options in a table's STYLE properties panel controls the presentation and appearance of the table overall.

Table Header

These options control the appearance of the table header and column labels.

Show header Shows or hides the table header. Note that viewers can't sort tables with hidden headers.
Wrap text Wraps header text.
Header font color Sets the font color of the table header.
Header font size Sets the font size of the table header.
Header font family Sets the font family of the table header.

Table Colors

These options control the colors of the table borders and cells.

Header background color Sets the color of the table header background.
Cell border color Sets the color of the border between rows.
Odd/Even row color Sets the color of odd or even rows in the table.

Table Labels

These options control the appearance of the table data.

Font color Sets the font color of the data.
Font size Sets the font size of the data.
Font family Sets the font family of the data.

Table Body

These options control the appearance of the table body.

Row numbers Adds row numbering as the leftmost column of the table.
Wrap text Wraps long text in the table body.

These options control the appearance of the table footer.

Show pagination Pagination lets the viewer navigate through long tables. Show or hide the page controls with this option.
Compact pagination Reduces the vertical spacing of the pagination controls.
Footer border color Sets the footer border color.
Footer border weight Sets the thickness of the footer border.
Footer border style Sets the line style of the footer border.

Missing data

This option controls how to display missing values. For example, when data is missing from the table, you can choose to show blanks, hyphens, or the words "no data."

Dimension and metric appearance

These options control the display of your dimension and metric columns. Each column in your table has a corresponding numbered section in the properties panel: from left to right, the first metric in the table is Column #1, the second metric is Column #2, and so on. You can set the following options for each column:

Number display

  • Number - displays the metric value "as is."
  • Heatmap - displays the metric value with a colored background, the intensity of which shows how that value compares to the other values in that column.
  • Bar - displays the metric value as a horizontal bar. You can change the bar color and include the numeric value, as well, if desired.
Alignment Aligns the data in the column left, right, or center.
Compact Numbers Rounds numbers and displays the unit indicator. E.g., 553,939 becomes 553.9K.
Decimal Precision Sets the number of decimal places in metric values.
Show target Appears when the column type is set to Bar. Shows a target line for the value set in the target value field, similar to a bullet chart.
Show axis Displays an X-axis for the bar chart.

Common styling options

All charts let you style certain common options:

Background and Border

These options control the appearance of the chart background container. 

Background Sets the chart background color.
Border Radius Adds rounded borders to the chart background. When the radius is 0, the background shape has 90° corners. Border radius of 100° produces a circular shape.
Opacity Sets the chart's opacity. 100% opacity completely hides objects behind the chart. 0% opacity makes the chart invisible.
Border Color Sets the chart border color.
Border Weight Sets the chart border line thickness.
Border Style Sets the chart border line style.
Add border shadow Adds a shadow to the chart lower and right borders.
ข้อมูลนี้มีประโยชน์ไหม
เราจะปรับปรุงได้อย่างไร