Skip to main content

Build dashboards

Chart actions

What viewers can do when they click a chart.

A chart action sets what happens when a viewer clicks a value on a chart: filter the page, drill down, see the rows behind it, or go somewhere else. This page covers adding actions and what each needs.

Before you start​

Select a chart on the canvas in the builder. See Create charts.

Add an action​

  1. In the panel, open Actions.
  2. Choose Add an action, then the kind of action.
  3. Optionally, give it a Label, the words viewers see in the menu.
ActionWhat the viewer gets
FilterCharts on the page keep only the value clicked.
Drill downThis chart breaks the value down, one level at a time. Add levels under Levels.
Show the rowsThe rows behind the value, a page at a time, with Download CSV.
Go toA tab or another dashboard.
Open a linkA web address.

With one action, a click runs it. With several, viewers pick from a menu.

After drilling, the chart's title becomes a trail, such as "Sales by region › West › Seattle". Viewers click a step to go back up.

Drill levels belong to the chart, so they apply on every dashboard that uses it.

What Show the rows needs​

Show the rows, and the Download CSV button on a chart, need each of these switches on:

  • Allow raw data, in the chart's Element section.
  • Rows allowed, on the dataset's Tenancy tab.
  • Rows for your customers' viewers, an install-wide setting that is on unless an admin turned it off through GOAT's API.

The action's settings say which switch is off.

Your developers can also turn rows, drilling, or downloads off for some or all viewers, in the viewer token. Those viewers are not offered the action, and the builder cannot show that. See Embed options.

A viewer downloads at most a set number of rows; the action's settings show the limit. Columns classified PII or Sensitive are left out of the rows. See Prepare columns.

Where actions are not offered​

  • Indicator and Gauge charts have no rows to show, and no Allow raw data switch.
  • Drill down and Show the rows are not offered on a chart split by two categories.
  • A chart with no next level has nothing to drill into.

Saving a chart with personal data​

If a chart drills or shows rows on a column classified PII or Sensitive, saving it asks you to confirm. Viewers can then send values of that column to GOAT when they drill. Saving records that you confirmed it.

Common problems​

What you seeWhat to check
Show the rows is not offeredOne of the switches under What Show the rows needs is off; the action's settings say which. If all are on, ask your developers whether the viewer token turns rows off.
Drill down is not offered to viewersThe chart is split by two categories, or the viewer token turns drilling off.
Drilling fails for viewers after a column was classifiedOpen the chart in the Chart Builder and save it again, confirming the classification.
Download CSV stops earlyIt downloads up to the limit shown in the action's settings.
GOAT documentation

Type to search.