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 the Data Center
    • Designing a View
    • Saving Multiple Views
  • Design Canvas
    • Dimension Profiling
    • View Measure Summary
    • Customize Category Color
    • Series Properties
    • Create Calculated Field
      • Creating a Formula
        • Record Level Formula
        • Summary Level Formula
      • 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
    • Candlestick chart
    • Benchmark Analysis
  • Report Final Screen
    • Tab
    • Search
    • Create a New ML View
    • Shared Views
    • Live Refresh
    • Export
      • Export Properties
    • Change Theme
    • Data Store Information
    • Options Assigned to a View
      • Analyse
        • Timeline Play
        • Data Drills
          • Drill Into
          • Drill Through
      • Editing a saved View
      • 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
Export as PDF
  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 the 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: To save the Data Store with the defined hierarchy. Please refer to the Data Store section for more details about the Datastore creation process.

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 Functionalty
Defining Hierarchy for a Date Dimension
View displaying the highest unit of Time (Year)
Drilling down into a year to get data displaying months
Drilling down into a month column to display dates-wise data