average()
The average() function returns the average value from a set of values and returns a time-series array. Syntax average(value1, value2, [value3]…) Argument...
- Home
- Knowledge Base
- Expression
-
-
averageif()
The averageif() function returns the average value across all instances of a specified template. The instances must be descendants (e.g.,... -
betweenDates()
The betweenDates() function returns the specified values between two dates into a time-series array. Syntax betweenDates(value, startDate, endDate) Argument Description value (required)... -
countif()
The countif() function returns the number of instances of a specified template. The instances must be descendants (e.g., children, grandchildren,... -
cumulative()
The cumulative() function returns the accumulated values of a metric since a designated date into a time-series array. Syntax cumulative(value, date) Argument... -
daily()
The daily() function returns a time-series array of values in a daily cadence. It can only be applied to As Of and... -
day()
The day() function is appended to a metric dataset and provides the ability to offset the values for a time... -
days()
The days() function returns the number of days between two dates. Syntax days(date1, date2) Argument Description date1 (required) An expression that results... -
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...