> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lightdash.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Interacting with dashboards

> Filter, re-zoom, cross-filter, and drill into the charts on a dashboard without editing them

Everything on this page is something a viewer can do to a dashboard without editing it: narrow it with filters, change the time granularity of its charts, filter the whole dashboard by clicking a value in one chart, look at the rows behind a data point, and break a metric out by a dimension.

## Filter the dashboard

Filters sit at the top of a dashboard and change the data in the tiles below. Click a filter to change its value, or click `Add filter` to add your own — the filters you add yourself are temporary, so nobody else's view changes.

Editors can save filters into the dashboard, require viewers to pick a value before anything loads, and control which tiles each filter reaches. See [dashboard filters](/explore/dashboards/filter) for all of it.

## Change the date granularity

Date zoom changes the granularity of time-based charts — Day, Week, Month, and so on — without editing them. Editors set up controls that govern every chart at once, or just a chosen subset.

<Frame>
  <img src="https://mintcdn.com/lightdash/y8j5qvbhHoP381ni/images/explore/dashboards/interact/date-zoom-indicator.png?fit=max&auto=format&n=y8j5qvbhHoP381ni&q=85&s=d0357e5ce3d2857b6293d3607cebb0bb" alt="A date zoom control in a dashboard toolbar" width="2532" height="1588" data-path="images/explore/dashboards/interact/date-zoom-indicator.png" />
</Frame>

See [date zoom](/explore/dashboards/date-zoom) for creating controls, configuring granularities, and setting defaults.

## Cross-filtering from a chart

Clicking a value in a chart — a bar in a bar chart, say — lets you filter on that value and update every other relevant chart in the dashboard. Filtering a dashboard from one of its own charts is called cross-filtering.

<Frame>
  <img src="https://mintcdn.com/lightdash/y8j5qvbhHoP381ni/images/explore/dashboards/interact/cross-filtering-63382ed7d03de05338666c7b353b8c59.png?fit=max&auto=format&n=y8j5qvbhHoP381ni&q=85&s=05d176fc3b48b104b33d268ba94505b2" alt="Choosing to filter the dashboard by a value clicked in a chart" width="2972" height="1146" data-path="images/explore/dashboards/interact/cross-filtering-63382ed7d03de05338666c7b353b8c59.png" />
</Frame>

Every tile in the dashboard that has the filtered field is filtered to the value you picked. Hover over a tile and then over the funnel icon to see which filter it got.

<Frame>
  <img src="https://mintcdn.com/lightdash/y8j5qvbhHoP381ni/images/explore/dashboards/interact/cross-filtering-applied.png?fit=max&auto=format&n=y8j5qvbhHoP381ni&q=85&s=569f3e11545cd674a930e8af62a6441e" alt="Hovering a tile to see which dashboard filter was applied to it" width="1517" height="1215" data-path="images/explore/dashboards/interact/cross-filtering-applied.png" />
</Frame>

A cross-filter is a [temporary filter](/explore/dashboards/filter#temporary-filters): it belongs to your session until you save it into the dashboard.

## View underlying data

Click any point on a chart or any cell in a results table and pick **View underlying data** in the action menu to see the records that make up that number.

For example, clicking the bar for a month in a `Sales stats per partner, per month` chart shows every row in the underlying table that adds up to that month's total.

<Frame>
  <img src="https://mintcdn.com/lightdash/y8j5qvbhHoP381ni/images/explore/dashboards/interact/underlying-chart-data-a0e12f23869f743416d5171473196d4d.png?fit=max&auto=format&n=y8j5qvbhHoP381ni&q=85&s=051b1ccdf38e44d6abeb75204a11bb8c" alt="The underlying data for a point on a dashboard chart" width="2766" height="1118" data-path="images/explore/dashboards/interact/underlying-chart-data-a0e12f23869f743416d5171473196d4d.png" />
</Frame>

From there you can export the rows as a CSV, or click **Explore from here** to open [the Explore view](/explore/explore-view) with that underlying data as the starting point.

### Choosing which fields appear

By default, underlying data shows every dimension from the table, plus every field from any joined table included in your results. To show a narrower set instead, specify the fields on the metric in your table's `.yml` file — see [show underlying values](/semantic-layer/metrics#show-underlying-values) in the metrics reference.

Those same fields are pre-selected when someone clicks **Explore from here** from the underlying data table, so they don't land in an empty results table.

## Drill into a metric

Drilling breaks a metric out by a dimension — total revenue segmented by product type, for example — so you can see where a number came from. **Drill into** works on metrics only, not on dimensions or table calculations.

Take a chart of **Sum of basket total** per partner, per month, with a conspicuous spike in sales for one partner in May. To find out why, click the data point and then click **Drill into** in the action menu.

<Frame>
  <img src="https://mintcdn.com/lightdash/y8j5qvbhHoP381ni/images/explore/dashboards/interact/drill-into-dashboard-chart-004fed51a421665d0117c29ae4c6fe21.png?fit=max&auto=format&n=y8j5qvbhHoP381ni&q=85&s=927e9802e578cf41f0e2e7c7ddb18f32" alt="The Drill into option in a chart's action menu" width="2272" height="904" data-path="images/explore/dashboards/interact/drill-into-dashboard-chart-004fed51a421665d0117c29ae4c6fe21.png" />
</Frame>

Then pick the dimension to segment the metric by. Here that's **Shipping country**, to see where the orders came from.

<Frame>
  <img src="https://mintcdn.com/lightdash/y8j5qvbhHoP381ni/images/explore/dashboards/interact/drill-into-modal-007439f50eddd908ece58e2fb553a737.png?fit=max&auto=format&n=y8j5qvbhHoP381ni&q=85&s=e639093956d1bd44ddfca8291929c744" alt="Choosing a dimension to drill a metric into" width="956" height="396" data-path="images/explore/dashboards/interact/drill-into-modal-007439f50eddd908ece58e2fb553a737.png" />
</Frame>

Click **Open in new tab** for a chart of the metric grouped by `Shipping country`, which shows where the spike came from.

<Frame>
  <img src="https://mintcdn.com/lightdash/y8j5qvbhHoP381ni/images/explore/dashboards/interact/drill-into-result-day-eeb57dc6490792f406ae2d218e172706.png?fit=max&auto=format&n=y8j5qvbhHoP381ni&q=85&s=2dac4fece5f7bd62d1a5a8dd1975a6d3" alt="The drilled chart, showing the metric grouped by shipping country" width="2738" height="1022" data-path="images/explore/dashboards/interact/drill-into-result-day-eeb57dc6490792f406ae2d218e172706.png" />
</Frame>
