Functions
A number of different functions are available for use in expressions.
The functions are grouped according to their type:
- Binning functions
Binning is a way to group a number of more or less continuous values into a smaller number of "bins". - Conversion functions
Available conversion functions are listed. - Cast method
You find an overview below of what will happen when a column is cast from one data type to another. - Date and time functions
The list below shows date and time functions that can be used in expressions. - Keywords in expressions
There are a number of different keywords that can be included in different types of expressions. See below for a description. The keywords are not case-sensitive. - Logical functions
The list below shows the logical functions that can be used in expressions. - Math functions
The list shows the math functions you can use in expressions. - OVER functions
The OVER functions are used to determine how data should be sliced, for example, relative to time periods. - Property functions
The list shows property functions that you can use in expressions. - Ranking functions
The list shows the ranking functions that you can use in expressions. - Spatial functions
Use the spatial functions to transform data so it can be used to create map charts. - Statistical functions
The list shows the statistical functions that you can use in expressions. - Text functions
The list shows the text functions that you can use in expressions.
Parent topic: Expression language details