An expression column is used to create an expression which is a combination of data columns, operators and built-in functions. This expression column will act as a calculated measure that can be configured to widget like other normal numeric columns as a quantitative measure.
Enter the expression that you like to define in the Expression text area.
Where, content within curly braces is optional.
Following built-in functions are supported in Expression Designer.
| Category |
Functions |
Syntax, Descriptions & Examples |
Numbers |
ABS |
Syntax:
ABS(numeric_expression)
Description:
Returns the absolute value of a given expression.
Example:
ABS([Freight])
|
| Numbers |
ACOS |
Syntax:
ACOS(numeric_expression)
Description:
Returns the inverse cosine (also known as arccosine) of the given numeric expression.
Example:
ACOS(0.25)
|
| Numbers |
ASIN |
Syntax:
ASIN(numeric_expression)
Description:
Returns the inverse sine (also known as arcsine) of the given numeric expression.
Example:
ASIN(0.25)
|
| Numbers |
ATAN |
Syntax:
ATAN(numeric_expression)
Description:
Returns the inverse tangent (also known as arctangent) of the given numeric expression.
Example:
ATAN(0.25)
|
| Numbers |
CEIL |
Syntax:
CEIL(numeric_expression)
Description:
Returns the smallest integer value that is greater than or equal to the given numeric expression.
Example:
CEIL([Freight])
|
| Numbers |
COS |
Syntax:
COS(numeric_expression)
Description:
Returns the cosine of the angle specified in radians in the given expression.
Example:
COS(0.25)
|
| Numbers |
COT |
Syntax:
COT(numeric_expression)
Description:
Returns the cotangent of the angle specified in radians in the given expression.
Example:
COT(0.25)
|
| Numbers |
DEGREES |
Syntax:
DEGREES(numeric_expression)
Description:
Returns the angle in degrees for the one specified in radians in the given numeric expression.
Example:
DEGREES(1.5708)
|
| Numbers |
EXP |
Syntax: EXP(numeric_expression)
Description: Returns the exponential value of the given expression.
Example:
EXP([UnitsInStock])
|
| Numbers |
FLOOR |
Syntax: FLOOR(numeric_expression)
Description: Returns the largest integer value that is less than or equal to the given numeric expression.
Example:
FLOOR([Freight]) |
| Numbers |
MOD |
Syntax: MOD(numeric_expression)
Description: Returns the remainder of the first numeric expression divided by the second numeric expression.
Example:
MOD(36,6)
|
| Numbers |
LOG |
Syntax: LOG(numeric_expression)
Description: Returns the logarithm of the given expression to the specified base.
Example:
LOG(DEGREES(PI()))
|
| Numbers |
PI |
Syntax: PI()
Description: Returns the constant value of PI.
Example:
EXP(PI())
|
| Numbers |
POWER |
Syntax: POWER(expression1, expression2)
Description: Returns the value of the given expression (expression1) to the specified power (expression2).
Example:
POWER(EXP(1), SIN(90))
|
| Numbers |
RADIANS |
Syntax: RADIANS(numeric_expression)
Description: Returns the angle in radians for the one specified in degrees in the given numeric expression.
Example:
RADIANS(90)
|
| Numbers |
ROUND |
Syntax: ROUND(numeric_expression)
Description: Returns a rounded value.
Example:
ROUND([Freight])
|
| Numbers |
SIGN |
Syntax: SIGN(numeric_expression)
Description: Returns a value representing the positive (+1), zero (0), or negative (-1) sign of the given numeric expression.
Example:
SIGN([UnitsOnOrder])
|
| Numbers |
SIN |
Syntax: SIN(numeric_expression)
Description: Returns the sine of the angle specified in radians in the given expression.
Example:
SIN(0.25)
|
| Numbers |
SQRT |
Syntax: SQRT(numeric_expression)
Description: Returns the square root of the given numeric expression.
Example:
SQRT([UnitsInStock])
|
| Numbers |
TOTALPERCENTAGE |
Syntax: TOTALPERCENTAGE(numeric_expression)
Description: Returns the percentage value for each row from the grand total of the given column.
Example:
TOTALPERCENTAGE([Freight])
|
| Numbers |
TAN |
Syntax: TAN(numeric_expression)
Description: Returns the tangent of the given numeric expression.
Example:
TAN(0.25)
|
| Aggregation |
AVG |
Syntax: AVG(numeric_expression)
Description: Returns the average of the values in the given expression.
Example:
AVG([UnitPrice])
|
| Aggregation |
AVGD |
Syntax: AVGD(numeric_expression)
Description: Returns the average of the Distinct values in the given expression.
Example:
AVGD([UnitPrice])
|
| Aggregation |
COUNT |
Syntax: COUNT(numeric_expression)
Description: Returns the number of items in the given expression.
Example:
COUNT([OrderID])
|
| Aggregation |
COUNTD |
Syntax: COUNTD(numeric_expression)
Description: Returns the distinct number of items in the given expression.
Example:
COUNTD([OrderID])
|
| Aggregation |
MAX |
Syntax: MAX(numeric_expression)
Description: Returns the maximum value in the given expression.
Example:
MAX([UnitPrice])
|
| Aggregation |
MIN |
Syntax: MIN(numeric_expression)
Description: Returns the minimum value in the given expression.
Example:
MIN([UnitPrice])
|
| Aggregation |
STDEV |
Syntax: STDEV(numeric_expression)
Description: Returns the standard deviation of values in the given expression.
Example:
STDEV([OrderID])
|
| Aggregation |
SUM |
Syntax: SUM(numeric_expression)
Description: Returns the sum of values in the given expression.
Example:
SUM([UnitPrice])
|
| Aggregation |
SUMD |
Syntax: SUMD(numeric_expression)
Description: Returns the sum of the Distinct values in the given expression.
Example:
SUMD([UnitPrice])
|
| Aggregation |
VAR |
Syntax: VAR(numeric_expression)
Description: Returns the variance of values in the given expression.
Example:
VAR([OrderID])
|
| Aggregation |
TOTAL |
Syntax: TOTAL(numeric_expression)
Description: Returns the total values in the given expression.
Example:
TOTAL(SUM([UnitPrice]))
|
| Conditional |
COALESCE |
Syntax: COALESCE(exp1,exp2,...exp(n))
Description: Returns the first non-NULL expression among its arguments or NULL if all its arguments are NULL.
Example:
COALESCE(3+NULL, 2*NULL, 5*2*7)
|
| Conditional |
IF |
Syntax: IF(expression, true_part, false_part)
Description: Returns either true part or false part, depending on the evaluation of the expression.
Example:
IF([CustomerID]='VINET' AND [OrderID]='10248', [Discount], [Discount]+0.1)
|
| Conditional |
IFNULL |
Syntax: IFNULL(expression1, expression2)
Description: Returns expression1 if the expression1 evaluates to be not null.
Example:
IFNULL([ShipRegion],'Region not specified')
|
| Conditional |
ISNOTNULL |
Syntax: ISNOTNULL(expression)
Description: Returns true if the given expression evaluates to be not null.
Example:
ISNOTNULL([ShipRegion])
|
| Conditional |
ISNULL |
Syntax: ISNULL(expression)
Description: Returns true if the given expression evaluates to null.
Example:
ISNULL([ShipRegion])
|
| Logical |
AND |
Syntax: (expression1) AND (expression2)
Description: Returns true if both the expressions evaluate to true.
Example:
IF([CustomerID]='VINET' AND [OrderID]='10248', [Discount], [Discount]+0.1)
|
| Logical |
NOT |
Syntax: NOT(expression)
Description: Returns the reversed logical value of the expression being evaluated.
Example:
IF(NOT [CustomerID]='VINET', [Freight], [Freight]-100)
|
| Logical |
OR |
Syntax: (expression1) OR (expression2)
Description: Returns true if any of the expressions evaluate to true.
Example:
IF([CustomerID]='VINET' OR [OrderID]='10248', [Discount], [Discount]+0.1)
|
| Date |
CURRENTMONTH |
Syntax: CURRENTMONTH()
Description: Returns the current month.
Example:
CURRENTMONTH()
|
| Date |
CURRENTYEAR |
Syntax: CURRENTYEAR()
Description: Returns the current year.
Example:
CURRENTYEAR()
|
| Date |
DATEADD |
Syntax:DATEADD(datepart,numeric_expression, date_expression)
Description: Adds a time/date interval to the specified date.
Example:
There are different date part syntax for each type of data source connection. Refer to this section for examples
|
| Date |
DATESUB |
Syntax: DATESUB(numeric_expression, date_expression)
Description: Returns the date subtracted from the specified date.
Example:
DATESUB(7, [OrderDate])
|
| Date |
DAY |
Syntax: DAY(date_expression)
Description: Returns a numeric value representing the day part of the specified date.
Example:
DAY([OrderDate])
|
| Date |
DAYDIFF |
Syntax: DAYDIFF(start_date_expression, end_date_expression)
Description: Returns a numeric value representing the difference between two specified dates.
Example:
DAYDIFF(MAX([OrderDate]), ‘1988-08-08’)
|
| Date |
HOUR |
Syntax: HOUR(date_expression)
Description: Returns the hour of the given date as an integer.
Example:
HOUR([OrderDate])
|
| Date |
MINUTE |
Syntax: MINUTE(date_expression)
Description: Returns a numeric value representing the minute part of the date resulted from the specified date expression.
Example:
MINUTE([OrderDate])
|
| Date |
MONTH |
Syntax: MONTH(date_expression)
Description: Returns a numeric value representing the month part of the date resulted from specified date expression.
Example:
MONTH([OrderDate])
|
| Date |
NOW |
Syntax: NOW()
Description: Returns the current date and time.
Example:
NOW()
|
| Date |
PREVIOUSDATE |
Syntax: PREVIOUSDATE()
Description: Returns the previous date.
Example:
PREVIOUSDATE()
|
| Date |
PREVIOUSMONTH |
Syntax: PREVIOUSMONTH()
Description: Returns the previous month.
Example:
PREVIOUSMONTH()
|
| Date |
PREVIOUSYEAR |
Syntax: PREVIOUSYEAR()
Description: Returns the previous year.
Example:
PREVIOUSYEAR()
|
| Date |
TODAY |
Syntax: TODAY()
Description: Returns the current date.
Example:
TODAY()
|
| Date |
YESTERDAY |
Syntax: YESTERDAY()
Description: Returns the yesterday date.
Example:
YESTERDAY()
|
| Date |
YEAR |
Syntax: YEAR(date_expression)
Description: Returns a numeric value representing the year part of the date resulting from the specified date expression.
Example:
YEAR([OrderDate])
|
| Date |
DATENAME |
Syntax: DATENAME(date_part, date_expression)
Description: Returns a string representing the specified date part of the given date expression.
Example:
DATENAME(“day”, [OrderDate])
|
| Date |
DATEPART |
Syntax: DATEPART(date_part, date_expression)
Description: Returns an integer value representing the specified date part of the given date expression.
Example:
DATEPART(“year”, MAX([OrderDate]))
|
| Date |
MAX |
Syntax: MAX(expression)
Description: Returns the maximum value in the given expression.
Example:
MAX([OrderDate])
|
| Date |
MIN |
Syntax: MIN(expression)
Description: Returns the minimum value in the given expression.
Example:
MIN([OrderDate])
|
| String |
LEN |
Syntax: LEN(string_expression)
Description: Returns the number of characters in the given string expression.
Example:
LEN([ShipPostalCode])
|
| String |
CHAR |
Syntax: CHAR(integer_expression)
Description: Converts the given integer ASCII code into a character.
Example:
CHAR(70)
|
| String |
CONCAT |
Syntax: CONCAT(string_expression1, string_expression2,…, string_expressionN)
Description: Returns a string value resulting from the concatenation of two or more string values.
Example:
CONCAT(‘https://en.wikipedia.org/wiki/Main_Page’, [ShipCity])
|
| String |
CONTAINS |
Syntax: CONTAINS(string_expression, substring_expression)
Description: Returns true if the given string expression contains the specified substring expression.
Example:
CONTAINS([Shipping Address], [ShipCountry])
|
| String |
ENDSWITH |
Syntax: ENDSWITH(string_expression substring_expression)
Description: Returns true if the given string expression ends with the specified substring expression.
Example:
ENDSWITH([CustomerID], ‘A’)
|
| String |
LEFT |
Syntax: LEFT(string_expression, numeric_expression)
Description: Returns the specified number of characters from the start of the given string expression.
Example:
LEFT([ShipAddress], 6)
|
| String |
LOWER |
Syntax: LOWER(string_expression)
Description: Returns a lower case converted string value from a given string expression.
Example:
LOWER([ShipCountry])
|
| String |
LTRIM |
Syntax: LTRIM(string_expression)
Description: Returns the string value with any leading blanks from string expression.
Example:
LTRIM(‘Removes trailing spaces.’)
|
| String |
MAX |
Syntax: MAX(expression)
Description: Returns the maximum value in the given expression.
Example:
MAX([ProductName])
|
| String |
MIN |
Syntax: MIN(expression)
Description: Returns the minimum value in the given expression.
Example:
MIN([ProductName])
|
| String |
REPLACE |
Syntax: REPLACE(string_expression, substring, new_substring)
Description: Replaces all occurrences of the substring within the given string expression, with the new_substring.
Example:
REPLACE([ShipCountry],'France','India')
|
| String |
RIGHT |
Syntax: RIGHT(string_expression, numeric_expression)
Description: Returns the specified number of characters from the end of the given string expression.
Example:
RIGHT([ProductName], 6)
|
| String |
RTRIM |
Syntax: RTRIM(string_expression)
Description: Returns the string value with any trailing blanks removed from a string expression.
Example:
RTRIM(‘Remove trailing spaces.’)
|
| String |
STARTSWITH |
Syntax: STARTSWITH(string_expression, substring_expression)
Description: Returns true if the given string expression starts with the specified substring expression.
Example:
STARTSWITH([CustomerID], ‘A’)
|
| String |
SUBSTR |
Syntax: SUBSTR(string_expression, starting_index, length_of_the_string)
Description: Returns a specific length of a string starting from a specific index from the given string expression.
Example:
SUBSTR([CustomerID],1,3)
|
| String |
TRIM |
Syntax: TRIM(string_expression)
Description: Removes the leading and trailing spaces from the string expression.
Example:
TRIM(‘Remove trailing spaces.’)
|
| String |
UPPER |
Syntax: UPPER(string_expression)
Description: Returns an upper case converted string value from a given string expression.
Example:
UPPER([ShipCountry])
|
| ROW |
RUNNINGCOUNT |
Syntax: RUNNINGCOUNT(aggregate_expression)
Description: Returns the running count of each row.
Example:
RUNNINGCOUNT(MAX([OrderID]))
|
| ROW |
RUNNINGAVG |
Syntax: RUNNINGAVG(aggregate_expression)
Description: Returns the running average of each row.
Example:
RUNNINGAVG(MAX([UnitsInStock]))
|
| ROW |
RUNNINGMAX |
Syntax: RUNNINGMAX(aggregate_expression)
Description: Returns the running maximum values of each row.
Example:
RUNNINGMAX(SUM([UnitsInStock]))
|
| ROW |
RUNNINGMIN |
Syntax: RUNNINGMIN(aggregate_expression)
Description: Returns the running minimum values of each row.
Example:
RUNNINGMIN(SUM([UnitsInStock]))
|
| ROW |
RUNNINGSUM |
Syntax: RUNNINGSUM(aggregate_expression)
Description: Returns the running sum values of each row.
Example:
RUNNINGSUM(MAX([UnitsInStock]))
|
| Data Source Connection |
Date Part |
Syntax & Examples |
| SQL Server |
| day
|
|
DATEADD(day,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(d,1,[ModifiedDate])
|
| year |
|
DATEADD(year, 2, '2017/08/25')
DATEADD(yy,1,[ModifiedDate])
DATEADD(yyyy,1,[ModifiedDate])
DATEADD(y,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(d,1,[ModifiedDate])
|
| week |
|
DATEADD(week, 2, '2017/08/25')
DATEADD(ww,1,[ModifiedDate])
DATEADD(w,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter, 1, '2017/08/25')
DATEADD(qq,1,[ModifiedDate])
DATEADD(q,1,[ModifiedDate])
|
| MySQL |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| ORACLE |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| SSAS |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| Snowflake |
| day
|
|
DATEADD(d,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(days,1,[ModifiedDate])
DATEADD(dayofmonth,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
DATEADD('year',1,[ModifiedDate])
DATEADD('yy',1,[ModifiedDate])
DATEADD('yyyy',1,[ModifiedDate])
DATEADD("yy",1,[ModifiedDate])
|
| month |
|
DATEADD(months,1,[ModifiedDate])
DATEADD(mon,1,[ModifiedDate])
DATEADD(mm,1,[ModifiedDate])
DATEADD(mon,1,[ModifiedDate])
|
| week |
|
DATEADD(w,1,[ModifiedDate])
DATEADD(wk,1,[ModifiedDate])
DATEADD(weekofyear,1,[ModifiedDate])
DATEADD(wof,1,[ModifiedDate])
DATEADD(wy,1,[ModifiedDate])
|
| quarter |
|
DATEADD(q,1,[ModifiedDate])
DATEADD(qtr,1,[ModifiedDate])
DATEADD(qtrs,1,[ModifiedDate])
DATEADD(quarters,1,[ModifiedDate])
|
| Presto |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| PostgreSQL |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| GoogleBigQuery |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| Elastic Search |
| day
|
|
DATEADD(days,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(d,1,[ModifiedDate])
|
| year |
|
DATEADD(years,1,[ModifiedDate])
DATEADD(yy,1,[ModifiedDate])
DATEADD(yyyy,1,[ModifiedDate])
|
| month |
|
DATEADD(months,1,[ModifiedDate])
DATEADD(mm,1,[ModifiedDate])
DATEADD(m,1,[ModifiedDate])
|
| week |
|
DATEADD(weeks,1,[ModifiedDate])
DATEADD(wk,1,[ModifiedDate])
DATEADD(ww,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarters,1,[ModifiedDate])
DATEADD(qq,1,[ModifiedDate])
DATEADD(q,1,[ModifiedDate])
|
| Data Source Connection |
Date Part |
Syntax & Examples |
| SQL Server |
| day
|
|
DATEADD(day,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(d,1,[ModifiedDate])
|
| year |
|
DATEADD(year, 2, '2017/08/25')
DATEADD(yy,1,[ModifiedDate])
DATEADD(yyyy,1,[ModifiedDate])
DATEADD(y,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(d,1,[ModifiedDate])
|
| week |
|
DATEADD(week, 2, '2017/08/25')
DATEADD(ww,1,[ModifiedDate])
DATEADD(w,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter, 1, '2017/08/25')
DATEADD(qq,1,[ModifiedDate])
DATEADD(q,1,[ModifiedDate])
|
| MySQL |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| ORACLE |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| SSAS |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| Snowflake |
| day
|
|
DATEADD(d,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(days,1,[ModifiedDate])
DATEADD(dayofmonth,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
DATEADD('year',1,[ModifiedDate])
DATEADD('yy',1,[ModifiedDate])
DATEADD('yyyy',1,[ModifiedDate])
DATEADD("yy",1,[ModifiedDate])
|
| month |
|
DATEADD(months,1,[ModifiedDate])
DATEADD(mon,1,[ModifiedDate])
DATEADD(mm,1,[ModifiedDate])
DATEADD(mon,1,[ModifiedDate])
|
| week |
|
DATEADD(w,1,[ModifiedDate])
DATEADD(wk,1,[ModifiedDate])
DATEADD(weekofyear,1,[ModifiedDate])
DATEADD(wof,1,[ModifiedDate])
DATEADD(wy,1,[ModifiedDate])
|
| quarter |
|
DATEADD(q,1,[ModifiedDate])
DATEADD(qtr,1,[ModifiedDate])
DATEADD(qtrs,1,[ModifiedDate])
DATEADD(quarters,1,[ModifiedDate])
|
| Presto |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| PostgreSQL |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| GoogleBigQuery |
| day
|
|
DATEADD(day,1,[ModifiedDate])
|
| year |
|
DATEADD(year,1,[ModifiedDate])
|
| month |
|
DATEADD(month,1,[ModifiedDate])
|
| week |
|
DATEADD(week,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarter,1,[ModifiedDate])
|
| Elastic Search |
| day
|
|
DATEADD(days,1,[ModifiedDate])
DATEADD(dd,1,[ModifiedDate])
DATEADD(d,1,[ModifiedDate])
|
| year |
|
DATEADD(years,1,[ModifiedDate])
DATEADD(yy,1,[ModifiedDate])
DATEADD(yyyy,1,[ModifiedDate])
|
| month |
|
DATEADD(months,1,[ModifiedDate])
DATEADD(mm,1,[ModifiedDate])
DATEADD(m,1,[ModifiedDate])
|
| week |
|
DATEADD(weeks,1,[ModifiedDate])
DATEADD(wk,1,[ModifiedDate])
DATEADD(ww,1,[ModifiedDate])
|
| quarter |
|
DATEADD(quarters,1,[ModifiedDate])
DATEADD(qq,1,[ModifiedDate])
DATEADD(q,1,[ModifiedDate])
|
Select an expression column in left pane.
Select an expression column in left pane that you need to update.
Edit the Name and Expression text areas, if required.
You can also drag and drop expression column into widgets from measure or dimension fields or both.
You can also apply filters for expression column which is used in widget. For numeric expressions, you can apply filter just like a measure filter. For string and date expressions, you can apply filter just like a dimension filter.
