Usage of CASE-WHEN in Tableau is very limited as they cannot perform boolean algebra conditionsĢ.
CASE-WHEN statements perform faster than IF-ELSE statementsġ.
Because of its simplicity, for a user, it is helpful to avoid making mistakes like referencing the wrong fieldģ. CASE-WHEN statements are easier to write and comprehend.Ģ. This function finds the first that matches the given and returns the corresponding ġ. In case no default value is being mentioned by the user then “NULL” is being returned.
If in logical expression no match is found then the value of default return expression is used. It starts with “CASE” function evaluating the 1 st logical expression corresponding to set/sequence of values and when the logical expression becomes True, it returns the respective specified value as result. Check out Tableau For Data Science Course for more tips and tricks or 40 Awesome Tableau Keyboard Shortcuts “CASE-WHEN” are used to perform the logical test and return the required value when the test expression is true. “CASE-WHEN” is the part of Logical functions in Tableau.
Tableau Case Function – When Should You Use it? CASE and Nested Case Functions in Tableau Summary:
