Skip to main content

Build dashboards

Dashboard filters

Let viewers narrow what the charts show.

A dashboard filter is a control viewers use to narrow the charts, such as a list of regions or a date range. This page covers adding a filter, its settings, and what viewers see.

Before you start​

Open the dashboard in the builder, with a dataset picked. A filter works on one column of one dataset, and narrows the charts on that dataset.

Add a filter​

Any of these adds one:

  • Choose Filter on the insert rail, draw its frame, then choose the column on it.
  • In the Data panel, choose + on a column's row, then Use as filter, then In header or In this tab.
  • Hold Alt (Option on a Mac) while you drag a column onto the canvas.

The column decides the control: a list for text, a range for numbers, and date tabs for dates. A filter works as soon as it has its column.

Filter settings​

Select the filter to see its settings in the panel, under Filter and Viewers.

SettingWhat it sets
ColumnThe column it filters. Drag another column onto the filter to change it; the filter then starts over.
Show asPill (name and value in one field), Dropdown (the name above the field), or List (the values open on the page).
ControlFor text, List (multiple) or List (single). For numbers, Range.
Date tabsFor dates: Picker, a calendar with Between, On, Before, and After. Presets, such as Today, Last 30 days, and This month. Also which tab it opens on.
OperatorsFor a range or a date picker, the comparisons viewers may choose, and the one it opens on.
Applies toWhich charts it narrows. See below.
ChoicesAll values, or Only these: the values viewers can choose from.
DefaultThe value the page opens on. Reset returns to it.
TriggerWhen a viewer's pick reaches the charts. See below.

The settings save when you close the panel.

Which charts it narrows​

A filter in the header applies to every tab. A filter in a tab applies to:

  • This tab: every chart on the tab that uses the filter's dataset.
  • Specific charts: only the charts you pick. Choose Add charts, or pick a chart on the canvas.

A filter narrows only charts on its own dataset.

When it applies​

TriggerWhat viewers do
ManualPick, then choose the filter's own Apply. Nothing changes until they do. This is the default.
AutomaticPick; the charts change at once.
BatchPick in several filters, then choose Apply once in the Filters bar.

What viewers may do​

Under Viewers, Access sets who can change the filter:

AccessWhat viewers get
OpenThey can change it.
LockedThey see it but cannot change it.
HiddenThey do not see it; its default still applies.

With Access at Open, turn on Required (Always has a value) to make charts wait until the filter has a value. Locked, Hidden, and Required filters need a default; GOAT asks for one when you turn them on.

What viewers see​

  • Each filter on the page, with Apply, Cancel, and Reset to default below it as its trigger needs.
  • With Batch filters, a floating Filters bar with Apply and Reset. It lists changes not yet applied, and filters set by clicking a chart, each with × to remove it. Viewers can pin it in place or let it scroll.
  • Locked filters marked Locked. Hidden filters do not show.

Viewers cannot add filters of their own.

Filter issues​

When a filter cannot work as set, the panel lists the issue with a button that fixes it:

IssueFix
Column missingChoose a column. The column is no longer in the dataset.
Not offered to viewers yetOffer to viewers.
Choices neededSet the choices. A shared dashboard refuses changes to a filter until its choices are set.
No charts selectedChoose charts.
Selected charts removedChoose where it applies.
Not connected to any chartChoose where it applies, or add a chart from the filter's dataset.
Hidden, Locked, or Required without a defaultSet a default.
Default not offeredReview the default. It holds values viewers cannot choose.

Common problems​

What you seeWhat to check
A filter changes nothingIts Trigger is Manual and Apply was not chosen, or it applies to no chart on its dataset.
A chart ignores a filterThe chart uses another dataset, or is not among the filter's specific charts.
The page opens emptyA Required filter has no default.
Filtering on a column asks you to confirmThe column is classified PII or Sensitive. Viewers can then see its values in the filter, never its rows. See Prepare columns.
GOAT documentation

Type to search.