# 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;


---

# Agent Instructions: 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:

```
GET https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/storyboard/data-interactions-data-drills/drill-into.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.