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.
| Setting | What it sets |
|---|---|
| Column | The column it filters. Drag another column onto the filter to change it; the filter then starts over. |
| Show as | Pill (name and value in one field), Dropdown (the name above the field), or List (the values open on the page). |
| Control | For text, List (multiple) or List (single). For numbers, Range. |
| Date tabs | For 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. |
| Operators | For a range or a date picker, the comparisons viewers may choose, and the one it opens on. |
| Applies to | Which charts it narrows. See below. |
| Choices | All values, or Only these: the values viewers can choose from. |
| Default | The value the page opens on. Reset returns to it. |
| Trigger | When 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
| Trigger | What viewers do |
|---|---|
| Manual | Pick, then choose the filter's own Apply. Nothing changes until they do. This is the default. |
| Automatic | Pick; the charts change at once. |
| Batch | Pick in several filters, then choose Apply once in the Filters bar. |
What viewers may do
Under Viewers, Access sets who can change the filter:
| Access | What viewers get |
|---|---|
| Open | They can change it. |
| Locked | They see it but cannot change it. |
| Hidden | They 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:
| Issue | Fix |
|---|---|
| Column missing | Choose a column. The column is no longer in the dataset. |
| Not offered to viewers yet | Offer to viewers. |
| Choices needed | Set the choices. A shared dashboard refuses changes to a filter until its choices are set. |
| No charts selected | Choose charts. |
| Selected charts removed | Choose where it applies. |
| Not connected to any chart | Choose where it applies, or add a chart from the filter's dataset. |
| Hidden, Locked, or Required without a default | Set a default. |
| Default not offered | Review the default. It holds values viewers cannot choose. |
Common problems
| What you see | What to check |
|---|---|
| A filter changes nothing | Its Trigger is Manual and Apply was not chosen, or it applies to no chart on its dataset. |
| A chart ignores a filter | The chart uses another dataset, or is not among the filter's specific charts. |
| The page opens empty | A Required filter has no default. |
| Filtering on a column asks you to confirm | The column is classified PII or Sensitive. Viewers can then see its values in the filter, never its rows. See Prepare columns. |