Self-Service Visualization
  • What is Story?
  • Creating a new Story
    • Accessing the Story Module
    • Create New Story
      • Creating a new Story with an Existing Data Store
        • Creating and Updating Instance
      • Creating a new Story by Uploading a File (CSV/Excel)
      • Creating a new Story based on a Data Sandbox Data Store with Data Preparations
    • Designing a View
    • Saving Multiple Views
  • Design Workspace
    • Dimension Profiling
    • Measure Summary
    • Series Properties
    • Create Calculated Field
      • Creating a Formula
        • Record Level Option
        • Summary Level Option
      • Creating a Range
    • Order by and Limit
    • Adding a Slicer
  • Chart Gallery
    • Mixed chart
    • Area chart
    • Bar chart
    • Bubble chart
    • Column Stack chart
    • Line chart
    • Pie chart
    • Scattered Plot chart
    • TreeMap chart
    • Circumplex chart
    • Pareto chart
    • Semi Gauge
    • KPI Tile
    • KPI Tile: Comparative Tile
    • KPI Tile: Sparkline
    • Map
    • Data Grid
    • Metric Summary
    • Dissolution/Decomposition chart
    • Spider chart
    • Waterfall chart
    • Funnel chart
    • Inverted Funnel chart
    • Heat Map chart
    • Geo chart
  • Storyboard
    • Search
    • Shared Views
    • Live Refresh
    • Export
    • Alert Center
    • Change Theme
    • Data Store Information
    • Options Assigned to a View
      • Analyse
        • Timeline Play
      • Edit
      • Remove
    • Data Interactions/ Data Drills
      • Drill Into
      • Drill Through
  • Applying Filters
    • View Specific Filter
      • Dimension-based View Filter
      • Measure-based View Filter
      • Date-based View Filter
    • Global Filter
      • Exclude from the Global Filter
      • Saving a Global Filter
      • Custom View Filter
      • Like and Not Like Filter Operations
  • Interactions
Powered by GitBook
On this page
  • Defining the Hierarchy Drill for a Date Dimension
  • Applying Drill Into Option
  1. Storyboard
  2. Data Interactions/ Data Drills

Drill Into

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

PreviousData Interactions/ Data DrillsNextDrill Through

Last updated 2 years ago

Check-out the given walk-through on the 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.

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.

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

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

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

Data Stores
Drill Into Functionality
Defining Hierarchy for a Date Dimension
Years displayed as default display for the Drill Into option
Drilling down into a year to get data displaying months
Drilling down into a month column to display dates-wise data