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

This page describes the options for editing table visualizations in the visualization menu. This menu can be accessed by clicking the gear in the upper right corner of the visualization tab.

Some of the options listed below may be grayed out or hidden in situations where they would conflict with other settings you have chosen.

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.

Hide Totals

If your Explore includes column totals, Hide Totals toggles whether to show the totals in the visualization.

Hide Row Totals

If your Explore includes row totals, Hide Row Totals toggles whether to show the row totals in the visualization.

Limit Displayed Rows

Limit Displayed Rows enables you to show or hide rows in a visualization, based on their position in the results. For example, if your visualization was displaying a 7-day rolling average, you may want to hide the first 6 rows.

Click Limit Displayed Rows to toggle this feature on, then specify the following options:

In the Data section below your visualization, any excluded rows will be shown in a darker color, and will be marked with a symbol to the left of the row number:

This option is dependent on the row order, so changing the query's sort order or adding a row limit can change the rows that are shown or hidden in the visualization.

Series Menu Options

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

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

Truncate Column Names

Truncate Column Names determines whether column headers should be shortened with an ellipses (...). If you need to shorten column names, you can also turn off the Show Full Field Name option.

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.

Customizations

The Customizations section lists each column in the visualization and lets you create a custom label for that column in the Label box.

Tooltips for Table Columns

If the underlying data model defines a description for a field or measure, that description is displayed when you hover over the column name in a table chart visualization:

Formatting Menu Options

Enable Conditional Formatting

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:

Selecting a Color Collection

To set up your color coding, first choose a color collection from the Collection drop-down menu. A 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 Palette section for each rule will update with a palette from that collection.

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 including 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