sumif() The sumif() function returns the summed total for a value on all instances of a specified template. The instances must...
today() The today() function returns the current (UTC) date. Syntax today() Argument Description None This function does not accept any arguments. Where Available...
value() The value() function returns the numeric value contained in a text attribute. Syntax value(attribute API name) Argument Description attribute API name (required)...
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...
cumulativeYTD() The cumulativeYTD() function returns the accumulated values of a metric for the current fiscal year into a time-series array. Syntax cumulativeYTD(value) Argument...
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)...
this. Prefix The this. prefix can be used in aggregation functions and in the dropdown filter for associations. In Shibumi aggregation functions,...
Calculated Attributes Overview An attribute calculation can be defined on the template on the Add/Edit Attribute dialog accessed via the Data Panel...
addMonths() The addMonths() function provides the ability to add or subtract months from a date. Syntax addMonths(date, integer) Argument Description date...