Drill Into

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

Check-out the given walk-through on the Drill Into functionality.

Drill Into Functionality

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

Pre-requisite: 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.

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

Please Note: The user needs to save the Data Store with the defined hierarchy. Please refer the Data Stores section to know details on how to finish the Data Store creation.

Applying Drill Into Option

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

• The Analyse window opens displaying Year as the highest-level granularity of the date drill.

• Select the Drill into option for drilling down the time-dimension.

Years displayed as default display for the Drill Into option

• By clicking the Yearly granularity of the time value, the user gets the monthly value displayed in the selected view.

Drilling down into a year to get data displaying months

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

Drilling down into a month column to display dates-wise data