The minif() function returns the minimum value from a comparison of the value across 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 minif(template API name, value, condition) Argument…
The min() function returns the smallest number or earliest date from a set of values. This function can be used in a metric expression to return a time-series array or can be used in any other expression to return a single value. Syntax min(value1, value2, [value3]…) Argument Description value1 (required) The first…
The maxif() function returns the maximum value from a comparison of the value across 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 maxif(template API name, value, condition) Argument…
The max() function returns the largest number or latest date from a set of values. This function can be used in a metric expression to return a time-series array or can be used in any other expression to return a single value. Syntax max(value1, value2, [value3]…) Argument Description value1 (required) The first…
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 number assigned to the desired instance. Where Available Available in all places the expression or injected expression icon is visible, as well as within Filter fields on Cards, Tables and…
The if() function allows for a conditional evaluation that returns a boolean (i.e., true or false). Depending on the result, one of two expressions is run. Syntax if(condition, if true, if false) Argument Description condition (required) The condition to be evaluated and that returns a boolean. value if true (required) The value…
The days() function returns the number of days between two dates. Syntax days(date1, date2) Argument Description date1 (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date value). date2 (required) An expression that results in a…
The day() 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.day(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 daily() function returns a time-series array of values in a daily cadence. It can only be applied to As Of and Per Day metrics. Note: while allowed, the assignment of this function to a per day metric would have no effect since the per day metric would inherently be translating the…
The cumulative() function returns the accumulated values of a metric since a designated date into a time-series array. Syntax cumulative(value, date) Argument Description value (required) The expression returning the values to be accumulated. The expression can simply be the metric API name of the metric to be aggregated or could be a…