Skip to main content

Function Library Index (Locked)

~150 Tableau Studio functions across 8 categories. HC#2 discipline: signatures looked up here, never guessed. Version-gated status called out inline.

Categories​

Each function group has its own file. INDEX lists which function belongs where.

CategoryFileFunction Count
Numbernumber.md~25
Stringstring.md~30
Datedate.md~25
Logicallogical.md~15
Aggregateaggregate.md~10
LODlod.md3 (FIXED, INCLUDE, EXCLUDE)
Table Calctable_calc.md~20
Spatialspatial.md~10
Type Conversiontype_conversion.md~10

Version-Gated Functions​

:

FunctionCategoryMinimum Desktop Version
MAKEPOINTSpatial2019.2
BUFFERSpatial2024.1
MAKELINESpatial2019.2
DISTANCESpatial2019.2
INTERSECTSSpatial2019.2
USEREMAILLogical2023.3
MODEL_QUANTILENumber2020.3
MODEL_PERCENTILENumber2020.3
REGEXP_MATCHString2013.1 (all supported)
REGEXP_EXTRACTString2013.1 (all supported)
REGEXP_REPLACEString2013.1 (all supported)
DATEPARSEDate8.2 (all supported)
MAKEDATEDate2020.1
MAKEDATETIMEDate2020.1
MAKETIMEDate2020.1

Common Row-Level Functions (Number)​

ABS, CEILING, DIV, EXP, FLOOR, LN, LOG, MAX, MIN, PI, POWER, RADIANS, ROUND, SIGN, SIN, SQRT, SQUARE, TAN, ZN, IIF, IIFNULL

Common Aggregate Functions​

SUM, AVG, MEDIAN, COUNT, COUNTD, MIN, MAX, ATTR, PERCENTILE, STDEV, STDEVP, VAR, VARP, CORR, COVAR, COVARP

Common String Functions​

ASCII, CHAR, CONTAINS, ENDSWITH, FIND, FINDNTH, LEFT, LEN, LOWER, LTRIM, MAX, MID, MIN, PROPER, REPLACE, RIGHT, RTRIM, SPACE, SPLIT, STARTSWITH, TRIM, UPPER, REGEXP_MATCH, REGEXP_EXTRACT, REGEXP_REPLACE

Common Date Functions​

DATEADD, DATEDIFF, DATENAME, DATEPART, DATEPARSE, DATETRUNC, DAY, MONTH, NOW, TODAY, YEAR, WEEK, QUARTER, MAKEDATE, MAKEDATETIME, MAKETIME, ISDATE

Common Logical Functions​

IF ... THEN ... ELSEIF ... ELSE ... END, CASE ... WHEN ... THEN ... ELSE ... END, IFNULL, ISNULL, IIF, AND, OR, NOT, IN, USERNAME, USEREMAIL, ISUSERADMIN, ISFULLNAME

Common Table Calcs​

WINDOW_SUM, WINDOW_AVG, WINDOW_COUNT, WINDOW_MAX, WINDOW_MIN, WINDOW_MEDIAN, WINDOW_STDEV, WINDOW_VAR, RUNNING_SUM, RUNNING_AVG, RUNNING_COUNT, RUNNING_MAX, RUNNING_MIN, PREVIOUS_VALUE, INDEX, RANK, RANK_DENSE, RANK_MODIFIED, RANK_PERCENTILE, RANK_UNIQUE, FIRST, LAST, LOOKUP, SIZE, TOTAL

LOD Expressions​

{FIXED [dim1], [dim2] : agg([measure])} {INCLUDE [dim1], [dim2] : agg([measure])} {EXCLUDE [dim1], [dim2] : agg([measure])}

Common Spatial Functions​

MAKEPOINT, MAKELINE, DISTANCE, BUFFER, INTERSECTS, AREA, LENGTH, CENTROID, X, Y

Type Conversion​

INT, FLOAT, STR, DATE, DATETIME, BOOL

Refuse to Fabricate​

If the user's ask requires a function not listed above, refuse the write per HC#2. Never invent a signature.

For the full signature, return type, and LOD/TC eligibility of each function, see the category-specific .md files in this folder. Every entry cites help.tableau.com as source of truth.