Adding a Condition Label Column

  • Last update:April 14, 2024
  • 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
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy