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)

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)

OPEX__m.target__d.timePeriod("2023-12-31")

OPEX__m.target__d.timePeriod("12/15/2023")

OPEX__m.target__d.timePeriod(addDays(Program_Start_Date__c, -90))

 

Updated on September 26, 2024

Related Articles