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 provides several table coloring options:
Classic - The table appears as it does in the Data section, with blue dimensions, orange measures, and green table calculations.
White - The table header is white, the data rows alternate between white and grey, and the text is black.
Gray - The table header is grey, the data rows alternate between white and light grey, and the text is dark grey.
Transparent - The table header is totally transparent, the data rows alternate between totally transparent and transparent grey, and the text adjusts itself in color. This can be useful when using a customized, embedded dashboard so that the tile background color shows through the visualization. The text color adapts to the background color, changing from black to white as needed. On the Explore page or an embedded look the background is always white under the transparent visualization.
Show Row Numbers
Show Row Numbers toggles whether to show a row number at the beginning of each table row.
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:
- Hide or Show: Choose Hide to exclude certain rows from the visualization. Choose Show to display only a limited number of rows in the visualization.
- First or Last: Choose if the rows to be hidden or shown will be the first or last rows in the result set.
- Number: Specify the number of rows to be hidden or shown.
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 toggles whether column headers should be shortened with an ellipses (
...). If you need to shorten column names, you may also want to consider using the Full Field Name setting.
Show Full Field Name
Full Field Name toggles whether to show the view name along with the field name for each column header.
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
Set Enable Conditional Formatting to ON 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:
You specify how to color code your visualization in the Rule section:
When you first enable conditional formatting, there will be one rule, set to the default of color coding on a scale.
- To add an additional rule, click Add Rule.
- If you have more than one rule, the rules higher on the list have precedence over rules lower on the list. To change the precedence of a rule, click on the three horizontal bars at the top left of that rule and drag the rule higher or lower in the list.
- To delete a rule, click on the X in the top right corner of that rule section.
In the Format box, choose whether to color code values along a scale or based on a logical condition:
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:
- Add or remove colors from the scale by clicking the + or - buttons. You can have a maximum of 5 and a minimum of 2 colors on your scale.
- Edit all the colors of the scale by clicking Edit All and entering RGB hex strings, such as
#2ca6cd, or CSS color names, such as
- Use the color wheel to choose a custom color for the highlighted part of your color scale.
If you are color coding values based on a logical condition, choose the Background Color, Font Color, and Font Style for values that meet the condition:
You can also 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:
If you choose All numeric fields, the conditional formatting rule will be applied to every value in all of the numeric fields in the visualization. If you are color coding values on a scale, the scale will include all numeric values, even if the values in different columns are unrelated.
If you choose Select fields, Looker displays a box that lets you select the fields where you want to apply the rule. If you enter text in the box, Looker lists only the fields that include that text.
Select the field or fields where you want to apply the rule, and the conditional formatting will be applied only to the values in those fields.
The example below shows two numerical fields. The first rule, which applies a red background color to any value below 45, applies only to the Average Sale Price field. The second rule, which color codes on a scale from red to green, applies only to the Order Count field:
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.