# Drill Through

{% hint style="success" %}
*Check out the walk-through given below on how to configure the Drill Through functionality among the multiple charting components in the Designer.*
{% endhint %}

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FEtVBIObdJRmw0qA4ZHlC%2FColor%20from%20drill%20from%20chart%20to%20chart%20.gif?alt=media&#x26;token=c4c299f3-f07e-4d69-91e2-af23b6539819" alt=""><figcaption></figcaption></figure>

## Creating Data Source Connections for Charts <a href="#creating-data-source-connections-for-charts" id="creating-data-source-connections-for-charts"></a>

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

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)*&#x200B;

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

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FYTqNF7mvxEwmph7GiU82%2Fimage.png?alt=media&#x26;token=63cb29e9-e3f9-45ec-97c1-b6f8f515eedd" alt=""><figcaption></figcaption></figure>

* 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 <a href="#enabling-drilldown-option" id="enabling-drilldown-option"></a>

* Apply the following actions:
  * Click on the ***Script on Load*** tab.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FvXDahht4RkJj5u9Ed5BZ%2Fimage.png?alt=media&#x26;token=b015f03c-71b9-4af0-bed6-49416b5204ad" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FfnCcgvXSXMllzkdXlgw8%2Fimage.png?alt=media&#x26;token=1f6ca51c-83d6-4824-b545-86355249c190" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FUpwoqaMiRYPGU0Povm9u%2Fimage.png?alt=media&#x26;token=fc270a67-1fc6-43a1-a329-6c36a397253d" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FHufzf5lzEyT53QuWTdYK%2Fimage.png?alt=media&#x26;token=9e87d24f-7a22-4fa2-9cc3-25cd2084ef91" alt=""><figcaption></figcaption></figure>