反馈已提交

网络繁忙

Adding a Condition Label Column

  • Last update:  2024-04-14
  • Overview

    Version

    Version

    Functional Change

    6.0.5

    /

    Application Scenario

    Condition Label Column allows you to label rows that meet different conditions accordingly.

    For example, in Excel, a nested IF formula is required to achieve the following effect, while in FineBI, you can easily achieve the effect by adding a condition label column. 

    Assign a Pass label to rows where the values of the Math, Chinese, and English fields are all greater than or equal to 60.

    Assign a Partially Pass label to rows where at least one of the Math, Chinese, and English fields has a value greater than or equal to 60.

    Assign a Fail label to rows where the values of the Math, Chinese, and Englisfields are all less than 60.

     41885132e8a8c665abfaf69e6d736a7.png

    Function Description

    The logic of Condition Label Column is similar to that of a nested IF functions.

    For example, if you add a conditional column Pass or Not using the Condition Label Column function, the judgment basis is similar to the following nested IF formula. 

    if(and(Math≥60,Chinese≥60,English≥60),"Pass",if(or(Math≥60,Chinese≥60,English≥60),"Partially Pass","Fail")).

    The data are judged by label condition according to the label order. The data that meet the condition of a label do not participate in the judgment of succeeding labels. So the label order affects the calculation results.

    197107e90f81572445a14d74ee4b8cc.png

    Example

    You can download the sample data: Scores.xlsx.

    Upload the sample data to the analysis subject, as shown in the following figure.

    2a62a2e87b736c72022894f05243deb.png

    Adding a Condition Label Column

    1. Click Condition Label Column. Click Add Condition(AND). Assign a Pass label to rows where the values of the Math, Chinese, and English fields are all greater than or equal to 60.

    15781062e8b3e4b454fb027f2ddf1f8.png

    2. Continue to label the remaining data after labeling a portion of data as Pass.

    Assign a Partially Pass label to rows where at least one of the Math, Chinese, and English fields has a value greater than or equal to 60.

    ae39cf0c083eee69b121c4bf1e4caf1.png

    3. Label the remaining data as Fail.

    735cd11edad4c8fe1b9c716f2776668.png

    Function Detail

    Setting the Label Value with Formulas

    The format of the label value is Text by default, and you can directly enter the text in the input box. Or you can use a formula to calculate the label value, as shown in the following figure.

    605c5ecb5b3742b6e0a2d04800c99b4.png

    Dragging to Change the Label Order

    You can drag to change the label order, which decides the priority of the label condition judgment.

    动画1.gif

    Copying/Deleting the Label

    Click the 1d92fe6a2f514e368556513dd211b2f.png icon to copy or delete labels as needed.

    3eeeab36c36cb91e52e8ce278dafba2.png

    附件列表


    主题: Adding and Editing Data
    • Helpful
    • Not helpful
    • Only read

    feedback

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

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

    不再提示

    10s后关闭