Explain the Logical Function ' THEN' in Tableau with Example?

 There is no specific logical function called "THEN" in Tableau.However, "THEN" is a keyword used in conjunction with the "IF" function in Tableau to specify the result if the condition evaluates to true. The "IF" function allows you to perform conditional evaluations and return different values based on a specified condition.

The syntax of the "IF" function in Tableau is as follows:

IF condition THEN result_if_true [ELSE result_if_false] END

In this syntax, the "THEN" keyword is used to indicate the result that will be returned if the condition specified in the "IF" function evaluates to true. The "ELSE" keyword is used to specify the result if the condition evaluates to false.

Here's an example to illustrate how the "THEN" keyword is used with the "IF" function in Tableau:

Suppose you have a dataset of students and their scores, and you want to create a calculated field that categorizes students as either "Pass" or "Fail" based on a passing score threshold of 70.

IF [Score] >= 70 THEN 'Pass' ELSE 'Fail' END

In this example, the "THEN" keyword is used to specify the result 'Pass' if the condition [Score] >= 70 evaluates to true. If the condition evaluates to false, the "ELSE" keyword is used to specify the result 'Fail'.

Please note that "THEN" is not a standalone logical function but rather a keyword used in combination with the "IF" function in Tableau to define the result based on the condition evaluation.