Dashboard Element Parameters

On this Page
Docs Menu

Dashboards can be created in one of two ways. User-defined dashboards are created via the Looker UI, and are described here. Dashboards can also be created using LookML and their tiles modified as discussed on this page.

Starting in 4.0, you can use New LookML for data modeling. However, LookML dashboards continue to use the YAML-based old LookML language.

A dashboard has several settings that impact the entire dashboard, which are described on the Dashboard LookML page. It will also contain a group of data visualizations, which are called “elements”. The LookML for these elements is described on this page.

The parameters that can be used in a dashboard element are heavily dependent upon the visualization that is used (the visualization is chosen with the type parameter). The parameter descriptions below have been organized according to the visualizations that they support.

Specifying Colors for Dashboard Visualizations

For all chart attributes below that specify a color, the color value can take a hex string like #2ca6cd or a CSS named color string like mediumblue.

Example Usage

# BASIC PARAMETERS - name: element_name title: 'desired element name' type: text | table | single_value | looker_single_record | looker_column | looker_bar | looker_scatter | looker_line | looker_area | looker_pie | looker_donut_multiples | looker_geo_coordinates | looker_geo_choropleth height: N width: N top: N left: N refresh: N (seconds | minutes | hours | days) note: text: 'note text' state: collapsed | expanded display: above | below | hover # QUERY PARAMETERS model: model_name explore: explore_name dimensions: [dimension_name, dimension_name, …] measures: [measure_name, measure_name, …] sorts: [field_name, field_name, …] pivots: [dimension_name, dimension_name, …] limit: N filters: dimension_or_measure_name: 'looker filter expression' # Possibly more filters statements listen: dashboard_filter_name: dimension_or_measure_name # Possibly more listen statements # TEXT PARAMETERS name: element_name title_text: 'title text' subtitle_text: 'subtitle text' body_text: 'body text' # TABLE PARAMETERS total: true | false row_total: right | left | false # SINGLE VALUE PARAMETERS font_size: small | medium | large # deprecated in 3.46 # CHART PARAMETERS (column, bar, scatter, line, area, pie, donut multiples) colors: [css_color, css_color, …] series_colors: series_name: css_color # Possibly more series color assignments series_labels: series_name: desired series label # Possibly more series label assignments # CARTESIAN CHART PARAMETERS (column, bar, scatter, line, area) hidden_series: [series_name, series_name, …] hide_legend: true | false stacking: normal | percent | '' show_dropoff: true | false show_value_labels: true | false show_view_names: true | false swap_axes: true | false series_types: series_name: line | column | area | scatter # Possibly more series visualization assignments x_axis_label: desired x-axis label x_axis_label_rotation: N x_padding_left: N x_padding_right: N x_axis_gridlines: true | false show_x_axis_label: true | false show_x_axis_ticks: true | false y_axis_orientation: [left | right, left | right, …] y_axis_combined: true | false y_axis_labels: ['desired y-axis label', 'desired y-axis label', …] y_axis_min: [N, N, …] y_axis_max: [N, N, …] y_axis_gridlines: true | false show_y_axis_labels: true | false show_y_axis_ticks: true | false y_axis_tick_density: default | custom y_axis_tick_density_custom: N reference_lines: # reference line options # COLUMN AND BAR PARAMETERS show_null_labels: true | false # SCATTER, LINE, AND AREA PARAMETERS x_axis_scale: auto | linear | time | ordinal x_axis_datetime_tick_count: N x_axis_datetime_label: 'time formatting string' show_null_points: true | false # LINE AND AREA PARAMETERS hide_points: true | false interpolation: linear | monotone | step | step-before | step-after discontinuous_nulls: true | false # PIE PARAMETERS inner_radius: N% # DONUT MULTIPLE PARAMETERS charts_across: N # MAP PARAMETERS map: usa | world map_url: 'url to map topojson' map_object_key: map_name map_projection: d3_map_projection inner_border_color: css_color inner_border_width: N outer_border_color: css_color outer_border_width: N # COORDINATE MAP PARAMETERS point_color: css_color map_color: css_color point_radius: N # CHOROPLETH MAP PARAMETERS colors: [css_color, css_color, …] quantize_colors: true | false empty_color: css_color map_property_key: topo_json_property map_property_label_key: topo_json_property

Parameter Definitions

Parameter Name Applies To Description
Basic Parameters
name (for elements) All Create an element
title (for elements) All Change the way an element name appears to users
type (for elements) All Determine the type of visualization to be used in the element
height (for elements) All Define the height of an element in units of tile_size for layout: tile and layout: static dashboards
width (for elements) All Define the width of an element in units of tile_size for layout: tile and layout: static dashboards
top All Define the top-to-bottom position of an element in units of tile_size for layout: static dashboards
left All Define the left-to-right position of an element in units of tile_size for layout: static dashboards
refresh (for elements) All Set the interval on which the element will automatically refresh
note All Start a section of LookML to define a note for an element
text All Define the text of a note
state All Determine if a note is collapsed or expanded if it is too big for the width of the element
display All Determine how a note is displayed on an element
Query Parameters
model All Define the model to be used for the element’s query
explore (for elements) All Define the explore to be used for the element’s query
dimensions All Define the dimensions to be used for the element’s query
measures All Define the measures to be used for the element’s query
sorts All Define the sorts to be used for the element’s query
pivots All Define the dimensions that should be pivoted to be used for the element’s query
limit All Define the row limit to be used for the element’s query
filters (for elements) All Define the filters that cannot be changed for the element’s query
listen All Define the filters that can be changed for the element’s query, if filters (for dashboard) have been created
Table Parameters
total ADDED3.8 Determine if column totals are displayed for a table visualization
row_total ADDED3.8 Determine if row totals are displayed for a table visualization
Single Value Parameters
font_size AVOID AS OF3.46 Set the font size for a single value visualization (used before single values automatically adjusted, as described here)
Chart Parameters
colors Set the colors of chart series based on the order the series appear
series_colors Set the colors of chart series based on the name of the series
series_labels Change the way a series name appears to users
Cartesian Chart Parameters
hidden_series ADDED3.8 Hide a chart series when the element loads
hide_legend Hide the chart legend
stacking Stack series on top of each other to create a stacked chart
show_dropoff ADDED3.8 Add arrows that show the percent change between data points
show_value_labels ADDED3.8 Show labels next to data points
show_view_names ADDED3.8 Hide view names from chart labels
swap_axes ADDED3.10 Reverse the x and y axes on a chart
series_types ADDED3.18 Mix visualization types by defining the type for each series
x_axis_label Define a custom x-axis label
x_axis_label_rotation Rotate x-axis labels a number of degrees
x_padding_left Adding between the left axes and the left side of the chart
x_padding_right Adding between the right axes and the right side of the chart
x_axis_gridlines ADDED3.10 Extend grid lines from the x-axis
show_x_axis_label ADDED3.10 Hide the x-axis label
show_x_axis_ticks ADDED3.10 Show ticks on the x-axis
y_axis_orientation Move y axes to the left or right side of the chart
y_axis_combined Combine all y axes
y_axis_labels Define custom y axes labels
y_axis_min Set the minimum value for the y axes
y_axis_max Set the maximum value for the y axes
y_axis_gridlines ADDED3.10 Extend gridlines from the y-axis
show_y_axis_labels ADDED3.10 Hide the y axes labels
show_y_axis_ticks ADDED3.10 Show ticks on the y-axis
y_axis_tick_density ADDED3.18 Enable a custom number of y-axis ticks
y_axis_tick_density_custom ADDED3.18 Set a custom number of y-axis ticks
reference_lines Add reference lines to a chart
Column and Bar Parameters
show_null_labels Determine if null labels should be shown on a chart when labels are shown
Scatter, Line, and Area Parameters
x_axis_scale Determines how the x-axis scale is calculated
x_axis_datetime_tick_count Determines the number of ticks to place along the x-axis
x_axis_datetime_label A format string for the x-axis labels, if they are dates
show_null_points Determines whether to plot points which have null values
Line and Area Parameters
hide_points Determine if line and area charts should be down with individual data points
interpolation Determines the type of smoothing to apply to line and area charts
discontinuous_nulls ADDED3.8 Treat null values as empty space on charts, instead of as zero
Pie Parameters
inner_radius Determines the inner radius of a pie chart, which effectively turns it into a donut chart
Donut Multiple Parameters
charts_across The number of small donut charts that will be placed in a row
Map Parameters
map The map to plot the points on
map_url A URL to an externally-hosted TopoJSON file to load map data from
map_object_key Selects which map from the TopoJSON file to plot
map_projection The map projection to use for the map
inner_border_color Sets the inner border color of the map
inner_border_width Sets the width of the map’s inner border
outer_border_color Sets the outer border color of the map
outer_border_width Sets the width of the map’s outer border
Coordinate Map Parameters
point_color Sets the color of the plotted points
map_color Sets the color of the background map
point_radius Sets a fixed radius, in pixels, of each point on the map
Choropleth Map Parameters
colors (for maps) Sets a list of colors for the color scale
quantize_colors Specifying if the colors specified in colors define a color scale or specific colors to be used
empty_color Set the color of empty regions
map_property_key Selects which property from the TopoJSON file to plot against
map_property_label_key Selects which property from the TopoJSON file to display in the tooltip label

Basic Parameters

name

This section refers to the name parameter that is part of a dashboard element
name can also be used as part of a dashboard filter, described here

Each name declaration creates a new dashboard element, and assigns a name to it. Element names must be unique. Names are sometimes referenced in the elements parameter when using layout: grid dashboards.

- name: orders_by_date

title

This section refers to the title parameter that is part of a dashboard element
title can also be used as part of a dashboard, described here
title can also be used as part of a dashboard filter, described here

The title parameter allows you to change how an element name will appear to users. If not specified, the title defaults to the element name.

Consider this example:

- name: sales_overview title: '1) Sales Overview'

If you did this, instead of the element appearing as Sales Overview, it would appear as 1) Sales Overview.

type

This section refers to the type parameter that is part of a dashboard element
type can also be used as part of a dashboard filter, described here
type can also be used as part of a join, described here
type can also be used as part of a dimension, described here
type can also be used as part of a measure, described here

The type parameter determines the type of visualization to be used in the element.

- name: element_name type: text | table | single_value | looker_single_record | looker_column | looker_bar | looker_scatter | looker_line | looker_area | looker_pie | looker_donut_multiples | looker_geo_coordinates | looker_geo_choropleth

table


Accepts any number of dimensions, pivots, and measures.

single_value


Displays a single measure or dimension. If the query returns more than one cell, the first measure is displayed; if there are no measures, the first dimension is displayed.

looker_single_record


Accepts any number of dimensions and measures. Pivots are not supported. If the query returns multiple rows, only the first one is shown.

looker_column


If multiple measures are specified, each measure becomes a y-axis series. If pivots are present, each pivot and measure combination becomes a y-axis series. If no measures are specified, two dimensions can be plotted.

looker_bar   ADDED3.10


If multiple measures are specified, each measure becomes a x-axis series. If pivots are present, each pivot and measure combination becomes a x-axis series. If no measures are specified, two dimensions can be plotted. Reference lines are not supported on bar charts.

looker_scatter


If two dimensions are specified, the first dimension is placed on the y-axis and the second dimension is placed on the x-axis. If multiple measures are specified, each measure becomes a y-axis series. If pivots are present, each pivot and measure combination becomes a y-axis series. If no measures are specified, two dimensions can be plotted.

looker_line


If multiple measures are specified, each measure becomes a y-axis series. If pivots are present, each pivot and measure combination becomes a y-axis series. If no measures are specified, two dimensions can be plotted.

looker_area


If multiple measures are specified, each measure becomes a y-axis series. If pivots are present, each pivot and measure combination becomes a y-axis series. If no measures are specified, two dimensions can be plotted.

looker_pie


A pie chart requires one dimension and one measure.

looker_donut_multiples


A donut multiple chart requires one regular dimension, one pivoted dimension, and one measure. Each value of the regular dimension defines the donuts, and each value of the pivoted dimension defines the slices.

looker_geo_coordinates


A coordinates map is useful for plotting data that is represented by points. To plot regions, use looker_geo_choropleth. Coordinates maps plot a single measure and a single dimension of type: location or type: zipcode. Additional dimensions will show in the tool-tip on hover.

looker_geo_choropleth


A choropleth map is useful for plotting data that is represented by regions. To plot individual points, use looker_geo_coordinates. Choropleth maps plot a single measure and a single dimension of type: string which contains either a US state (map: usa) or ISO 3166-1 alpha-3 country code (map: world). Additional dimensions will show in the tool-tip on hover.

text


Displays a static text element with various text sizes.

height

This section refers to the height parameter that is part of a dashboard element
height can also be used as part of a dashboard row, described here

Defines the height of an element, in units of tile_size for layout: tile and layout: static dashboards.

For example, if you had set tile_size: 100 and height: 4 like this:

- dashboard: sales_overview tile_size: 100 … elements: - name: orders_by_date height: 4 …

Then the orders_by_date element would be 400 pixels in height.

width

This section refers to the width parameter that is part of a dashboard element
width can also be used as part of a dashboard, described here

Defines the width of an element, in units of tile_size for layout: tile and layout: static dashboards.

For example, if you had set tile_size: 100 and width: 4 like this:

- dashboard: sales_overview tile_size: 100 … elements: - name: orders_by_date width: 4 …

Then the orders_by_date element would be 400 pixels in width.

top

Defines the top-to-bottom position of an element in units of tile_size for layout: static dashboards.

For example, if you had set tile_size: 100 and top: 4 like this:

- dashboard: sales_overview tile_size: 100 … elements: - name: orders_by_date top: 4 …

Then the top edge of the orders_by_date element would be 400 pixels from the top of the dashboard.

left

Defines the left-to-right position of an element in units of tile_size for layout: static dashboards.

For example, if you had set tile_size: 100 and left: 4 like this:

- dashboard: sales_overview tile_size: 100 … elements: - name: orders_by_date left: 4 …

Then the left edge of the orders_by_date element would be 400 pixels from the left side of the dashboard.

refresh

This section refers to the refresh parameter that is part of a dashboard element
refresh can also be used as part of a dashboard, described here

The refresh parameter allows an element to automatically re-load on some periodic basis, thereby retrieving fresh data. This is often helpful in settings where a dashboard is constantly displayed, such as on an office TV. Note that the dashboard must be open in a browser window for this parameter to have an effect. This setting does not run in the background to “pre-warm” the dashboard cache.

The refresh rate can be any number (without decimals) of seconds, minutes, hours or days. For example:

- name: orders_by_date refresh: 2 hours

Use caution when setting short refresh intervals. If the query behind the element is resource intensive, certain elements may strain your database more than desired.

note ADDED3.16

You can add descriptive notes to elements like this:

- name: element_name note: text: 'note text' state: collapsed | expanded display: above | below | hover

text

Defines the text of a note to be displayed.

state

Determines if a note is collapsed or expanded if it is too big to fit on a single row within the element’s width. If the you choose collapsed, and the note is too long, an ellipses (...) will be displayed at the end of the note that a user can click on to read the full note.

display

Determines where a note is displayed on an element. above places the note at the top of an element, below places it at the bottom of an element, and hover requires the user to hover their mouse over the element in order to see the note.

Query Parameters

model

Defines the model to use for the element query. If left unset it will default to the model where the dashboard resides.

- name: orders_by_date model: acme

explore

This section refers to the explore parameter that is part of a dashboard element
explore can also be used as part of a model, described here
explore can also be used as part of a dashboard filter, described here

Defines the explore to use for the element query.

- name: orders_by_date explore: order

dimensions

Defines the dimension or dimensions to use for the element query. Use the syntax view_name.dimension_name when writing the dimension. Don’t include dimensions if the query has no dimensions.

# single dimension example - name: orders_by_date dimensions: order.order_date # multiple dimension example - name: orders_by_date dimensions: [order.order_date, customer.name]

measures

Defines the measure or measures to use for the element query. Use the syntax view_name.measure_name when writing the measure. Don’t include measures if the query has no measures.

# single measure example - name: orders_by_date measures: order.count # multiple measure example - name: orders_by_date measures: [order.count, order_item.count]

sorts

Defines the sorts to be used for the element query. The primary sort is listed first, then the secondary sort, and so on. Use the syntax view_name.field_name when writing the dimension or measure. Don’t include sorts if want to use Looker’s default sort order. Descending sorts are suffixed with desc; ascending sorts don’t need a suffix.

# single sort example - name: orders_by_date sorts: order.order_date desc # multiple sort example - name: orders_by_date sorts: [order.order_date desc, customer.name]

pivots

Defines the dimensions that should be pivoted for the element query. Use the syntax view_name.dimension_name when writing the dimension. Don’t include pivots if the query has no pivots.

# single pivot example - name: orders_by_date pivots: customer.gender # multiple pivot example - name: orders_by_date pivots: [customer.gender, customer.age_tier]

limit

Defines the row limit that should be used for the element query. The limit applies to the number of rows before any pivots are applied.

- name: orders_by_date limit: 100

filters

This section refers to the filters parameter that is part of a dashboard element
filters can also be used as part of a dashboard, described here
filters can also be used as part of a measure, described here

Defines the non-changeable filters that should be used for the element query, similar to applying those filters in the explore UI. If you would like filters that a user can change in the dashboard, you should setup the filter using filters for dashboards, then apply it to the element using listen.

The syntax for filters is:

- name: element_name filters: view_name.dimension_name: 'looker filter expression' # You can add more than one filters statement

Looker filter expressions can be found here.

listen

Dashboards can have filters that allow users to change the data behind dashboard elements. These are setup by using the filters for dashboards parameter. In order for a filter to impact an element, the element must be setup to “listen” for that filter, using the listen parameter.

The syntax for listen is:

- name: element_name listen: filter_name_goes_here: dimension or measure on which to apply the filter using view_name.field_name syntax # You can add more than one listen statement

For example, you might create a filter that the user can enter a date into, named Date. You could then apply the value that the user enters to the orders_by_date element like this:

- dashboard: sales_overview … filters: - name: date type: date_filter elements: - name: orders_by_date listen: date: order.order_date …

This concept is described in more detail on the Creating a LookML Dashboard page.

Text Parameters

title

This is the largest font size available in a text element. It is shown at the top of the tile.

title_text: 'title text'

subtitle_text

This is the middle font size available in a text element. It is shown below the title, if present.

subtitle_text: 'subtitle text'

body_text

This is the smallest font size available in a text element. It is shown last in the text file.

body_text: 'body text'

Table Parameters

total ADDED3.8

Determines whether or not a totals row is shown at the bottom of the table. See Displaying Totals for more information.

total: true | false # default value: false

row_total ADDED3.8

Determines whether or not a totals column is shown on the right or left of the table. Only works if a pivot is present. See Displaying Totals for more information.

row_total: right | left | false # default value: false

Single Value Parameters

font_size AVOID AS OF3.46

Changes the font size of a single value element. Starting in 3.46, this parameter is ignored because single values are automatically adjusted, as described here.

font_size: small | medium | large # default value: medium

Chart Parameters

colors

A list of colors for the series. The first color in the list corresponds with the first data series. For example:

colors: [blue, orange, yellow, red, purple]

If there are more series than listed colors, the colors will start over at the beginning.

series_colors

Set the colors of the series based on the series name, using name: value pairs.

For a pivoted chart, the series names are the pivot names. For example:

series_colors: 'Yes': skyblue 'No': '#000000'

For a chart with multiple measures, the series names are the measure field names. For example:

series_colors: inventory_items.count: crimson orders.count: green

If the series name is not listed in series_colors, the chart will default to the list of colors provided in colors. If colors is not set the chart will fall back to the default color scheme.

series_labels

Sets the label of the series based on the series name, using name: label pairs. This does not set the label for the y-axes, which are labeled with the y_axis_labels option.

For a pivoted chart, the series names are the pivot names. For example:

series_labels: 'Yes': iOS Users 'No': Android Users

For a chart with multiple measures, the series names are the measure field names. For example:

series_labels: inventory_items.count: Inventory orders.count: Orders

Cartesian Chart Parameters

hidden_series ADDED3.8

Determines which series will be hidden in the UI. Users can then expose hidden series by clicking them in the chart legend. Consequently, hidden_series may not worked as desired with hide_legend: true.

For a pivoted chart, the series names are the pivot names:

hidden_series: ['Yes', 'No']

For a chart with multiple measures, the series names are the measure field names:

hidden_series: [inventory_items.count, orders.count]

hide_legend

This declaration will hide the legend.

hide_legend: true | false # default value: false

stacking

Setting to normal will stack bars, lines, and points one on top of each other, as in a normal stacked column chart.

Setting to percent will stack bars, lines, and points to total 100% fill of the chart and set the y-axis values to be percentages.

stacking: normal | percent | '' # default value: ''

show_dropoff ADDED3.8

Display the dropoff percentage between data points. For example:

show_dropoff: true | false # default value: false

show_value_labels ADDED3.8

Display the value of a bar, line, or point next to the data point. For example:

show_value_labels: true | false # default value: false

show_view_names ADDED3.8

Determines whether or not view names are displayed in chart labels such as axis names, column names, etc.

show_view_names: true | false # default value: true

swap_axes ADDED3.10

Swap the x-axis and y-axis, creating a “sideways” graph. Setting swap_axes to true will disable reference lines.

swap_axes: true | false # default value: false

series_types ADDED3.18

Allows you to use different cartesian chart types in the same visualization. Options are line, column, area, scatter. You assign a chart type to the series that you want to change.

series_types: series_a_name: column series_b_name: line

All series default to the initial chart type that you choose, then you can modify individual series.

x_axis_label

Label for the x axis.

x_axis_label: Order Date

x_axis_label_rotation

Defines the rotation of the x axis labels in degrees.

x_axis_label_rotation: -45

x_padding_left

An integer value, in pixels, that will add whitespace between the left axes and the left side of the chart.

x_padding_left: 5

x_padding_right

An integer value, in pixels, that will add whitespace between the right axes and the right side of the chart.

x_padding_right: 10

x_axis_gridlines ADDED3.10

Determines whether or not gridlines are extended from the x-axis.

x_axis_gridlines: true | false # default value: false

show_x_axis_label ADDED3.10

Determines whether or not labels are shown on the x-axis.

show_x_axis_label: true | false # default value: true

show_x_axis_ticks ADDED3.10

Determines whether or not ticks are shown on the x-axis.

show_x_axis_ticks: true | false # default value: true

y_axis_orientation

Orients each y axis to the appropriate side of the chart. Each axis matches to the order of the defined measures. For example:

y_axis_orientation: [left, right]

y_axis_combined

If there is more than one measure, combines the y axes into one.

y_axis_combined: true | false # default value: false

y_axis_labels

Defines a label for each y axis. Order of the array matches the order of the defined measures. For example:

y_axis_labels: ['label1', 'label2']

y_axis_min and y_axis_max

Sets minimum and maximum y-axis values. Before release 3.18, y_axis_min and y_axis_max must be used together, and cannot be used individually. Can be a number or array of numbers. Order of the array matches the order of the defined measures. For example:

y_axis_min: 0 y_axis_max: 100 y_axis_min: [0, 100, 4] y_axis_max: [100, 2000, 5.5]

y_axis_gridlines ADDED3.10

Determines whether or not gridlines are extended from the y-axis.

y_axis_gridlines: true | false # default value: true

show_y_axis_labels ADDED3.10

Determines whether or not labels are shown on the y-axis.

show_y_axis_labels: true | false # default value: true

show_y_axis_ticks ADDED3.10

Determines whether or not ticks are shown on the y-axis.

show_y_axis_ticks: true | false # default value: true

y_axis_tick_density ADDED3.18

Allows you to enable the setting of y-axis tick density. Set to custom to enable this feature, then use the y_axis_tick_density_custom parameter to set the density.

y_axis_tick_density: default | custom # default value: default

y_axis_tick_density_custom ADDED3.18

Allows you to set the density of y-axis ticks, if y_axis_tick_density is set to custom. Accepts an integer that represents the number of ticks you want to appear.

y_axis_tick_density_custom: 10 # default value: 5

reference_lines

An array of values for specifying reference lines and regions. Disabled for bar charts, or if swap_axes is set to true.

See Reference Lines Guide for information on setting up reference lines.

reference_lines: # reference line options

Column and Bar Parameters

show_null_labels

Determine if labels should be shown for null columns or bars, when show_value_labels is set to true.

show_null_labels: true | false # default value: false

Scatter, Line, and Area Parameters

x_axis_scale

Determines how the x-axis scale is calculated.

  • auto - The scale will be guessed based on the underlying data. This is the default setting.
  • linear - The scale will be plotted as linear numeric data. This will not work if the underlying data can’t be converted to numbers.
  • time - The data will be plotted as time and the axis will be labeled approprately. This will not work if the underlying data can’t be converted to dates.
  • ordinal - The data will be plotted as evenly-spaced, discrete entries.
x_axis_scale: auto | linear | time | ordinal # default value: auto

x_axis_datetime_tick_count

Determines the number of ticks to place along the x-axis. If x_axis_scale is not set to time, this does nothing. If left blank, the chart will try to automatically choose an appropriate tick count.

x_axis_datetime_tick_count: 10

The specified count is only a hint; the chart may use more or fewer values depending on the input data.

x_axis_datetime_label

A format string for the x-axis labels, if they are dates. If x_axis_scale is not set to time, this does nothing.

x_axis_datetime_label: '%b %d'

See Looker Charts time formatting guide for information on formatting times.

Note that x_axis_datetime_label does not work with type: looker_column until release 3.8.

show_null_points

Determines whether to plot points which have null values. When true, null values are plotted at zero on the y-axis. When false, null values are not plotted at all, and the chart will draw a linear line between the points before and after the null point. If you want the chart to show a blank space for the null value instead, consider discontinuous_nulls: true.

show_null_points: true | false # default value: true

Line and Area Parameters

hide_points

This declaration will render the line without showing the individual points until they are moused over.

hide_points: true | false # default value: false

interpolation

The type of interpolation to apply to the line. Can be linear, monotone, step, step-before, step-after.

interpolation: linear | monotone | step | step-before | step-after # default value: linear

discontinuous_nulls ADDED3.8

This parameter allows you to treat NULLs as empty space on a chart, instead of as zero (if you want them to show as zero, or to be ignored, use show_null_points).

discontinuous_nulls: true | false # default value: false

Please note this parameter will not work when stacking is set to normal or percent. It also does not work with show_null_points: true, because show_null_points is mutually exclusive with discontinuous_nulls.

Pie Parameters

inner_radius

Determines the inner radius of a pie chart, which effectively turns it into a donut chart. The percentage you provide represents the portion of the radius that will be taken by the “hole” of the donut chart.

inner_radius: 50% # default value: 0%

Donut Multiple Parameters

charts_across

The number of small donut charts that will be placed in a row of the type: looker_donut_multiples visualization.

charts_across: 2 # default value: 3

Map Parameters

map

The map to plot the points on, either usa or world. When specified, this option overrides the map_url option.

map: usa | world # default value: world

map_url

A URL to an externally-hosted TopoJSON file to load map data from. The server serving the file must allow AJAX requests from your Looker instance. This allows you to use any custom map you would like to plot on. This setting will not work if the map parameter is set.

map_url: 'https://example.com/my-custom-map.topo.json'

map_object_key

If a custom map is set with map_url, this selects which map from the TopoJSON file to plot. TopoJSON can support multiple maps in a single file. This is a string that matches one of the map names specified in the file.

map_object_key: counties

If map_url is not set, map_object_key does nothing.

map_projection

The map projection to use for the map. If map is set to world, this defaults to kavrayskiy7. If map is set to usa, this defaults to albersUsa. If map_url is present, this defaults to mercator.

Looker supports any projection supported by the D3 Extended Geographic Projections project.

map_projection: wagner6

inner_border_color

Sets the inner border color of the map.

inner_border_color: crimson

inner_border_width

Sets the width of the map’s inner border, in pixels.

inner_border_width: 3 # default value: 1

outer_border_color

Sets the outer border color of the map.

outer_border_color: crimson

outer_border_width

Sets the width of the map’s outer border, in pixels.

outer_border_width: 3 # default value: 0

Coordinate Map Parameters

point_color

Sets the color of the plotted points.

point_color: tomato

map_color

Sets the color of the background map.

map_color: mediumorchid

point_radius

Sets a fixed radius, in pixels, of each point on the map. If set, all points will use the fixed size specified. If unset, the points will be scaled linearly in size according to the measure.

point_radius: 3

Choropleth Map Parameters

colors

Sets a list of colors for the color scale. If set to a single color, the minimum value of the measure is represented by a light gray and the maximum value of the measure is represented by the provided color.

colors: red

If set to multiple colors, the color will interpolate linearly through all the colors, with the minimum value of the measure represented by the first listed color, and the maximum value represented by the last listed color.

# Example 1 colors: [blue, red] # Example 2 colors: [blue, orange, yellow, '#FFFF00', purple]

quantize_colors

A boolean specifying whether the colors specified in colors should be quantized. If set to true, the specified colors are treated as a discrete set. If set to false, the specified colors are interpolated smoothly.

quantize_colors: true # default value: false

empty_color

The color that the region should be when there is no data for the region. This defaults to the color that represents the minimum value of the data.

empty_color: yellow

map_property_key

If a custom map is set with map_url, this selects which property from the TopoJSON file to plot against. TopoJSON can support arbitrary metadata for each region. If there’s a particular metadata property you want to plot against, you can select it using map_property_key. By default, the first matching property is used.

map_property_key: COUNTY_IDENTIFIER

If map_url is not set, map_property_key does nothing.

map_property_label_key

If a custom map is set with map_url, this selects which property from the TopoJSON file to display in the tooltip label. TopoJSON can support arbitrary metadata for each region. If there’s a particular metadata property you want to appear in the tooltip, you can select it using this option. By default, the value of map_property_key is used.

map_property_label_key: COUNTY_NAME

If map_url is not set, map_property_label_key does nothing.

Still have questions?
Go to Discourse - or - Email Support
Top