Self-Service Visualization
  • What is a Report?
  • Creating a new Report
    • Accessing the Report Module
    • Create New Report
      • Creating a new Report with an Existing Data Store
        • Creating and Updating Instance
      • Creating a new Report by Uploading a File
        • Creating a new Report by Uploading a CSV File
        • Creating a new Report by Uploading an Excel File
      • Creating a new Report with Data Preparation
        • Create a Report with Data Preparation - Inside the Report UI
        • Create a Report with Data Preparation- Partly from Data Center
    • Designing a View
    • Saving Multiple Views
  • Design Canvas
    • Dimension Profiling
    • View Summary
    • Customized Category Color for Dimension
    • Series Properties
    • Create Calculated Field
      • Creating a Formula
        • Record Level Option
        • Summary Level Option
      • Creating 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
    • Sankey chart
    • Word Cloud
  • Report Final Screen
    • Tab
    • Search
    • Create New ML View
    • Shared Views
    • Live Refresh
    • Export
      • Export Properties
    • Alert Center
    • Change Theme
    • Data Store Information
    • Options Assigned to a View
      • Analyse
        • Timeline Play
        • Data Drills
          • Drill Into
          • Drill Through
      • Edit
      • Duplicate
      • Remove
  • 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
      • LOV Settings
  • Interactions
Powered by GitBook
On this page
  • Defining the Hierarchy Drill for a Date Dimension
  • Applying Drill Into Option
  1. Report Final Screen
  2. Options Assigned to a View
  3. Analyse
  4. Data Drills

Drill Into

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

PreviousData DrillsNextDrill Through

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 selected report.

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 Report.

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.

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 from a report. 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.

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