Level 2: Filtering Dimensions Depending on Indicators

  • Last update:  2024-07-07
  • Overview

    Version

    Version

    Functional Change

    6.1

    /

    Application Scenario

    The function is to filter dimension fields using indicator fields as the filtering condition to filter the detailed data that meets the condition. /

    For example, you can filter the data of customers with the value of the field Sales Volume more than 100000 to quickly calculate the data of the number of high-spending customers for each product and their corresponding sales volume.

    3411aee22adb88cacb9b840ff140424.png

    You can filter the data of customers with the value of the field Order Number equal to or more than 2 to quickly calculate the data of the number of repeat customers for each product and their corresponding sales volume.

    7c0f86217ad69d7b9a36ac82cc62015.png

    Function Description

    Filtering by the group to which the dimension fields belong is detail-level filtering, which takes effect at the second level (column addition filtering) due to its cross-row calculations like the DEF functions.

    The scope of the dependent indicators used as conditions in dimension filtering:

    The dimension fields can only be filtered depending on the indicator fields already dragged into the analysis area and not performed quick calculations yet.

    The detail table component does support this filtering.

    iconNote:
    If multiple filtering conditions with "and/or" relationships (including conditions on the dimension field itself and the dependent indicator field) are added to a dimension field, the filter will take effect at the second level.

    Example

    Click and download the sample data: Office Supplies Data.xlsx.

    1. Create an analysis subject and upload the sample data. Create a calculation field named Customer Number, as shown in the following figure.

    The formula COUNTD_AGG(Customer) is to perform a deduplication count on the value of the field Customer to obtain the number of customers.

    图片1.png

    2. Drag the fields Product, Customer Number, and Sales Volume into the analysis area to calculate the number of customers and sales volume for each product, as shown in the following figure.

    图片3.png

    Filtering to Calculate the Data of Products with a Customer Number Value of more than 200

    You only need to analyze the data of the products with a value of the field Customer Number more than 200. Therefore, you can filter the detailed data of products that meet the condition.

    You can filter the dimension fields in the analysis area through the following two entries.

    Entry one: Click the 0990753d2d38298fc6d3dabce6d1cd7.png icon next to the field Product Name, select Filter from the drop-down list, delete the original filtering condition, click the Add Condition button, select the field Customer Number, and set Customer Number to More than, Fixed Value, and 200 in sequence.

    图片2.png

    Entry two: Drag the field Product Name into Filter, delete the original filtering condition, click the Add Condition button, select the field Customer Number, and set Customer Number to More than, Fixed Value, and 200 in sequence.

    3.2.2.gif

    Filtering to Calculate the Data of High-Spending Customers

    You only need to perform a component calculation on data of customers with the value of the field Sales Volume more than 100000. Therefore, you can filter the detailed information of customers that meet the condition.

    Drag the field Customer into Filter, delete the original condition, click the Add Condition button, select the field Sales Volume, and set Sales Volume to More than, Fixed Value, and 100000 in sequence, as shown in the following figure.

    2.2.gif

    The following figure shows the calculation result of the component after filtering.

    cf59f74768c2eff7cd442fffe961195.png

    Filtering to Calculate the Data of Repeat Customers

    You only need to perform a component calculation on data of customers with the value of the field Order Number more than 2. Therefore, you can filter the detailed information of customers that meet the condition.

    1. Add a calculation field named Order Number, as shown in the following figure.

    The formula COUNTD_AGG(Order Code) is to perform a deduplication count on the value of the field Order Code to obtain the number of orders.

    图片3.png

    2. Since the dimension fields can only be filtered depending on the indicator fields already dragged into the analysis area, if you want to filter the number of customer orders, you need to drag the field Order Number into the analysis area, as shown in the following figure.

    8e211e7b7f61ac2bbc4d84eae8a0704.png

    3. Drag the field Customer into Filter, delete the original condition, click the Add Condition button, select the field Order Number, and set Order Number to More than/Equal to, Fixed Value, and 2 in sequence, as shown in the following figure.

    2.3.gif

    The following figure shows the calculation result of the component after filtering.

    f601c6603ff2767a34addc34e2c09b3.png

    Filtering by Group to Which Dimension Belongs

    You can select Filter by Group to Which Dimension Belongs when the dimension fields already dragged into the analysis area are filtered depending on the indicator fields.

    Drag the fields Signing Date, Product Name, and Region into Dimension and Sales Volume into Indicator, click the 0990753d2d38298fc6d3dabce6d1cd7.png icon next to the field Signing Date, select Year from the drop-down list to calculate and obtain the annual sales volume of different products in different regions.

    c3a9581b2aff3e03b412be9708cb3db.png

    Adding a filtering condition to the field Product Name: Click the Add Condition button, select the field Sales Volume, and set Sales Volume to More than, Fixed Value, and 200000 in sequence. The following content shows the difference between selecting and deselecting Filter by Group to Which Dimension Belongs.

    图片4.png

    Selected

    The value of the field Sales Volume is grouped by Signing Date and Product Name and summed to obtain data of the annual sales volume of each product, which is then filtered to obtain data with a value of more than 200000.

    The following figure shows the calculation result of the data after filtering, namely the data of products with an annual sales volume of more than 200000.

    27209f356da4548ed2ee3dc4db8e7d1.png

    Deselected

    The value of the field Sales Volume is grouped by Product Name and calculated to obtain data of the sales volume of each product, which is then filtered to obtain data with a value of more than 200000.

    Only the value of the total sales volume of Notebook in the field Product Name is less than 200000. Therefore, the data of Notebook is not included in the component calculation.

    f2c15e81a271dff825965189fda021f.png

    Attachment List


    Theme: 可視化コンポーネントの作成
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ

    フィードバック

    鼠标选中内容,快速反馈问题

    鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。

    不再提示

    9s后关闭

    反馈已提交

    网络繁忙