Boolean Calculated Fields
Tableau’s calculated fields can be configured to give a true or false result using a variety of boolean functions, such as is a given value a date?, is a given value a null?, and so on. The boolean-type logic can also be expanded into longer-form statements with multiple conditions and more possible outputs than true or false. These logical statements can take the form of either IF or CASE statements.
Boolean or logical calculated field functions could be used in the orders example data source from the introduction to implement logic that flags orders over a specific total sales value. The ISNULL function could also be used to filter out any null orders that have entered the data source by accident.
Boolean Functions
There are a variety of Boolean functions available in Tableau’s calculated fields that return TRUE or FALSE based on the results of a specific test.
The ISNULL function returns TRUE if the value input is null and FALSE...
