max() The max() function returns the largest number or latest date from a set of values. This function can be used in a...
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...
monthly() The monthly() function returns a time-series array of values in a monthly cadence. It can only be applied to As Of, Per...
onDate() The onDate() function returns a value into the time period corresponding to its date argument. It can be included inside other expressions...
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...
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...