The Pearson correlation measures the linear relationship between two variables. Returns the Pearson correlation coefficient of two expressions. “alcu”) = true CORR(expression 1, expression2) If the given string contains the specified substring. ExampleĬOLLECT () CONTAINS(string, substring) Note: The COLLECT function can only be used with spatial fields. ExampleĪn aggregate calculation that combines the values in the argument field. Rounds a number to the nearest integer of equal or greater value. 'Wed' THEN 3 WHEN 'Thu' THEN 4 WHEN 'Fri' THEN 5 WHEN 'Sat' THEN 6 END CEILING(number) WHEN 'West' THEN 1 WHEN 'East' THEN 2 ELSE 3 ENDĭate]),3) WHEN 'Sun' THEN 0 WHEN 'Mon' THEN 1 WHEN 'Tue' THEN 2 WHEN Times you can use a group to get the same results as a complicated case
The CASE function will generally be more concise. Typically, you use an IF function to perform a sequence of arbitrary tests,Īnd you use a CASE function to search for a match to an expression.īut a CASE function can always be rewritten as an IF function, although When a value that matches expression is encountered, CASE returns the corresponding return value. It to a sequence of values, value1, value2, etc., and returns a result. The CASE function evaluates expression, compares CASE is often easier to use than IIF or IF THENĮLSE. Value2 THEN return2.ELSE default return ENDįunction to perform logical tests and returnĪppropriate values. CASE expression WHEN value1 THEN return1 WHEN Returns the value of the expression if it has a single value for all rows. = 1.5652408283942 ATAN2(y number, x number)Īrc tangent of two given numbers (x and y). Exampleįor the first character of string. The absolute value for all the numbers contained in the Budget Variance field. You can also press Ctrl+F (Command-F on a Mac) to open a search box that you can use to search the page for a specific function.Ī B C D E F G H I J K L M N O P Q R S T U V W X Y Z If no functions start with that letter, the functions that start with the next letter in the alphabet are shown. Click a letter to see functions that start with it. The Tableau functions in this reference are organized alphabetically.