daily() The daily() function returns a time-series array of values in a daily cadence. It can only be applied to As Of and...
date() The date() function provides the ability to build a date and returns a date value formatted mm/dd/yyyy (e.g., 03/31/2021). Syntax date(year, month,...
day() The day() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the...
days() The days() function returns the number of days between two dates. Syntax days(date1, date2) Argument Description date1 (required) An expression that results...
encodeUrl() The encodeUrl() function can be used to include a referenced value that may have spaces or special characters within a...
formatDate() The formatDate() function is used to format dates. Syntax formatDate(date, mask) Argument Description date (required) An expression that results in a date...
if() The if() function allows for a conditional evaluation that returns a boolean (i.e., true or false). Depending on the result, one of...
instance() The instance() function references a specified instance of a template. Syntax template__t.instance(autoID) template__t.instance(autoID).metric__m template__t.instance(autoID).attribute__c Argument Description autoID (required) The system generated ID...
isEmpty() The isEmpty() function checks whether an attribute, metric, or association holds a value. Syntax isEmpty(value) Argument Description value(required) An attribute, metric, or...
max() The max() function returns the largest number or latest date from a set of values. This function can be used in a...