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) |
The time period of the metric.
The time period arguments can be constants (i.e., hard-coded values or attribute references) or an expression. |
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) |
Field Editability expression
Tab Visibility expression Business rules: Condition |
Employee_Average_Salary__m.actual__d.timePeriod(Day_Zero__c) > 100 |
Embedded Section URL attribute
Business rules: Call URL External View URL on List/View |
{!if(Employee_Average_Salary__m.actual__d.timePeriod(Day_Zero__c) > 100,URL1__c, URL2__c)} |
Business rules: Set Value
Attribute expression |
Total_Savings__m.target__d.timePeriod(Program_End_Date__c) |
Business rules: Notification Subject
Dynamic Filter |
{!CAPEX__m.target__d.timePeriod("2023-12-31")}
|
Business rules: Notification Body | Day Zero Average Salary: {!Employee_Average_Salary__m.actual__d.timePeriod(Day_Zero__c)} |
Metric expression
|
CAPEX__m.actual__d.timePeriod(Program_Start_Date__c)
|