---
description: >-
  This data drill allows the user to penetrate into deeper granularity level of
  the time dimension.
---

# Drill Into

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

![Dill into functionality](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FSWAoxs1yHxjQd59dSJd0%2FDrillInto.gif?alt=media\&token=540b57c4-4af0-42c1-b7b5-61b76b4e78b5)

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

{% 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FrFh2Zxw936mFJwoGCbo5%2Fimage.png?alt=media\&token=4b776a86-fe04-4763-aa31-dbd18b49ae85)

{% 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>](../../../../data-center/data-stores) 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FfqhxSKvzdmdapeM8Apnr%2Fimage.png?alt=media\&token=201b05a6-49d3-470f-99c1-f04faa82769d)

* 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="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FbzxRBcaYtRUSyCWdHMTc%2Fimage.png?alt=media&#x26;token=1ac41d43-8fa1-462d-b99c-cc259367149a" 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 ](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FLiDzE9MJSWyCnxIRYst0%2Fimage.png?alt=media\&token=23020904-7ebb-4c5a-8d71-c001dfa7fe8f)

* 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](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FQWSJ7iih8s9MmgFttUHA%2Fimage.png?alt=media\&token=a4ea78af-c1e0-4d6c-aea8-ce1542dff15d)

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

![Drilling down into a month column to display dates-wise data ](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FuBPqJI5m9BGFOkHvqWIE%2Fimage.png?alt=media\&token=fa513580-8dfe-4cf4-b748-0db83a60a564)

&#x20;                                   &#x20;
