maxif()
The maxif() function returns the maximum value from a comparison of the value across all instances of a specified template....
Functions
-
-
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... -
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... -
quarter()
The quarter() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the... -
quarterly()
The quarterly() function returns a time-series array of values in a quarterly cadence. It can only be applied to As Of, Per...