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)...
today() The today() function returns the current (UTC) date. Syntax today() Argument Description None This function does not accept any arguments. Where Available...
toFilter() The toFilter() function formats values into filter-friendly values. Text values will be surrounded by double quotes to allow for exact...
value() The value() function returns the numeric value contained in a text attribute. Syntax value(attribute API name) Argument Description attribute API name (required)...
workDays() The workDays() function returns the number of weekdays (i.e., Monday through Friday) between two dates. Syntax workDays(date1, date2, [holidays]) Argument...
year() The year() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the...
yearly() The yearly() function returns a time-series array of values in a yearly cadence. When you reference a metric, it is immediately converted...