Quick BI:Drilling

Scenarios

When viewing company sales data, you can drill down to change the analysis granularity. For example, drill down from a region to a province to view data at a finer geographical level.

Limits

The following charts support the drilling feature:

• Tables: cross tables, detail tables, multidimensional analysis tables, and heat maps.

• Line/Area charts: line charts, area charts, stacked area charts, 100% stacked area charts, and combination charts.

• Column/Bar charts: column charts, stacked column charts, 100% stacked column charts, circular bar charts, ranking boards, bar charts, stacked bar charts, 100% stacked bar charts, waterfall charts, bullet charts, and box plots.

• Pie/Doughnut charts: pie charts, rose charts, radar charts, and treemap charts.

• Bubble/Scatter charts: bubble charts and scatter charts.

• Geo: colored maps, bubble maps, and symbol maps.

• Other charts: word cloud charts.

Step 1: Edit the Dataset

1. On the dataset editing page, in the field outline or data preview interface, hover over the target field, click the icon, and select Field Type Switch > Geo > Area.

   This example uses the area field.

2. (Optional)

   Create a hierarchy.

   Perform this operation if your data has a hierarchical drilling structure.

   1. In the dimension list, locate the target geographical information field. As shown in the following figure, click Create Hierarchy.

      

   2. On the Create/Edit Hierarchy page, enter a name for the hierarchy, add the hierarchy fields, and then click OK.

      Alternatively, you can click the icon next to the target field, select Move To Area_hierarchy, and then move the other geographic information dimension fields into this hierarchy.

3. The system automatically displays the data in the table.

4. After you edit the dataset, you can click Save.

Step 2: Create a Dashboard

You can create two dashboards. This example creates the Company Market Data dashboard first.

1. Log on to the Quick BI console.

2. Go to the dashboard page.

3. As shown in the following figure, select Sales Data as the dashboard dataset and name the dashboard Company Market Data.

   

4. You can add a pie chart to the dashboard and name it Regional Order Quantity Proportion Analysis.

Step 3: Configure and Display Drilling

Configuration Steps

You can manually configure drilling. This example uses a pie chart.

1. On the Fields tab of the pie chart, click the icon on the right side of the target dimension Area.

   

   If filter interaction is enabled for the pie chart, a pop-up window appears when you configure drilling. This window lets you choose whether clicking triggers filter interaction or drilling. For more information, see Method 2: Configure from the Advanced Configuration entry point.

2. Configure the drilling hierarchy.

   In this example, the drilling order is Area > Province > City.

   You can also perform the following operations:

   • To add a drilling dimension, drag the desired dimension to the Drilling/Dimension area and adjust its order.

   • Change the drilling order: In the Drilling/Dimension area, select the target field and drag it to adjust its position.

   • Delete a drilling dimension: In the Drilling/Dimensions area, select the target field and click the icon.

   Note

   Cross tables support up to three drilling items. Other charts support only one drilling item. You can set up to six drilling levels.

3. Click the Update button.

   If the status icon is set to Always show, the icon appears on the right side of the chart title, as shown in the following figure. For more information about how to set the status icon, see Configure title.

   

Display Results

• PC

  Click the South China region. The chart drills down to the Province Data Proportion for that region. Click the Guangdong province. The chart drills down to the City Data Proportion for that province.To roll up from the city data proportion to the province, click the Province label at the bottom-left of the chart. You can also click the region to roll up.

• Mobile

  • Mobile

    • Select the South China region. In the interactive analysis action bar, click the Drill down button. The chart drills down to the Province Data Proportion for that region. Select the Guangdong province and click the Drill down button in the interactive analysis action bar. The chart drills down to the City Data Proportion for that province.

      To roll up from the city data proportion to the province, click the Province label below the chart. You can also select the region and click the Roll up button in the interactive analysis action bar to roll up.

      If the current chart supports the tooltip feature and the tooltip hover bubble is enabled, the drill-down entry appears in the tooltip hover bubble.

  • You can long press on a mobile device to perform drill-down operations.

    In Page Settings > Advanced > Interaction Control, select Long press on mobile to drill down.

    

    You can now long press to drill down on a mobile device.

    You can long press the Chart area or Data label text area to drill down.

    

    Note

    Only pie charts, doughnut charts, rose charts, and treemap charts support long pressing the Chart area to drill down.

    Only pie charts, doughnut charts, and rose charts support long pressing the Data label text area to drill down.

Configure Drilling Hierarchy Row Display

Entry Point

As shown in the following figure, on the (①) Analyze tab of the Regional Order Quantity Proportion Analysis pie chart, click Drilling in the Data Interaction area to expand the (②) Configuration items.

Configuration Item Descriptions

Configure Drill-down Auxiliary Fields

Auxiliary fields are dynamically added after drill-down fields during drill-down operations to provide supplemental information about primary fields.

Scenarios

For organizational structure data such as Headquarters (Level 1 Organization) > Region (Level 2 Organization) > Partition (Level 3 Organization), you might want to see the corresponding owner at each level. Configure auxiliary fields for drilling dimensions to dynamically display this information as you drill down.

Procedure

1. In the following cross table, the drilling feature is configured with the drilling sequence Level 1 Organization -> Level 2 Organization -> Level 3 Organization. For more information about the configuration procedure, see Step 3: Configure and Display Drilling.

   

2. Hover over the dimension for which you want to set an auxiliary field, click the drop-down arrow, and select Auxiliary field from the menu. The configuration dialog box appears.

   

3. In the configuration dialog box, select the auxiliary field under the Level 1 Organization field. Add the Level 1 Owner field, set the alignment to Align center, and set the display name to Level 1 Owner.

   

4. After you configure the auxiliary field for the Level 1 Organization field, configure the Level 2 Organization field. Add the Level 2 Owner field, set the alignment to Align left, and set the display name to Level 2 Owner.

   

5. After you configure the auxiliary field for the Level 2 Organization field, configure the Level 3 Organization field. Add the Level 3 Owner field, set the alignment to Align left, and set the display name to Level 3 Owner.

   

6. Click Confirm to complete the configuration. The result is shown in the following figure. You can view the owner and other data for the Headquarters (Level 1 Organization). After you click the headquarters, you can see the owner and other data for the East China and South China regions. After you click the South China region, you can view the owner and other data for the Guangfo, Shenzhen, and Fujian partitions.

   

Related Operations

The preceding steps configure drilling for a single chart. To have associated charts automatically synchronize to the same analysis level when you drill down, configure synchronized drilling. For more information, see Set up synchronized drilling.