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) |