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... -
onDate()
The onDate() function returns a value into the time period corresponding to its date argument. It can be included inside other expressions... -
power()
The power() function provides the ability to use exponents in expressions. Syntax power(base, exponent) Argument Description base (required) The base...