Switch - Multiple Condition Assignment

1. Function Definition

The SWITCH function can make judgements on multiple conditions and return corresponding results based on different values.

Note:

The Else statement is not supported in the SWITCH function.

2. Notes

• At least three parameters are required.

• At least 3 parameters are required for real-time data, and the result parameters must be of the same type.

• If the parameter is of the date type, the function needs to nest a date function inside, for example, SWITCH(Date,TODATE("2022/01/01"),"1")

3. Example

When you need to judge many conditions, it may be cumbersome to use the IF function to judge each condition. In this case, the SWITCH function can be used for multiple condition assignment.

For example, you can set the class name by the SWITCH function. If the current value is Class1, display "Class A"; if it is Class2, display "Class B"; if it is Class3, display "Class C"; otherwise, display "Class D".

Sample Data:Score Table.xlsx

Adding Data

1. Upload Score Table to FineBI. Click My Analysis and click New Analysis. Click Local Excel > Upload Data in the pop-up box, as shown in the following figure.

2. After clicking Upload Data, click OK to upload the data and create the analysis subject, as shown in the following figure.

Perform Condition Assignment

1. Open the dataset editing page, click Formula Column, and enter SWITCH(Class,"Class1","Class A","Class2","Class B","Class3","Class C","Class D"). Enter the column name as Class in Alphabetical Order, and click OK, as shown in the following figure.

Note:

The Class field in the formula is not manually entered, but selected from the fields on the left.

2. The following table describes the formula.

Effect Display

The following figure shows the effect.