User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
日本語
Area Chart Options

This page describes the options for editing area charts 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

Series Positioning

Series Positioning specifies how series are clustered visually on a chart. The following options are available. Not all options apply to all chart types.

Grid Layout

New in Looker 6.6, you can split a chart into small multiples with the Grid Layout option.

Grid Layout provides options to separate, or trellis, a chart into several smaller charts, each representing a single row or pivot from the results table.

You can separate a chart into a maximum of 12 smaller charts. If you have more than 12 rows or pivots, limit your data by using the Row Limit, Column Limit, or Limit Displayed Rows options.

Once you select By Pivot or By Row from the drop-down menu, the Number of Charts per Row option appears. You can input a number between 1 and 12.

Line Interpolation

Line Interpolation specifies how lines are drawn on the chart. The following options are available:

Plot Null Values

Plot Null Values toggles the appearance of null values on the chart. When ON, null values are plotted at zero. When OFF, sections of line and area charts may show gaps. This parameter is only available when Series Positioning is Overlay.

Swap X and Y

Swap X and Y toggles whether the x and y axes are swapped from the normal configuration. When swapped, dimensions will be plotted on the y-axis, and measures will be plotted on the x-axis.

Hide Legend

Hide Legend toggles the appearance of the series legend on a chart. This is only available when there is more than one series (except in the case of a pie chart).

Legend Align

Legend Align specifies whether the series legend will appear to the left, center, or right of the chart. This is only available when Hide Legend is OFF, and when there is more than one series.

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.

Colors

You can define the color palette for a chart in the Colors section.

Collection

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 will update with a palette from that collection.

Palette

Once you've selected a color collection, you can choose a different palette from the collection, or customize your palette, by clicking the color palette itself. This opens the palette picker and displays all the palettes from the collection.

Colors are assigned to each series in order. The first series in the underlying data is assigned the first color, and so on. If your query returns more data series than colors listed, the colors repeat from the beginning of the list.

Creating a Custom Color Palette

To create a custom color palette, first select the Custom tab on the palette picker. You can edit your palette in several ways:

  1. Click on one of the colors present to edit it.
  2. Click the + or - buttons below the color palette to add a color to the end of the palette or remove a selected color.
  3. Click EDIT ALL at the bottom right of the menu to use a comma-separated list of color values.

To change a selected color, or edit all colors at once, you can input hex strings, such as #2ca6cd, or CSS color names, such as mediumblue, into the color value box at the bottom of the picker.

You can also click the color wheel to the right of the color value box to bring up a color picker, which can be used to select a color. The corresponding hex value for that color appears in the color value box:

If you click EDIT ALL, you'll see that the color value box is populated with the hex codes of the color palette you've chosen or customized. Copying and pasting this list is the best way to copy custom color palettes from one chart to another.

Show Full Field Name

Show Full Field Name toggles whether to show the view name along with the field name for each axis title and series name.

Point Style

Point Style specifies how data points appear on the chart. The following options are available:

Customizations

Each series in the chart can be customized in several different ways:

  1. Click the arrow next to a series to expand its options.
  2. Click on the color swatch to select a custom color for the series. This overrides the color palette defined by the Colors option.
  3. Enter a custom series label if desired. This impacts the chart legend and tooltips.
  4. Select a different visualization type for the series if desired. This is useful if you want to combine different visualization types on the same chart, such as showing one series as columns and another series as a line.
  5. For line, area, or scatter series types, select the shape of the chart points.

Values Menu Options

Value Labels

Value Labels toggles the appearance of value labels for each data point on a chart.

Label Null Columns

Label Null Columns toggles the appearance of labels for null data points.

Totals Labels

Totals Labels toggles the appearance of totals for each stacked group of data points on a chart. Totals Labels is only available with Series Positioning Stacked.

Show Silhouette of Disabled Series

Show Silhouette of Disabled Series toggles a lightly-shaded representation of a disabled series in a stacked chart. Click on a series name in the bottom legend of the visualization to disable or enable the series in the visualization. Show Silhouette of Disabled Series is only available with Series Positioning Stacked.

Totals Color

Totals Color defines the color of the totals labels. Click on the color swatch to scroll through color palettes or select a custom color for the totals labels. Totals Color is only available when Series Positioning is set to Stacked.

Value Colors

Value Colors defines the colors of the value labels. This parameter takes a comma-separated list of one or more color values. The color values can be formatted as RGB hex strings, such as #2ca6cd, or as CSS color names, such as mediumblue.

If set to multiple colors, colors will be assigned to each series in order. The first series in the underlying table will be assigned the first color, and so on. If the query returns more data series than colors listed, Looker will assign the series color to the value label after it runs out of your custom colors.

If no Colors values are provided, Looker assigns the series color to the value label.

Font Size

Font Size sets the font size of value labels using any valid CSS size. Generally users will specify a number of pixels, such as 10px or 12px.

Value Rotation

Value Rotation sets the rotation of the value labels. This parameter accepts values between -360 and 360, denoting the number of degrees to rotate the labels. Value Rotation is only available with Series Positioning Grouped or Overlay.

Value Format

Value Format specifies the format of the value, independent of the underlying dimension or measure. The field accepts Excel-style formatting. If no formatting is specified, the value will be displayed in the format of the underlying dimension or measure.

You can read Excel's complete guide about how to specify these formats in their documentation. However, note that color formatting is not supported in Looker.

For Looker developers: The formatting used in the Value Format field is the same as formatting used with the value_format LookML parameter, except that the value_format parameter requires the formatting string to be enclosed in double quotes. In the Value Format field, the formatting string is not enclosed in quotes.

See this documentation page for some common formatting options for numeric fields.

X Menu Options

Scale Type

Scale Type specifies how the x-axis scale is calculated and displayed. The following options are available. Not all options apply to all chart types.

Reverse Axis

Reverse Axis toggles the direction of the x-axis. When OFF, values increase from left to right. When ON, values decrease from left to right.

Show Axis Name

Show Axis Name toggles the appearance of the x-axis name.

Custom Axis Name

Custom Axis Name sets the name for the x-axis. It accepts any string value. This parameter is only available when Show Axis Name is ON.

Axis Value Labels

Gridlines

Gridlines toggles the appearance of gridlines extending from the x-axis. Gridlines are spaced based on the scaling of the x-axis.

Label Rotation

Label Rotation sets the rotation of the x-axis value labels. This parameter accepts values between -360 and 360, denoting the number of degrees to rotate the labels.

Time Label Format

Time Label Format specifies how x-axis value labels are displayed for charts with a time dimension on the x-axis. This parameter accepts time formatting syntax, as shown below. See Time Formatting for Looker Charts for all formatting options.

Y Menu Options

Gridlines

Gridlines toggles the appearance of gridlines extending from the y-axis. Gridlines are spaced based on the scaling of the y-axis.

Reverse Axis

Reverse Axis toggles the direction of the y-axis. When OFF, values increase going up the axis. When ON, values decrease going up the axis.

Left Axes and Right Axes

The Left Axes and Right Axes sections let you configure the chart’s y-axes. The example below shows a chart with three y-axes, two on the left and one on right, each on a different scale:

On the left and right side of the chart, you can have one or more y-axes, each associated with one or more data series. Each data series is based on a measure, even if the measure has been pivoted. Table calculations that use a measure are listed as a data series and can be moved to another axis.

Benefits of Specifying Axes

Using this functionality, any chart can:

Each y-axis has its own set of configuration options and displays one or more data series on a scale relative to that y-axis.

Special Cases for Specifying Axes

Each measure goes on one axis. If you have a measure pivoted, all of its pivoted values go on the same axis. If you want to specify the axis for a particular measure for each pivot, then use filtered measures instead. Create a filtered measure for each possible value (and maybe one more for any unanticipated values). Then you can specify which axis to use for each of your new measures.

Charts with the Series Positioning option set to Grouped or Overlay can have multiple y-axes. Any Stacked or Stacked Percentage charts will have one stacked data series and one y-axis.

Assigning, Removing and Changing Axes

To assign a data series to a y-axis, click and drag the data series to the desired Left or Right Axes area. You can create a new axis or add the data series to an existing y-axis. The following example shows the Order Items Total Sale Price data series being moved from the Left 1 y-axis to the Right Axes area to create a new Right 1 y-axis. A tab is created for the new Right 1 y-axis that contains configuration options for the Right 1 y-axis.

Similarly, you can remove an axis by dragging each of its data series to another y-axis.

When moving a data series to a different axis:

Configure Axis

The Configure Axis section displays a tab for each y-axis configured in the Left Axes and Right Axes sections:

Click on the tab for an axis to configure that y-axis. You configure each y-axis separately using its own set of configuration options.

Scale Type

Scale Type specifies how the y-axis scale is calculated and displayed. The following options are available. Not all options apply to all chart types.

Show Axis Names

Show Axis Names toggles the appearance of y-axis labels.

Show Axis Values

Show Axis Values toggles the appearance of y-axis values.

Unpin Axis From Zero

Unpin Axis From Zero toggles letting the chart focus on the area for which data exists, rather than showing the full scale starting at zero.

Axis Name

Axis Name lets you enter the label for the selected y-axis.

Y Axis Format

Y Axis Format specifies the number format of the y-axis values, independent of the underlying dimension or measure. The parameter accepts Excel style formatting. If no formatting is specified, the value will be displayed in the format of the underlying dimension or measure.

You can read Excel's complete guide about how to specify these formats in their documentation. However, at this time date formatting and color formatting are not supported in Looker.

Some of the most common formatting options are shown here:

Value Format Meaning
# Integer (123)
*00# Integer zero-padded to 3 places (001)
0.## Number up to 2 decimals (1. or 1.2 or 1.23)
0.00 Number with exactly 2 decimals (1.23)
*00#.00 Number zero-padded to 3 places and exactly 2 decimals (01.23)
#,### Number with comma between thousands (1,234)
#,##0.00 Number with comma between thousands and 2 decimals (1,234.00)
0.000,," M" Number in millions with 3 decimals (1.234 M). Please note division by 1 million happens automatically.
$# Dollars with 0 decimals ($123)
$0.00 Dollars with 2 decimals ($123.00)
$#,##0.00 Dollars with comma between thousands and 2 decimals ($1,234.00)
#% Percent with 0 decimals (1%). Please note multiplication by 100 happens automatically.
0.00% Percent with 2 decimals (1.00%). Please note multiplication by 100 happens automatically.
0.00\% Percent with 2 decimals (1.00%). Multiplication by 100 does NOT happen automatically here.

Tick Density

Tick Density sets the density of tick marks on the y-axis. The following options are available:

Minimum Value

Minimum Value defines the minimum value for the selected y-axis.

Maximum Value

Maximum Value defines the maximum value for the selected y-axis.

Add Reference Line

The Add Reference Line button enables the creation of reference lines in a chart. Click it as many times as you like to add any number of reference lines, and reveal the settings for those reference lines. To delete a reference line, click the X in the upper right of its settings.

Reference lines are applied to the first series in your query results (the leftmost column in the result set), even if that series is hidden from the visualization. You can reorder your columns to change the series the reference line is applied to.

Type (for a reference line)

Type specifies the type of reference line to apply to the chart. The following options are available:

Value, Start Value, and End Value (for a reference line)

Value specifies the point on the axis to plot the reference line. You can set the value to the median, average (mean), maximum, or minimum for the data returned in your query results. You can also select Custom to enter a specific value from the axis.

When Type is set to Range, the Start Value and End Value settings replace the Value setting; they accept the same types of values as Value.

Margin Above and Margin Below (for a reference line)

Margin Above and Margin Below specify the shaded ranges to plot on either side of a reference line when Type is set to Line with Margins.

You can set the margin values to the population standard deviation or population variance for your query results. You can also select Custom to enter a specific value or "min", "max", "mean", or "median" to use those calculations from your query results.

Label (for a reference line)

Enter the label that you'd like to appear on the reference line in the Label field. You can also use the following calculations, embedded in double curly brackets {{ }}, in the Label field:

For example, you could enter "Average: {{mean}}" to show something like Average: 123.4.

If you leave the Label field blank, the value of the line will appear on the reference line.

Label Position (for a reference line)

You can position the reference line label at the left of the chart, the right of the chart, or in the center, by selecting one of those options under Label Position.

Color (for a reference line)

Color enables you to specify the color of the reference line in a chart.

Click the color box to reveal a palette picker that you can scroll through to choose a color. To choose a custom color, select the Custom tab on the palette picker and use the color picker that appears, or enter a hex string or CSS named color string into the color value box.

Value Format (for a reference line)

Add custom formatting to the value shown in the reference line label with the Value Format field.

You can use Excel-style formatting to format the label value. The Adding Custom Formatting to Numeric Fields documentation page provides more information on how to use custom formatting.

Add Trend Line

Your Looker admin must enable the Trend Lines in Visualizations Labs feature for this option to be available.

The Add Trend Line button enables the creation of trend lines in a chart. Click it as many times as you like to add any number of trend lines, and reveal the settings for those trend lines. To delete a trend line, click the X in the upper right of its settings.

Looker ignores any NULL values in your data and extrapolates the trend line based on non-NULL values.

Trend Type

Trend Type specifies the type of trend line to apply to the chart. The following options are available:

Period (for a trend line)

Period specifies the number of data points to include when calculating a moving average. Choose a Trend Type of Moving Average to reveal this setting.

Since moving averages are typically used for date-based data, the choices are 7 (for a week), 14 (for two weeks) and 28 (for 4 weeks).

Series Index (for a trend line)

Series Index enables you to specify which chart series should have a trend line added to it.

This option defaults to 1, the first defined series. Each series is numbered according to the order it appears in your data table.

Show Label (for a trend line)

Show Label toggles adding a descriptive label to the trend line.

Label (for a trend line)

Label specifies the label text.

Label Position (for a trend line)

Label Position specifies whether the trend line label will appear at the left edge of the trend line, the center of the trend line, or at the right edge of the trend line.

Label Type (for a trend line)

Label Type specifies the type of label to apply to the trend line. The following options are available:

Color (for a trend line)

Color enables you to specify the color of the trend line in a chart.

Click the color box to reveal a palette picker that you can scroll through to choose a color. To choose a custom color, select the Custom tab on the palette picker and use the color picker that appears, or enter a hex string or CSS named color string into the color value box.

Top