year()
The year() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the...
Functions
-
-
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... -
quarterEnd()
The quarterEnd() function returns the date of the end of the Fiscal Calendar quarter based on a date input. Syntax... -
yearStart()
The yearStart() function returns the date of the start of the Fiscal Calendar year based on a date input. Syntax... -
yearEnd()
The yearEnd() function returns the date of the end of the Fiscal Calendar year based on a date input. Syntax...