Drill Through
Check out the walk-through given below on how to configure the Drill Through functionality among the multiple charting components in the Designer.
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FEtVBIObdJRmw0qA4ZHlC%252FColor%2520from%2520drill%2520from%2520chart%2520to%2520chart%2520.gif%3Falt%3Dmedia%26token%3Dc4c299f3-f07e-4d69-91e2-af23b6539819&width=768&dpr=4&quality=100&sign=88186684&sv=1)
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.
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)
Fill in the following details:
Name: Name the connection
Browse: Navigate to the Excel file that you wish to use as a data source.
Sheet Name: Select the sheet you wish to use from the Excel file you have selected.
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://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FYTqNF7mvxEwmph7GiU82%252Fimage.png%3Falt%3Dmedia%26token%3D63cb29e9-e3f9-45ec-97c1-b6f8f515eedd&width=768&dpr=4&quality=100&sign=5a9f66cf&sv=1)
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.
![](https://docs.bdb.ai/~gitbook/image?url=https%3A%2F%2F859511478-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FGDmsjfjJBNqow7Fo97cO%252Fuploads%252FvXDahht4RkJj5u9Ed5BZ%252Fimage.png%3Falt%3Dmedia%26token%3Db015f03c-71b9-4af0-bed6-49416b5204ad&width=768&dpr=4&quality=100&sign=1e5b73a0&sv=1)
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.