> 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 %}

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FBpasGNPTr2Sci6bP7ULE%2FColor%20from%20drill%20from%20chart%20to%20chart%20.gif?alt=media\&token=c4c299f3-f07e-4d69-91e2-af23b6539819)

### 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" %} <mark style="color:green;">Please Note:</mark> *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.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FEJfG6pkJy8x0gkSLS1Os%2Fimage.png?alt=media\&token=63cb29e9-e3f9-45ec-97c1-b6f8f515eedd)

* 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.&#x20;

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F4eB0jECzruaC8s22fO0n%2Fimage.png?alt=media\&token=b015f03c-71b9-4af0-bed6-49416b5204ad)

* Apply the ***Auto Reload*** function.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FyEW5wovovVAzUHayD05U%2Fimage.png?alt=media\&token=1f6ca51c-83d6-4824-b545-86355249c190)

* 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.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FRc29wqjL3f6DJ0uw9Tvu%2Fimage.png?alt=media\&token=fc270a67-1fc6-43a1-a329-6c36a397253d)

* 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.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FCr9voz8SZCCXfzTAQghO%2Fimage.png?alt=media\&token=9e87d24f-7a22-4fa2-9cc3-25cd2084ef91)

&#x20;