> 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/self-service/storyboard/data-interactions-data-drills/drill-into.md).

# Drill Into

{% hint style="success" %}
Check-out the given walk-through on the Drill Into functionality.
{% endhint %}

![Dill into functionality](/files/psGOlsjlFZBE54DjtBm9)

The Auto Data Drill allows users to drill down in the time values of a saved view on the storyboard for the selected story. 

{% hint style="info" %} <mark style="color:green;">Pre-requisite:</mark> The user must define a hierarchical pattern among the date dimensions under the Data Center Module before using the Data Drill/ Drill into functionality in Story.
{% endhint %}

### Defining the Hierarchy Drill for a Date Dimension

* Select an existing Data Store (or you can define the hierarchy while creating a new Data Store).
* Navigate to the ***Hierarchy Definition*** tab.
* Select a Date Dimension field.
* Click the add icon to add a new ***Drill Def*** space.
* Drag the selected Data Dimension to the ***Drill Def*** space (By default the dragged Date Dimension gets divided into 3 granularity levels).
* Click the ***Next*** option.

![Defining Hierarchy for a Date Dimension](/files/9ixoa0n9Pw2kTiGjKRxA)

{% hint style="info" %} <mark style="color:green;">Please Note:</mark> The user needs to save the Data Store with the defined hierarchy. Please refer the [<mark style="color:blue;">**Data Stores**</mark>](/bdb-documentation/data-center/data-stores.md) section to know details on how to finish the Data Store creation.
{% endhint %}

### Using the Drill Into option in the Story module

* Select the time dimension with the defined hierarchy drill and drag it to create a View.
* Click the **Save** icon to save the view on the Storyboard.

&#x20;    &#x20;

![Time Dimension based View](/files/FPyc3y2Lyqghue6wOYrF)

* Access the saved view on the Storyboard. Use the double-clicks to open it in the Analyse mode or Click the Analyse option for the saved View.

&#x20;     <img src="/files/Rky3cWjEzkxlMkCgsp3r" alt="" data-size="original">

* The **Analyse** window opens displaying ***Year*** as the highest-level granularity of the date drill.  &#x20;
* Select the ***Drill into*** option for drilling down the time-dimension.                                 &#x20;

![Years displayed as default display for the Drill Into option ](/files/vijhVzzB5iqP16g4Z9M0)

* By clicking the Yearly granularity of the time value, the user gets the monthly value displayed in the selected view.                          &#x20;

![Drilling down into a year to get data displaying months](/files/nnrerRzoPpn7VQ6dobz6)

* Click on the monthly granularity to display the exact dates of joining.

![Drilling down into a month column to display dates-wise data ](/files/IP2O35rHWPQmZaT8gSGw)

&#x20;                                   &#x20;