CASE is often easier to use than IIF or IF THENĮLSE. ExampleīUFFER(MAKEPOINT(47.59, -122.32), 5, 'km') CASEįunction to perform logical tests and returnĪppropriate values. This function can only be created with a live connection and will continue to work when a data source is converted to an extract. Supported unit names: meters ("meters," "metres" "m"), kilometers ("kilometers," "kilometres," "km"), miles ("miles" or "mi"), feet ("feet," "ft"). Returns distance measurement between two points in a specified unit. 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. Returns the total surface area of a spatial polygon. 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.
0 Comments
Leave a Reply. |