The year() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the metric. Syntax Metric_API_Name.Dataset_API_Name.year(offset value) Argument Description offset value (required) An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or a…
The value() function returns the numeric value contained in a text attribute. Syntax value(attribute API name) Argument Description attribute API name (required) The attribute API name of the attribute holding the text value. If the attribute does not contain text that can be converted to a numeric value, a blank value will…
The today() function returns the current (UTC) date. Syntax today() Argument Description None This function does not accept any arguments. Where Available Available in all places the expression or injected expression icon is visible, as well as within Filter fields on Cards, Tables and List/View sections. Examples Where Example(s) Set Value (to…
The sumif() function returns the summed total for a value on all instances of a specified template. The instances must be descendants (e.g., children, grandchildren, etc.) or an association of the current work item to be included in the aggregation. Syntax sumif(template API name, value, condition) Argument Description template API…
The sum() function adds values and returns them into a time-series array. Syntax sum(value1, value2, [value3]…) Argument Description value1 (required) The first number you want to add. The value arguments can be constants (i.e., hard-coded values or attribute references) and/or references to metrics. value2 (required) The second number you want to add….
The quarterly() function returns a time-series array of values in a quarterly cadence. It can only be applied to As Of, Per Day, Per Month, and Per Quarter metrics. Note: while allowed, the assignment of this function to a per quarter metric would have no effect since the per quarter metric would…
The quarter() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the metric. Syntax Metric_API_Name.Dataset_API_Name.quarter(offset value) Argument Description offset value (required) An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or a function…
The onDate() function returns a value into the time period corresponding to its date argument. It can be included inside other expressions to isolate the value to be retrieved for the expression. On its own in a metric expression, it will assign the retrieved value to the single time period corresponding to…
The monthly() function returns a time-series array of values in a monthly cadence. It can only be applied to As Of, Per Day, and Per Month metrics. Note: while allowed, the assignment of this function to a per month metric would have no effect since the per month metric would inherently be…
The month() offset function is appended to a metric dataset and provides the ability to dynamically reference a time period for the metric. Syntax Metric_API_Name.Dataset_API_Name.month(offset value) Argument Description offset value (required) An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or a function…