max()
The max() function returns the largest number or latest date from a set of values. This function can be used in a...
Functions
-
-
maxif()
The maxif() function returns the maximum value from a comparison of the value across all instances of a specified template.... -
min()
The min() function returns the smallest number or earliest date from a set of values. This function can be used in a... -
minif()
The minif() function returns the minimum value from a comparison of the value across all instances of a specified template.... -
month()
The month() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the... -
months()
The months() function returns the number of months/periods between two dates. Syntax months(date1, date2) Argument Description date1 (required) An expression... -
monthly()
The monthly() function returns a time-series array of values in a monthly cadence. It can only be applied to As Of, Per... -
npv()
The npv() function provides the ability to calculate the Net Present Value of an investment. Syntax npv(rate, value1, [value2]…) Argument... -
offsetDay()
The offsetDay() function provides the ability to offset any time series by a set number of days. Syntax offsetDay(integer, value)... -
offsetMonth()
The offsetMonth() function provides the ability to offset any time series by a set number of months/periods. Syntax offsetMonth(integer, value)...