> For the complete documentation index, see [llms.txt](https://docs.antsomi.com/cdp-365-user-guide-en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.antsomi.com/cdp-365-user-guide-en/insights/reports/make-reports-interactive/let-viewers-drill-down-into-your-data.md).
# Let viewers drill down into your data
Turn on drill-down to explore data hierarchies.
Drilling down gives viewers a way to reveal additional levels of detail within a chart.
For example, suppose you want to report on sessions by country, and sessions by city. Rather than include two charts in your report, you can include a single chart with drill-down enabled. When drill-down is enabled on a chart, you can
* **Drill down** from a higher level of detail to a lower one (e.g., from Country to City).
* **Drill up** from a lower level of detail to a higher one (e.g., from City to Country).
Adding drill-down charts to your reports can make them more interactive, reduce the number of separate charts required, and make it easier to find insights at various levels of detail in the data.
### Turn on drill-down for a chart
1. Edit your report.
2. Select a chart.
3. On the right, in the DATA properties panel under *Dimension*, turn on **Drill down**.
4. Add dimensions to the chart. Each dimension you add becomes another level of detail you can drill into.
5. Select the **Default drill down level**.
***Legend*****:**
1. Add dimensions.
2. Turn on drill down. (Note: you need to turn this on before you can add drill-down dimensions.)
3. Set the default drill-down level.
### How drill-down works
To add drill-down capability to a chart, you'll define a dimension *hierarchy*. The hierarchy defines the levels of detail that chart can display when you drill down or up. Example hierarchies include:
* Date (Year > Month > Day)
* Geography (Country > Region > City)
* Product (Department > Category > SKU)
* Google Analytics events (Event Category > Event Action > Event Label)
The order in which you list the dimensions within the hierarchy matters. As a rule of thumb, you should define hierarchies to always go from the most general to the most specific. For example, defining a geographic hierarchy as Country > City > Region could produce undesirable results, because you're going from a general level to a more detailed level, then back to a more general level.
Drill down into all values
1. View your report
2. Choose a chart in which you've turned on drill-down
3. Click the up and down arrows to see details
**Example: drill down to see all cities**
The chart below displays sessions by country. The chart has a drill-down hierarchy defined for the *Country* and *City* dimensions. To drill down and see the sessions for all cities, click on up or down arrow to see details.
This displays all the cities, regardless of which country they are in.
### Turn off drill-down for a chart
To turn off drill-down:
1. Edit your report.
2. Select the chart.
3. On the right, in the DATA properties panel, turn off **Drill down**.
### Drill-down and pivot tables
You can see additional levels of detail in a pivot table by turning on expand-collapse. You can then show or hide the data from the dimension hierarchy in the pivot table by clicking + and – in the column header. [Learn more about pivot tables](broken://pages/-MfvwwUJCsONiCv41nIc).
### Limits of drill-down
* Drill-down doesn't apply to dimensionless charts, such as scorecards and bullet charts.
* Geo charts don’t support all geographic field types within all zoom areas. See the [Geo chart reference](broken://pages/-MfvvJubVkQQ7W6GBn3D) for more details.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.antsomi.com/cdp-365-user-guide-en/insights/reports/make-reports-interactive/let-viewers-drill-down-into-your-data.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
**Example: drill down to see all cities**
The chart below displays sessions by country. The chart has a drill-down hierarchy defined for the *Country* and *City* dimensions. To drill down and see the sessions for all cities, click on up or down arrow to see details.
This displays all the cities, regardless of which country they are in.
