Help Center/ DataArts Insight/ Best Practices/ Using Cascading Controls for Secondary Filtering Queries
Updated on 2025-02-25 GMT+08:00
View PDF
Share

Using Cascading Controls for Secondary Filtering Queries

Query controls can perform data queries on tables within the dashboard, while cascading controls can achieve secondary filtering queries. The combined use of query controls and cascading controls helps improve the efficiency of user data queries. This article demonstrates how to set the query conditions for province and city, and how to achieve linkage between these two query conditions through the cascading function. When a user selects a province, the city will automatically update to display only the cities within that province, thereby simplifying the query process.

Step 1: Create a Table

  1. Log in to the DataArts Insight console.
  2. Click in the upper left corner of the management console to select a region and select an enterprise project from Enterprise Project in the lower left corner of the Workspace page.
  3. Click the name of the desired project in the My Projects area in the right pane.
  4. In the navigation pane on the left, choose Data Analytics > Dashboard. On the displayed page, click Create Dashboard.
  5. In the top navigation bar on the dashboard creation page, click Add Chart and select Table.
  6. Select the dataset to analyze from the Data area on the right of the dashboard creation page.
  7. Set the parameters on the Field, Style, and Advanced tab pages.
  8. Click Update on the Fields tab. The chart data is automatically updated.
    Figure 1 Creating a table

Step 2: Create a Query Control

  1. In the top navigation bar on the dashboard creation page, click to create a query control.
  2. In the newly created query control, click to create a query condition, and select Dropdown list as the display type.
    • Create a query control named province. Specifically, in the displayed Query Control Settings dialog box, select a dataset and the query field in the Condition Configuration area and select the chart and field to be associated (province) on the Associated Charts tab on the right.
    • Create a query control named city. Specifically, in the displayed Query Control Settings dialog box, select a dataset and the query field in the Condition Configuration area, select the chart and field to be associated (city) on the Associated Charts tab on the right, and set the rest parameters the same as those set during the creation of the province query control.
      Figure 2 Query control settings

Step 3: Configure a Cascading Control

  1. Click in the upper right corner of the query control.
  2. For the province query condition, configure the cascading control by checking city and selecting the field province, as shown in Figure 3.
    After successfully setting up the cascading control, when selecting province_A in the province query condition, the city query condition will only display cities within province_A (Figure 4).
    Figure 3 Configuring a cascading control

    Figure 4 Cascading control effect

Step 4: Query Data

  1. Select the desired province and city in the province and city query conditions.
  2. Click Search in the lower right corner of the page. The queried data is displayed in the table.
Figure 5 Query results