today()
The today() function returns the current (UTC) date. Syntax today() Argument Description None This function does not accept any arguments. Where Available...
Functions
-
-
toFilter()
The toFilter() function formats values into filter-friendly values. Text values will be surrounded by double quotes to allow for exact... -
value()
The value() function returns the numeric value contained in a text attribute. Syntax value(attribute API name) Argument Description attribute API name (required)... -
workDays()
The workDays() function returns the number of weekdays (i.e., Monday through Friday) between two dates. Syntax workDays(date1, date2, [holidays]) Argument... -
year()
The year() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the... -
yearly()
The yearly() function returns a time-series array of values in a yearly cadence. When you reference a metric, it is immediately converted... -
weeks()
The weeks() function returns the number of weeks between two dates. Syntax weeks(date1, date2) Argument Description date1 (required) An expression... -
monthEnd()
The monthEnd() function returns the date of the end of the Fiscal Calendar month based on a date input. Syntax... -
monthStart()
The monthStart() function returns the date of the start of the Fiscal Calendar month based on a date input. Syntax... -
quarterStart()
The quarterStart() function returns the date of the start of the Fiscal Calendar quarter based on a date input. Syntax...