> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-visualization/governed-dashboards/configuration/drill-through.md).
# Drill Through
{% hint style="info" %}
Check out the walk-through given below on how to configure the Drill Through functionality among the multiple charting components in the Designer.
{% endhint %}
### Creating Data Source Connections for Charts
* Click on the ***Data source*** icon provided on the right side of the canvas, and view the data connectivity options (ex: CSV, Excel, etc.,) for a dashboard.
* Click on the icon to create a new connection. E.g., Excel Data Connection.
{% hint style="info" %} Please Note: *Since we wish to perform drill-down analysis where we can select a piece of the Pie chart and the column chart will change to reflect that, we need to create two data sources (i.e. Bar and Column)*
{% endhint %}
#### **Fill in the following details:**
1. **Name:** Name the connection
2. **Browse:** Navigate to the Excel file that you wish to use as a data source.
3. **Sheet Name**: Select the sheet you wish to use from the Excel file you have selected.
4. **Load at Start:** Enabling this option refreshes the data source before opening the charts.
* Click on the ***Charts*** icon provided on the right side of the canvas. A list of available components will be displayed. Drag and drop the ***Column chart*** component onto the canvas.
* Connect the Column chart component to an existing data connection:
* Click on the Dataset at appears next to the chart.
* Select a connection from the ***Available Connections*** dropdown menu (ex: Column)
* Drag and drop the fields to their respective series and categories.
* Connect the Bar chart to an existing data connection:
* Click on the Dataset at appears next to the chart.
* Select a connection from the ***Available Connections*** dropdown (E.g., Bar)
* Drag and drop the fields to their respective series and categories.
### Enabling Drilldown Option
* Apply the following actions:
* Click on the ***Script on Load*** tab.
* Apply the ***Auto Reload*** function.
* Click on the ***Data Connectors*** icon provided on the right side of the canvas. Select the ***Column*** data source which is listed under the ***Excel*** data source. Select the ***Condition*** tab and in the ***Conditions text area***, type the field name which you wish to use to filter data.
* Select the condition from the dropdown list and enable the ***Action*** checkbox (as shown in the above image).
* Click on the ***Preview*** button to perform a drill-down analysis.
---
# 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.bdb.ai/bdb-documentation/data-visualization/governed-dashboards/configuration/drill-through.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.