Documentation
  • The Fundamental
  • ACTIVE SYNC
    • Data Ingestion
      • Data Tracking
        • API Key Management
        • Generate Tracking ID
        • Install tracking with Tag Manager
        • Install Tracking from the Console
        • Tracking Method on Website
      • Datasource
        • MySQL
        • PostgreSQL
        • MongoDB
        • Microsoft SQL Server
        • Shopify
        • CSV
        • Google Sheets
    • Data Ingestion API
      • Data Lake
        • File upload
        • Tracking API
      • Data Warehouse
        • Batch upload
        • CSV upload
        • Tracking API
      • Data Schema Warehouse API
    • Data Integrations
      • Manage your API Key
      • Get Data using API
  • ROCKET.BI
    • Introduction
    • Data Warehouse
      • Data Management
      • Ad-hoc Query
        • Measure Schema
        • Calculated Field
      • Query Analysis
      • Relationship
    • Row-level Security
    • Dashboard
      • Dashboard Filter
      • Chart Control
        • Tab Control
        • Single Choice
        • Multiple Choice
        • Dropdown Control
        • Slicer Control
        • Date Control
        • Input Control
      • Manage Dashboard
        • Relationship
        • View and Share
        • Select Main Date Filter
        • Boost
        • Settings
        • Add Chart
        • Add Tab
        • Add Text
    • Chart Builder
      • Chart Types
        • Pie Chart
        • Column Chart
        • Bar Chart
        • Line Chart
        • Line Stock Chart
        • Pareto Chart
        • Bubble Chart
        • Scatter Chart
        • Map Chart
        • Area Chart
        • KPI Chart
        • Lollipop Chart
        • Parliament Chart
        • Funnel Chart
        • Pyramid Chart
        • Gauge Chart
        • Bullet Graph Chart
        • Heat Map Chart
        • Word Cloud Chart
        • Tree Map Chart
        • Stacked Column Chart
        • Stacked Bar Chart
        • Sankey Chart
        • Spider Web Chart
        • Wind Rose Chart
        • Histogram Chart
        • Bell Curve Chart
        • Table Chart
        • Pivot Table Chart
      • Chart Settings
        • Zoom
        • Inner chart filter
      • Chart Filters
        • Tab Filter
        • Single Choice
        • Multiple Choice
        • Dropdown Filter
        • Slicer Filter
        • Date Filter
        • Input Filter
      • Right-click Settings
        • Change date function
        • Drill down
        • Drill through
        • Use as a filter
    • SQL Query
      • Syntax
      • Functions
      • Aggregate Functions
      • Data Types
  • UNLOCK.CI
    • Unlock.CI
Powered by GitBook
On this page
  • What is drill down?
  • How to set up a Drill down?
  • Demo
  1. ROCKET.BI
  2. Chart Builder
  3. Right-click Settings

Drill down

Allow users to view details rather than just a broad view of data

PreviousChange date functionNextDrill through

Last updated 2 years ago

What is drill down?

By clicking on a metric in a chart, users can quickly take a deep dive into a dataset by drilling down from that metric. It allows users to descend from one level of a specified data stack to the next to explore detailed information in a chart from various perspectives.

How to set up a Drill down?

1. Right-click on a chart to open a dropdown menu, then click Drill down. If you right-click on a specific metric of a chart, it will start drilling down directly from that metric.

2. Select a dimension to drill down

Use cases

By drilling down into a specific order date, a spider web chart on sales performance results by item type might allow a user to better understand why one order date (in this case is 2017) outperformed another.

The chart is automatically refreshed with additional detail after clicking on Item Type dimension, this displays all item types 2017 and their various sales performances. In this case, you can see that Household has the greatest sales performance in 2017.

The value chosen is typically used as a filter for the level down each time a user drills down in a chart. When a user drills down to Region, they will only see the regions for the Household dimension, not all the regions.

3. To further explore that specific metric, right-click in the chart/metric and continue to select the dimension to drill down

4. Clicking the name of the dimension to drill up

5. To remove drill down, right-click on the chart/metric then click Reset drill down

Demo

Here is a demo of how to set up a drill down in a spider web chart