Adding a Condition Label Column

Version

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 English fields are all less than 60.

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.

You can download the sample data: Scores.xlsx.

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

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.

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.

3. Label the remaining data as Fail.

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.

Dragging to Change the Label Order

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

Copying/Deleting the Label

Click the  icon to copy or delete labels as needed.