> ## Documentation Index
> Fetch the complete documentation index at: https://lightdash-codex-prod-439-nested-repeated-columns.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Filtering in the Explore view

> Add filters from the Filters tab, the field sidebar, or the results table, and nest them into groups

Filters restrict the data a query returns. Filtering a chart in the Explore view changes that chart alone — to filter every tile on a dashboard at once, see [dashboard filters](/explore/dashboards/filter). For the filter types and operators available on each field type, see the [filters reference](/explore/filters-reference).

There are three places to add a filter, and they all produce the same thing.

## From the Filters tab

Open the `Filters` toggle, then click `Add filter`.

<Frame>
  <img src="https://mintcdn.com/lightdash-codex-prod-439-nested-repeated-columns/923w50wJafd1NUVD/images/explore/explore-view/filter/adding-filters-from-toggle-1-ce5fc6c2ad6259dcae43a9ff16937ffc.jpg?fit=max&auto=format&n=923w50wJafd1NUVD&q=85&s=398b2a7538002b071a991939a0c6f4aa" alt="Adding a filter from the Filters tab in the Explore view" width="2898" height="1430" data-path="images/explore/explore-view/filter/adding-filters-from-toggle-1-ce5fc6c2ad6259dcae43a9ff16937ffc.jpg" />
</Frame>

Select the field to filter from the drop-down list, then choose the filtering options.

## From the sidebar

Click the `options` for a field in the sidebar list, then click `add filter`. The filter icon that appears when you hover over a dimension or metric does the same thing.

<Frame>
  <img src="https://mintcdn.com/lightdash-codex-prod-439-nested-repeated-columns/923w50wJafd1NUVD/images/explore/explore-view/filter/add-filter-sidebar-32d08090746e3cd362b982a7238b9b6f.jpg?fit=max&auto=format&n=923w50wJafd1NUVD&q=85&s=5e67e7bedb07eae49f5bbe93632d1c9b" alt="Adding a filter from a field in the Explore sidebar" width="2772" height="1494" data-path="images/explore/explore-view/filter/add-filter-sidebar-32d08090746e3cd362b982a7238b9b6f.jpg" />
</Frame>

## From the results table

Once you have results, click the three-dot menu of the column you want to filter on and choose `Filter by [field name]`, or click a value in the table to filter by that value.

<Frame>
  <img src="https://mintcdn.com/lightdash-codex-prod-439-nested-repeated-columns/923w50wJafd1NUVD/images/explore/explore-view/filter/add-filter-results-table-52825577533d8ee37e5b9031e7bd54d0.jpg?fit=max&auto=format&n=923w50wJafd1NUVD&q=85&s=611e744e897c0c32caa336412289a565" alt="Adding a filter from the results table column menu" width="2132" height="1940" data-path="images/explore/explore-view/filter/add-filter-results-table-52825577533d8ee37e5b9031e7bd54d0.jpg" />
</Frame>

<Frame>
  <img src="https://mintcdn.com/lightdash-codex-prod-439-nested-repeated-columns/923w50wJafd1NUVD/images/explore/explore-view/filter/add-filter.png?fit=max&auto=format&n=923w50wJafd1NUVD&q=85&s=8bea460618102c6cfc1fbccef3930d86" alt="The filter added from the results table showing in the Filters section" width="2550" height="1563" data-path="images/explore/explore-view/filter/add-filter.png" />
</Frame>

## Nested filters

To nest filters, click the options button on the right-hand side of a filter and choose `convert to group`.

<Frame>
  <img src="https://mintcdn.com/lightdash-codex-prod-439-nested-repeated-columns/923w50wJafd1NUVD/images/explore/explore-view/filter/convert-to-filter-group-c9f2d2a4a0260d5f8b869c9d156b07a9.png?fit=max&auto=format&n=923w50wJafd1NUVD&q=85&s=1bae934f1a1d1a01815f86d75d064bb9" alt="Converting a filter into a filter group" width="1427" height="304" data-path="images/explore/explore-view/filter/convert-to-filter-group-c9f2d2a4a0260d5f8b869c9d156b07a9.png" />
</Frame>

Then add a filter to the group by clicking `add filter`.

<Frame>
  <img src="https://mintcdn.com/lightdash-codex-prod-439-nested-repeated-columns/923w50wJafd1NUVD/images/explore/explore-view/filter/nested-filters-eae25b7df33e4f47b1408d8a7bfd8ce5.png?fit=max&auto=format&n=923w50wJafd1NUVD&q=85&s=f95f6c1c722511b570b4afbaec778d1c" alt="A nested filter group with two conditions" width="1425" height="439" data-path="images/explore/explore-view/filter/nested-filters-eae25b7df33e4f47b1408d8a7bfd8ce5.png" />
</Frame>
