User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
Table (Beta) Chart Options

If your Looker admin has enabled the Table (Beta) Labs feature, you can access an enhanced table visualization by choosing Table (Beta) from the Visualization bar.

Table (beta) charts offer the following enhancements to traditional Looker table charts:

Table (beta) charts accept any number of dimensions or measures, and up to 200 pivoted values.

Subtotals

The option to add subtotals to your table (beta) visualization appears on the Data bar when your data table contains at least two dimensions. Select the Subtotals checkbox and press Run. Subtotals only appear in the table visualization. They do not appear in the data table.

Subtotals are calculated for all dimensions other than the right-most dimension. To change the dimensions that are subtotaled, reorder the positions of the dimensions in your data table.

There are some things to keep in mind about how subtotals work:

Subtotals can be collapsed or expanded in the table (beta) visualization. See the Collapse Subtotal section for more information.

Dialect Support for Subtotals

The ability to use subtotals depends on the database dialect your Looker connection is using. In the most current Looker release, the following dialects support subtotals:

There are some things to keep in mind about dialect support for subtotals:

Column Menu Options

Table (beta) charts have a gear menu at the upper right of each column that provides options for freezing, copying, and resizing table columns as you view them. Changes to columns using the gear menu are not permanently saved. Use the Size Columns to Fit or Width options in the series menu if you’d like to save column sizing. Manually pin columns if you’d like to save column freezing.

Freeze

Clicking the Freeze option freezes a table column to the left side of the chart. The frozen column remains visible on the left side during horizontal scrolling. Multiple columns can be frozen.

To unfreeze a column, click the gear menu again and select Unfreeze.

Copy Values

Clicking Copy Values copies the column header and all the values in the column, which can then be pasted into a spreadsheet, text file, or Looker filter. You can also click on a cell or a range of cells within the visualization and copy the contents using the keyboard shortcuts Command-C (Mac) or Ctrl+C (Windows).

Autosize This Column

Clicking Autosize This Column sizes the width of the column to fit the column heading name or the longest data value, whichever is wider.

Autosize All Columns

Clicking Autosize All Columns sizes the widths of each columns to fit its column heading name or its longest data value, whichever is wider.

Size All Columns to Fit

Clicking Size All Columns to Fit sizes the widths of all columns so that the table perfectly fits the width of the pane in which you are viewing it.

Manually Moving and Pinning Columns

Clicking and dragging column headers in the table (beta) visualization allows you to move any column, including pivot groups and individual pivot columns, to any other location in the visualization. The order of the columns within the Data table will not change.

While you are clicking and dragging a column, if you approach the left edge of the visualization, a pin icon appears:

If you drop the column while the pin icon is present, the column will be pinned to the side of your visualization. The pinned column remains visible on the side during horizontal scrolling. Multiple columns can be pinned.

If you drag a column outside of the bounds of the visualization, an icon of a crossed-out eye appears:

If you drop the column while the eye icon is present, the column will not move from its original position.

Manually Resizing Columns

To manually resize columns, click the right border of the column header and drag it left or right. If resizing a column reduces the width of the table so that it is smaller than the width of the viewing pane, the first column will automatically grow wider to fill the pane. To prevent this, manually resize the first column to its desired width or set its width using the Width option in the series menu.

Plot Menu Options

Table Theme

Table Theme provides several table coloring options:

Show Row Numbers

Show Row Numbers toggles whether to show a row number at the beginning of each table row.

Show Row Numbers is disabled when you use subtotals in your table (beta) chart.

Transpose

The Transpose option is available for visualizations that contain only one dimension. When Transpose is selected, the visualizations rows will switch to columns and the columns will switch to rows.

Series Menu Options

The series menu controls how your chart shows each data series.

In a table (beta) chart, each column is listed in the series menu for customization.

Truncate Text

When Truncate Text is turned on, the text that appears in column headers and data cells will be truncated and followed by ellipses. When it is turned off, text inside data cells wraps to subsequent lines.

To view the full version of truncated or wrapped text inside a data cell, double click the interior of the cell; press escape or click outside of the cell to return to the truncated or wrapped version.

The default setting for Truncate Text is on.

Show Full Field Name

Show Full Field Name toggles whether to show the view name along with the field name for each column header. When Show Full Field Name is off, generally only the field name shows; however, measures of type count display only the view name instead.

Size Columns to Fit

Size Columns to Fit sizes the widths of all columns so that the table perfectly fits the width of the pane in which you are viewing it. Widths set using the Size Columns to Fit option are saved when you save your visualization as a Look or add it to a dashboard.

Customizations

The Customizations section allows you to customize each column in the visualization.

Label

The Label field lets you create a custom label for the column that will appear in the visualization.

Width

The Width field lets you set the width of the column by entering a number from 1 (narrowest) through 1,000 (widest). Widths set using the Width field are saved when you save your visualization as a Look or add it to a dashboard.

Format

The Format option appears for columns that contain numeric data. Using the drop-down menu, you can choose a predefined format or create a custom format for the values in that column. If you create a custom format, use Excel-style formatting as described on the Adding Custom Formatting to Numeric Fields documentation page.

Cell Text Layout

The formatting icons allow you to set the font color; background fill color; bold, italic, or underline font styling; and horizontal alignment for text inside the data cells for that column.

Customizing cell text layout is not available when the Bars option is set to on.

Column headers can be styled using the formatting menu.

Collapse Subtotal

The Collapse Subtotal option appears for columns that have subtotals. Enabling this option will collapse all subtotals for that column. The subtotals will remain collapsed when you save your visualization as a Look or add it to a dashboard.

You can collapse subtotals on individual cells by clicking the arrow on the left side of the cell, but those changes are not saved.

Bars

The Bars option appears for columns that contain numeric data. When this option is turned on, horizontal bar visualizations appear in the column cells, representing the value of the data in each cell. The bar length is plotted from the minimum data value (in which case no bar appears) to the maximum data value.

A color palette appears when the Bars option is enabled. The default color palette for the bar visualizations comes from the color collection selected in the Collection menu option. Clicking the palette allows you to select a different palette from the collection or create a custom palette by clicking the Custom tab on the palette picker that appears. The bar color reflects the data value from the minimum (left side of the palette) to the maximum (right side of the palette).

The Value Labels checkbox also appears when the Bars option is enabled. This checkbox toggles the appearance of value labels for each data point on a chart. Value Labels defaults to on.

If a column is pivoted by another series, bars are plotted for that column in each pivot group; and the minimum and maximum values are shared across the pivoted columns. If a series is used to pivot columns, bars are not available for that series, even if it contains numeric data.

The Bars option defaults to on for the first measure in the table (beta) visualization. For other columns with numeric data, it defaults to off.

Formatting Menu Options

Color Collection

Choosing a color collection from the Collection drop-down menu determines the palettes available for conditional formatting rules or cell visualizations.

A color collection allows you to create themed visualizations and dashboards that look good together. You can see all the palettes in each of Looker's built-in color collections on the Color Collections documentation page. Your Looker admin may also create a custom color collection for your organization.

Once you select the color collection, the palettes for any cell visualizations and the Palette section for each conditional formatting rule will update with a palette from that collection.

Row and Header Formatting

Rows allows you to set the font size for cell text between 1 and 99 points.

Header allows you to set the font size, text color, background fill color, and horizontal alignment for column headers. Header font size can range between 1 and 99 points.

Enable Conditional Formatting

Conditional formatting can be applied to table (beta) visualizations when subtotals are not present and the Bars feature is set to off. Turn on Enable Conditional Formatting to define rules that color code your table visualization, either on a scale or by specifying values that are of interest.

The image below shows a sample visualization where all values are colored on a scale, changing from red to yellow to green as the values scale from low to medium to high:

This second example shows a visualization where all values over 5,000 are highlighted and made bold:

Defining Formatting Rules

You specify how to color code your visualization in the Rules section:

When you first enable conditional formatting, there will be one rule, set to the default of color coding on a scale.

You can choose whether to apply a rule to all numeric fields in the visualization, or to apply the rule just to one or more fields using the Apply to box:

In the Format box, choose whether to color code values along a scale or based on a logical condition:

Color Coding on a Scale

If you are color coding values on a scale, click the color palette to choose your colors:

You can choose one of several existing palettes, or you can create a custom palette. To create a custom palette, click on the Custom tab of the palette picker. There you have several options:

In addition, if you are color coding values on a scale, you can use the following options to modify the color coding:

Color Coding Based on a Logical Condition

If you are color coding values based on a logical condition (in other words, using one of the Format options beginning with If value is), choose the Background Color, Font Color, and Font Style for values that meet the condition. By default, the background color is set to the first color of the categorical palette you have chosen for your conditional formatting rule.

Include Totals

If conditional formatting is enabled, Include Totals toggles whether totals are included in the color coding scheme.

Include Null Values as Zero

If conditional formatting is enabled, Include Null Values as Zero toggles whether null values should be represented as a zero.

Top