Sprinkle Docs
  • What is Sprinkle?
  • Quick Start
  • Analysing your data
    • 🔭Analytics Overview
    • 💠Data Models
      • *️Variables
      • 🌲Hierarchies
      • 🤿Column Mask
    • 🎉Switch to New Reports & Dashboards
    • 🆕Reports
      • Overview
      • Build Using Tables
        • Create a new Report
        • Layout and options
        • Build and Format - Overview
        • Apply Row Limits
        • Identify Date Columns
        • Filter your data
        • Visualizations
          • Table
          • Pivot
          • Line Chart
          • Bar Chart
          • Column Chart
          • Area Chart
          • Combo Chart
          • Scatter & Bubble Plot
          • Pie Chart
          • Funnel Chart
          • Stat Card
          • Point Map
          • Heat Map
          • Radial gauge chart
        • Advanced Features
          • Custom Analysis
          • Variables
          • Table & Quick Calculations
          • Drill - Hierarchical & Date
          • Break Out
          • RLS in Table reports
          • Scheduled Exports
          • Embedding Table Reports
      • Build Using Models
        • Create a new report
        • Layout and options
        • Visualizations
        • Advanced Features
      • Build SQL Reports
        • Create a new Report
        • Layout and options
        • Writing a SQL Code on Editor
        • Visualizations
        • Variables in SQL Reports
    • 🆕Dashboards
      • 🌀Filters
      • 👆Click Behaviour
      • ⏰Data Alerts
      • 🗓️Date Drill
      • 📤Scheduled Exports
      • 🔗Embed link
      • 🖥️Dashboard layout
      • 📱Mobile Dashboards
  • Transforming your data
    • 🔰SQL Transform
    • 📓Python Notebooks
  • Integrating your data
    • ☁️Destination Warehouses
      • AWS Athena
        • Manage storage of Flow tables
      • AWS Redshift
      • Azure Synapse
      • Databricks
      • Google BigQuery
      • MySQL
      • Postgres
      • Snowflake
      • SQL Server
      • K8 Setup
        • AWS EKS
        • Google GKE
        • Azure AKS
    • ⚙️Warehouse & Storage Setup
  • Ingesting your data
    • ☄️Data Imports
      • Databases
        • Azure Cosmos DB
        • Azure Table Storage
        • Google BigQuery
        • Mongo DB
        • MySQL DB
        • Oracle DB
        • Postgres DB
        • SQL Server DB
        • Features
          • Ingestion Modes
          • Add Multiple Datasets
          • CDC Setup
            • CDC setup in Mysql
            • CDC setup in Postgres
            • CDC setup in Mongo
            • CDC setup in SQL Server
          • Destination Create Table Clause
          • SSH Tunnel Setup
      • Files
        • AWS S3
        • AWS S3 External
        • Azure Blob
        • FTP
        • Google Cloud Storage
        • Google Sheet
        • SFTP
      • Applications
        • Apple Search Ads
        • Appsflyer
        • Branch
        • Clevertap
        • Facebook Ads
        • Freshdesk
        • Freshsales
        • Google Ads
        • Google Ads V2
        • Google Analytics
        • Google Analytics 4
        • Google Analytics MCF
        • Google Search Console
        • Hubspot
        • Impact Ads
        • Intercom
        • Klaviyo
        • Leadsquared
        • LinkedIn Ads
        • Magento
        • Mailchimp
        • Marketo
        • Mixpanel
        • MoEngage
        • Rocketlane
        • Salesforce
        • SAP S4
        • Shopify
        • Snapchat Marketing
        • TikTok Ads
        • WooCommerce
        • Zendesk Chat
        • Zendesk Support
        • Zoho Analytics
        • Zoho Books
        • Zoho CRM
        • Zoho Desk
        • Zoho Invoice
        • Zoho Subscription
      • Events
        • Apache Kafka
        • AWS Kinesis
        • Azure EventHub
    • 📤File Uploads
    • 🤖API Pulls
    • 🕸️Webhooks
  • Collaborating on data
    • 📤Sharing
    • 💬Comments
    • ⚡Activity
    • 🏷️Labels
  • Managing Schedules and Data Refreshes
    • ⏱️Schedules
    • 🔔Notifications
  • User Management
    • 🔑Access Management
    • 🧑‍🤝‍🧑Groups
    • 📂Folders
    • 🔄Syncing users, groups and RLS
    • 📧Azure AD Integration
  • Data Security & Privacy
    • 🔐Security at Sprinkle
    • 📄GDPR
    • 📄Privacy Policy
  • Release Notes
    • 📢Release Notes
      • 🗒️Release Notes - v12.1 (New)
      • 🗒️Release Notes - v12.0
      • 🗒️Release Notes - v11.0
      • 🗒️Release Notes - v10.8
      • 🗒️Release Notes - v10.7
      • 🗒️Release Notes - v10.6
      • 🗒️Release Notes - v10.5
      • 🗒️Release Notes - v10.4
      • 🗒️Release Notes - v10.3
      • 🗒️Release Notes - v10.2
      • 🗒️Release Notes - v10.1
      • 🗒️Release Notes - v10.0
      • 🗒️Release Notes - v9.31
      • 🗒️Release Notes - v9.30
      • 🗒️Release Notes - v9.29
      • 🗒️Release Notes - v9.28
      • 🗒️Release Notes - v9.27
      • 🗒️Release Notes - v9.25
      • 🗒️Release Notes - v9.24
      • 🗒️Release Notes - v9.23
      • 🗒️Release Notes - v9.22
      • 🗒️Release Notes - v9.21
      • 🗒️Release Notes - v9.20
      • 🗒️Release Notes - v9.19
      • 🗒️Release Notes - v9.18
      • 🗒️Release Notes - v9.17
      • 🗒️Release Notes - v9.16
      • 🗒️Release Notes - v9.14
      • 🗒️Release Notes - v9.13
      • 🗒️Release Notes - v9.12
      • 🗒️Release Notes -v9.8
      • 🗒️Release Notes - v9.7
      • 🗒️Release Notes - v9.6
      • 🗒️Release Notes - v9.5
      • 🗒️Release Notes - v9.4
      • 🗒️Release Notes - v9.3
      • 🗒️Release Notes - v9.2
      • 🗒️Release Notes - v9.1
      • 🗒️Release Notes - v9.0 (Major)
      • 🗒️Release Notes - v7.23
      • 🗒️Release Notes - v7.21
      • 🗒️Release Notes - v7.20
      • 🗒️Release Notes - v7.15
      • 🗒️Release Notes - v7.14
      • 🗒️Release Notes - v7.13
Powered by GitBook
On this page
  • Overview
  • Creating Hierarchies
  • Using Hierarchy in Build Settings
  • Build level controls for hierarchies.
  • How to Drill Up and Down?
  1. Analysing your data
  2. Reports
  3. Build Using Tables
  4. Advanced Features

Drill - Hierarchical & Date

Overview

The Reports and Dashboards (New) enables you to drill down and drill up on your data. The drill feature is designed to enhance the data exploration on Sprinkle.

The drill feature empowers users to perform interactive analysis, explore trends, and make data-driven decisions more effectively.

In order to use the drill feature in Reports, you would need to define hierarchies at the report level. Then drop the hierarchy(ies) in the build field in the visualization settings.

Creating Hierarchies

We now have the option to create hierarchies at the report level.

In the Edit mode of your report, on the left-most pane (inputs pane), go to any column, that you want to start the hierarchy with.

On hovering you can see the more option icon -> create hierarchy.

All the created Hierarchies will appear in the columns section along with other columns.

In the case of building reports using a Model as input, the hierarchies created at the model level are available under the column section. Hierarchies brought from the Model level are not editable in the reports.

You can create a new hierarchy for the report by clicking on +Create Hierarchy. The Hierarchy modal opens up.

  • Name: Provide a name to your hierarchy.

  • Hierarchy Type: This could be of Date or Non-Date type.

    • The date type allows you to create Date hierarchies, which create date levels, like Year, Quarter, Month, etc. You may choose from multiple date-level options. For eg: for a date column - order date, you may choose levels like Year and Quarter for your report.

    • Non-Date: This lets you select different columns at the hierarchy levels. For eg: Country, State, City.

  • Select Columns: (for Non-Date type) Select columns at different levels of the hierarchy, starting with the top-most level and going down to the bottom levels.

  • Click on Add when done. It creates a hierarchy that is available in the hierarchy section.

Using Hierarchy in Build Settings

Once you have the hierarchies, you may use them in the build settings by dropping them in the required field.

Table: For table visualization type, you can drop hierarchies (one or more) in the Group by field.

Charts: You can drop the hierarchies in the primary axis of a chart.

  • Line/ Area/ Column Chart: X-Axis

  • Bar Chart: Y-Axis

  • Pie/ Funnel: Category

  • Scatter/ Bubble: X-Axis

  • Combo: Not Available for Drill

Pivot: Drill is not supported as of now on the pivot. So, you cannot drop the hierarchy in the Pivot settings.

Build level controls for hierarchies.

  • Once hierarchies are dropped in the build section, all the sub-fields that are in the hierarchy are also to be shown along with checkboxes. For example, the location hierarchy consists of columns "Country", "State" & "City". All of these are to be displayed in the build section.

  • If you want to remove a field from a hierarchy, then you don't have to create a new hierarchy. You can simply uncheck the field from the hierarchy from the build section. Say for eg, you remove the state field by unticking the check box, now when you drill, you will be able to drill from country to city level.

  • This way you don't have to create multiple hierarchies with the same fields. You can use the same hierarchy and just uncheck the fields from the build section itself, in case you don't want to drill to that level.

  • Additionally, when hovering over the drill arrows, a tooltip will show what level the drill will take you.

  • This should help you work faster and also give context to what fields are present in the hierarchy.

How to Drill Up and Down?

Drill action is available on both Reports & Dashboard.

If your visualization has been configured with hierarchies, the drill option will be available to you. There are two flavors of Drill action you can perform.

All at once: You can click on the arrows on top of the visualization to go up or down the hierarchy all at once. For eg: If you are on country-level sales data and you drill down, you go to state-level data.

Selected Drill Down: You may select a data point and then drill down on it. For eg: on State-level sales data, you click on the cell, where the State is Equal to Karnataka (India), and then click on drill down. In that case, the next level of data shows City level sales data for cities only in Karnataka (India). Doing a selected drill-down passes the dimension (categorical) value of the selected data point as a filter to the next level of the data.

PreviousTable & Quick CalculationsNextBreak Out

Last updated 1 month ago

🆕