Support Portal

Text and Tables - Table-Next (Beta) Chart

If your Analytics admin has enabled the Table-Next (Beta) Labs feature, you can access an enhanced table visualization by clicking the ellipsis (…) in the Visualization bar and choosing Table-Next (Beta).

Table-next charts offer the following enhancements to traditional Analytics table charts:

  • Subtotals
  • The ability to freeze, or pin, columns to the left side of the chart
  • The ability to resize column widths

Table-next charts accept any number of dimensions or measures, and up to 200 pivoted values.

Subtotals

The option to add subtotals to your table-next 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 that count unique items might not add up as you expect if the same item appears in several categories. In those cases, Analytics counts each item once rather than counting every duplicate appearance. Analytics calculates column totals in the same way.
  • Subtotals of table calculations that perform aggregations, such as calculations using percentile or mean, might not add up as you expect. This is because table calculations calculate subtotals using the other subtotal values, not using the values in the data column. For example, if you have two User Count subtotals of 30,500 and 24,312 and you have a table calculation such as mean(${users.count}), the table calculation will return 27,406 for both subtotal rows because it is performing the calculation (30500 + 24312)/2.
  • Subtotals are not available when you filter on a measure.
  • If your data table row limit cuts off your data table partway through a subtotal category, the entire category will be hidden from the table visualization.
  • Sorting occurs within each subtotal category independently.
  • When sorting by multiple columns, subtotal columns are given precedence.
  • Pivots will fail if you are using subtotals and the underlying result set contains more than 30,000 rows (regardless of any row limits you set in the data table)

Subtotals can be collapsed or expanded in the table-next visualization. See the Collapse Subtotal section for more information.

Column Menu Options

Table-next 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 you are viewing it in.

Manually Moving and Pinning Columns

Clicking and dragging column headers in the table-next 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:

  • 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 gray, and the text is black.

  • Gray: The table header is gray, the data rows alternate between white and light gray, and the text is dark gray.

  • Transparent: The table header is totally transparent, the data rows alternate between totally transparent and translucent gray, 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. On such a dashboard, the text color adapts to the background color, changing from black to white as needed. On the Explore page or in an embedded Look, the background is always white under the transparent visualization.

  • Unstyled: The entire table is white, the data rows are separated by gray lines, and the text is black.

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 using subtotals in your table-next 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-next 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 you are viewing it in. Widths set using the Size Columns to Fit option are saved when saving your visualization as a Look or adding 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 between 1 (narrowest) and 1,000 (widest). Widths set using the Width field are saved when saving your visualization as a Look or adding it to a dashboard.

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 saving your visualization as a Look or adding it to a dashboard.

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

Formatting Menu Options


Enable Conditional Formatting

Conditional formatting can be applied to table-next visualizations when subtotals are not present. 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 Analytics built-in color collections. Your Analytics 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.

  • 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 trash can icon in the top right corner of that rule section.

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:

  • 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.

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:

  • 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 mediumblue.
  • Use the color wheel to choose a custom color for the highlighted part of your color scale.

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

  • Select Reverse colors to apply the colors at the left end of the palette to values in the higher end of the data range and colors at the right end of the palette to values in the lower end of the data range.
  • Select Use X color steps to limit the number of colors used to the specified step value. When this option is not enabled, the data is colored on a gradient covering the entire palette spectrum. When this option is enabled, the data is then grouped and colored according to the number of color steps. For example, if you specify 5 color steps, the data is grouped into 5 equal buckets and the 5 colors applied, one color to each bucket of data. Valid color step numbers are from 2 to 100, inclusive.
  • Select Mirror range around center value to make equal color shifts on either side of the color palette. For example, on a scale from -100 to 0 to 100, values of -20 and a 20 will be the same color distance (10%) from the center color definition — 40% and 60% of the palette gradient respectively.
  • Use the Range fields to specify the values that determine the palette gradient start (0%), center (50%), and end (100%) colors. For the start and end colors, you can specify the minimum and maximum values in your data, specific numeric values, or percentile values. For the center value, you can specify the midpoint of the minimum and maximum data values, the data average, the data median, a specific numeric value, or a percentile value. For example, specifying start and end percentile values of 1% and 99% respectively, with a center value of 75%, causes the bottom half of the color gradient to apply to the lower 75% of your data values, and the upper half of the color gradient to apply to the top 25% of your data values.

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.