Select Analysis > Create Calculated Field. To open the list of functions in Tableau: PERCENTILE(,0.90) ).Īt any time in Tableau, you can look up how to use and format a particular function. The PERCENTILE function, on the other hand, requires the following syntax: PERCENTILE(expression, number) (i.e. For instance, the SUM function requires the following syntax: SUM(expression) (i.e. In Tableau, functions are the main components of a calculation and can be used for a variety of different purposes.įunctions are colored blue in Tableau calculations.Įvery function in Tableau requires a particular syntax. See the following sections to learn more about the different components of Tableau calculations and how to format them to work in Tableau. Multi-line comments can be added by typing /* to start the comment and */ to end it. See Add comments to a calculation for more information. To enter a comment in a calculation, type two forward slashes //. See Create Parameters for more information. See Literal expression syntax for more information.Ī parameter in a calculation is surrounded by brackets. String literals are written with quotation marks.ĭate literals are written with the # symbol.

See Operator syntax for information on the types of operators you can use in Tableau calculations, as well as the order they are performed in a formula. IF > 000 THEN 'Highly Profitable'ĮLSEIF and, =,, ^, AND, OR, NOT, ( ). “as is”, such as 'Profitable' and 'Unprofitable'.įor example, consider the following calculation: Literal expressions - Constant values that are represented Operators - Symbols that denote an operation. There are four basic components to calculations in Tableau:įunctions - Statements used to transform the values or members in a field.įields - Dimensions or measures (columns) from your data source.

It lists the basic components of calculations, and explains the proper syntax for each. This article describes how to create and format calculations in Tableau.

Cant insert equation in word online