Filter a chart
Narrow a chart's rows with operators by field type, value lists, Top N, and relative dates - and, on a year-only column, with whole years alone.
Every chart has its own Filters list. Filters narrow the rows that go into the chart without changing your underlying dataset.
Add a filter
- Open the Filters pane next to your chart.
- Click Add filter and pick a field.
- Golden picks a starting operator based on the field type: a value list for categorical fields, a range slider for numeric fields, a date range for dates, and a true/false picker for booleans.
- Adjust the values - the chart updates as you go.
What operators are available
- Text fields: equals, not equals, contains, doesn't contain, starts with, ends with, is blank, is not blank.
- Numeric fields: greater than, less than, between, not between, the >= / <= variants, and Is in the highest N in data.
- Date fields: a date range plus relative options like "last", "current", and "next". A column that holds only years is the exception - it takes whole years, so it offers no sub-year or relative options.
- Any dimension: Top N or Bottom N, ranked by a measure of your choice.
Relative dates
A date field's relative options - the Last, This, and Next presets - count from today by default. Tick "End at the latest date in the data" at the top of the Relative editor to count from the newest date in the column instead, so a dataset that stopped loading still answers questions about its latest period. With it on, the Last presets read "Last N … of data", the This presets relabel to Latest - Latest week, Latest month, and so on - and the filter's summary shows where the window ends, for example "Last 7 days of data (ending Dec 30, 2025)".
Keep a filter on the latest value
On a numeric field, Is in the highest N in data keeps only the rows at the column's highest values, so a filter you write for "the latest round" or "the last three rounds" stays current as new rows load - where a fixed Round Number = 24 would go stale the moment round 25 arrives. A "How many highest values" input sets N: with N at 1 the filter keeps the single highest value, and with N above 1 it keeps the rows at the column's N highest distinct values. Golden looks the values up from the data and refreshes them along with the chart, taking them from the rows the chart's other filters already keep, so Season = 2025 together with the two highest rounds gives 2025's last two rounds. The filter chip leads with the value it landed on - "= 24 (highest in data)" for a single value, or "in highest 3 in data (22–24)" for several - and the chart's subtitle reads "Round: highest 3 in data". It is offered on a field that has row-level values to compare, not on a running count or a fixed-aggregation metric, and you can ask for it in plain words from the chat as well - for example "the last 3 rounds" or "past 4 weeks".
Pick values from a list
For a categorical field, the filter lists the field's values for you to tick, and a segmented control at the top of the list decides how you pick them.
- Single - keep exactly one value. The rows turn into radio buttons, with an "(All)" choice at the top that clears the filter.
- Multiple - the default. Tick any number of values to keep. A caption beside the control reads how the selection is stored: All values when nothing is excluded, All except N when you have unticked some from the full list, or Only N when you have ticked a specific few.
- Condition - match by a rule instead of ticking values, for example a text field that does not contain a word.
Which way the selection is stored decides what happens when a data refresh brings in values that weren't there before. Below the value list, an "Include new values on refresh" switch sets it: on - the filter is stored as "All except …" and new values come in; off - it is stored as "Only …" and the filter stays limited to the values you ticked. Flipping the switch keeps the same values ticked and only changes how they're stored, so it needs the field's whole value list in hand - it is disabled when the list is capped (a live-warehouse field with more distinct values than Golden loaded). Dashboard slicers follow the same rules, with the switch in the slicer's Options panel.
Search a long value list
When a field has many values, type in the "Search values..." box above the list to narrow the rows to the ones that match.
While a search is active, three buttons act on just the matches: Add checks them, Remove unchecks them, and Only these replaces the selection with them. Values the search hides keep whatever state they had. A footer shows how many values are visible and how many are selected in total, and Show all clears the search — so does pressing Esc.
Top N filters
Top N keeps only the highest-ranking values for a dimension - for example, top 10 products by revenue. Adding a Top N filter also sorts the chart so the leaders appear in order. Pick the measure used for ranking from the filter card.
Save and reuse
- Save filter set - stores the current filter list under a name.
- Load filter set - applies a saved set to the current chart.
- Clear all filters - removes every filter that isn't locked.