| AND | Returns True if all expressions passed are True | AND(logical_expression1, logical_expression2, logical_expression3...) |
| AVG | Returns the mean for all parameters passed in the function. Parameters should be numbers. | AVG(value1, value2, value3...) |
| CONCAT | Return the concatenation for all parameters passed splitted by commas. You can change the split characters.
The characters indicates in sep parameter (as a string, ie: ", ") will be the characters to split all values, and it is optional.
The result for SUM(value1, value2, sep" | ") will be "value1 | value2". | CONCAT(value1, value2, value3..., sep=characters) |
| DATEDIF | Calculates the number of days, months, or years between two dates. Unit should be "days", "months" or "years".
If you passed a bad unit we calculated using days as default. | DATEDIF(start_date, end_date, unit) |
| DIVIDE | Returns the result of dividing the two parameters passed in the function (value1 / value2). Parameters should be numbers.
If second parameter is 0, the function returns 0 | DIVIDE(value1, value2) |
| IF | If first parameter is True returns the second one. Returns the third one otherwise. | IF(logical_expression, value_if_true, value_if_false) |
| ISOWEEK | Returns a number representing the week of the year where the provided date falls, in ISO format (starting on Monday). | ISOWEEK(date) |
| ISOYEARWEEK | Returns the Year and week for a specific date falls in, YYYY|W format. Week is iso format (starting on Monday).
In case youe select LookerStudio format option, the format will be YYYY-W. | ISOYEARWEEK(date) |
| MAX | Return the maximum value of all parameters passed in the function. Parameters should be numbers. | MAX(value1, value2, value3...) |
| MIN | Return the minimum value of all parameters passed in the function. Parameters should be numbers. | MIN(value1, value2, value3...) |
| MINUS | Returns the subtraction for all parameters passed in the function (value1 - value2 - value3...). Parameters should be numbers. | MINUS(value1, value2, value3...) |
| MONTH | Returns the month of the year a specific date falls in, in numeric format. | MONTH(date) |
| MULTIPLY | Returns the multiplication for all parameters passed in the function. Parameters should be numbers. | MULTIPLY(value1, value2, value3...) |
| NOT | Returns the opposite of a logical value. NOT(TRUE) return FALSE. | NOT(logical_expression) |
| NOW | Returns the current date and time as a date (YYYY-MM-DD HH:mm:ss format). | NOW() |
| OR | Returns True if one of all expressions passed is True | OR(logical_expression1, logical_expression2, logical_expression3...) |
| POWER | Returns the result of the power the two parameters passed in the function (value1 ^ value2). Parameters should be numbers. | POWER(value1, value2) |
| SUM | Returns the sum for all parameters passed in the function. Parameters should be numbers. | SUM(value1, value2, value3...) |
| TODAY | Returns the current date (YYYY-MM-DD format). | TODAY() |
| WEEK | Returns a number representing the week of the year where the provided date falls. | WEEK(date) |
| WEEKDAY | Returns the week day a specific date falls in, in numeric format, 0-> Monday ... 6-> sunday. | WEEKDAY(date) |
| YEAR | Returns the year a specific date falls in, in numeric format. | YEAR(date) |
| YEARMONTH | Returns the Year and month for a specific date falls in, YYYY|MM format
In case youe select LookerStudio format option, the format will be YYYY-MM. | YEARMONTH(date) |
| YEARWEEK | Returns the Year and week for a specific date falls in, YYYY|U format
In case youe select LookerStudio format option, the format will be YYYY-U. | YEARWEEK(date) |
