[]
        
(Showing Draft Content)

Drill Down

Drill Down feature allows users to explore the details of hierarchical data. You can drill-down into the dimensions for granular details and you can also drill-up for summarized information. For example, in a dashboard showing the sales revenue for retailers in various countries, you can drill-down to view the sales revenue filtered by country. You can drill-down further to explore the sales revenue for specific product lines sold within that country. You can drill-down even further into product types and individual product SKUs sold within that country.


Cross-filters applied to an associated scenario on applying drill down will retain the cross-filter for all related scenarios as described in the following example. Column chart displays Revenue by Year and the pivot table shows the Gross profit by Year.

  • When a particular Year is selected from the column chart, the data in the pivot table is filtered for the selected year automatically.


    Keep Filter - Selection Scenario

  • On using the Drill Down feature to drill down to a Quarter in the selected Year, the pivot table will retain the data of cross-filter applied earlier.

    Keep Filter - Cross Filter

While analyzing a scenario through Drill Down, the default behavior is to visualize the list of all available dimensions in the dataset, allowing you to easily navigate the hierarchy. You can change the default drill-down behavior in the data-binding step. While binding the data to the scenario, set the Drill Down mode to Pre-set Targets or Pre-set Path.

Pre-set Targets

This feature allows you to drill-down into the data to a selected target dimension. While creating the scenario, you can select a dimension from the list and drill into it.

  1. From the data binding area, set the Drill Down Mode to Pre-set Targets.

    Setting the drill down mode to Pre-set Targets

  2. Drag the dimensions into the Drill Down Targets area. For example, to enable drill-down into - Product Line, Product Type, and Product, specify these dimensions in the drill-down targets.

    Drag the targeted dimensions

  3. Preview the dashboard and one-by-one, select the targets from the 'Drill Down' option.

    Drilling down to limited target dimensions

Pre-set Path

This feature allows you to drill-down into the dashboard in a defined target sequence or path. While drilling, each click takes you one level deeper in the data according to the pre-set path. It is important to note that the list of dimensions is not shown at any level of data.

  1. From the data binding area, set the Drill Down Mode to Pre-set Path.

    Setting the drill down mode to Pre-set Targets

  2. Drag the dimensions into the Drill Down Path area in the sequence in which you want the drill path to be created. For example, to drill down to the following path, Product Line >> Product Type >> Product, drag these dimensions in this sequence.

    Drag the dimensions into a path

  3. Preview the dashboard and click the 'Drill Down' option. To go one more level deep, again click the 'Drill Down' option. Each time you click Drill Down, you go one level deep according to the path set in the target.

    Drilling down to a specific defined path

Drill Down Setting

You can set the display settings like style, position, and font color of the drill path, and change the initialized status text using the Drill Down Setting in the Inspector tab for the dashboard scenario.

drilldwon setting

Property

Description

Position

You can set the display position for the drill-down bar using this property. The dropdown list has the following options: Top Left, Top Center, Top Right, Bottom Left, Bottom Center, and Bottom Right. By default, the Top left is selected.

Home Name

You can select the initialized text for drill down path to be displayed on the preview from here. By default, the value is Home.

Font

You can set the font for the drill down path from the font settings.

Current Level Font Color

You can pick the color for the current level text in the drill down path by using this property.

Other Levels Font Color

You can pick the color for the other level text in the drill down path by using this property.

Example: In the below example, we will show the steps to apply the drill down settings for the drill down path display.

  1. Take a column chart and bind the data set. From the data binding area, set the Drill Down Mode to Pre-set Path.

  2. Drag the dimensions into the Drill Down Path area. For example, to enable drill-down into - Product Type, Product Line, and Product, specify these dimensions in the drill down path.

    drilldown path-data binding


  3. Click the Inspector tab and select the Drill Down Setting.

    drill down setting_inspector tab


  4. Set the properties as per your requirements. In this example we have done the following settings:

  • Position: Top Center

  • Home Name: Home

  • Font Type: Arial Black

  • Current Level Font Color: Blue

  • Other Levels Font Color: Orange

    set the properties as per your choice

  1. Preview the dashboard and one by one, select the paths from the 'Drill Down' option.

    final gif


    Note: Drill Down Setting applies to the following ECharts as well: Column E-Chart, Line E-Chart, Pie E-Chart, Radar E-Chart, Bubble E-Chart, Combined E-Chart, Funnel E-Chart, and 3D Column E-Chart.