offsetQuarter()
The offsetQuarter() function provides the ability to offset any time series by a set number of quarters. Syntax offsetQuarter(integer, value)...
Functions
-
-
offsetYear()
The offsetYear() function provides the ability to offset any time series by a set number of years. Syntax offsetYear(integer, value)... -
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... -
round()
The round() function rounds a number to a specified number of digits. Syntax round(value, precision) Argument Description value (required) An... -
sum()
The sum() function adds values and returns them into a time-series array. Syntax sum(value1, value2, [value3]…) Argument Description value1 (required) The first... -
sumif()
The sumif() function returns the summed total for a value on all instances of a specified template. The instances must... -
timePeriod()
The timeperiod() function references the value in a specific time period of a metric. Syntax metric__m.dataset__d.timePeriod(time period) Argument Description time period (required)...