Create a Time Enrichment Attributes and Time Transformation Metrics

Starting in Strategy One (December 2025), you can use time attributes to create time transformation metrics that allow you to calculate change over time.

You can use Mosaic Studio to create time dimensions using time attributes. Time attributes include fixed time intervals that allow you to easily create complete time hierarchies without creating separate attributes for each dimension. Mosaic Studio allows you to automatically construct robust and flexible time dimensions within your Mosaic model, significantly enhancing temporal analysis capabilities.

Time attributes created in Mosaic Studio are added to a new section called Time Enrichment Attributes in the Objects panel, grouped by their Base Attribute. Time dimension attributes are added to a new section called Metrics in the Objects panel.

This functionality requires that the Data Engine version be 2021 or above.

Create Time Attributes from the Suggestion Panel

In the Suggestions panel, a Create Time Attributes option displays that includes all attributes with TimeStamp and Date datatypes.
Click the suggestion to display the available time attributes.

The 15-minute interval is required if any time attributes are created for the attribute.
Select the checkboxes next to the time intervals you want to include and click Accept.

Create a Time Transformation Metric Using a Time Attribute

Time transformation metrics allow you to view trends over time based on your chosen time attribute and calculating metric. For example, you are a retail business that wants to review the cost of units from last year. Use a time transformation to easily view the unit cost of last year compared to this year. You can then further utilize your time transformation metric by creating a derived metric that calculates the year over year cost.

Use the following methods to create a time transformation metric:

Function Editor: Use this option if you need guided fields to create your formula.
Create Metric Editor: Use this option if you are familiar with writing metric formula and want to manually enter your formula.
Auto Metric: Use this option if you want to utilize AI to create your formula.

Create a Time Transformation Metric Using the Function Editor

Import data with a time attribute or time enrichment attribute.
In the Objects panel, click Create Metric.
If needed, expand the Functions panel.
Expand the drop-down list and choose Internal.
Find PreviousYear, PreviousQuarter, PreviousMonth, or PreviousDay and click Add...
Expand the Time Attribute drop-down list and choose a datetime attribute or time enrichment attribute to base the metric off of.
Type a value in Number of Periods to determine how much time back to review.
Expand the Metric drop-down list and choose a base metric or aggregation metric you want to transform.
Click Insert.
Ensure the metric is valid.
Click New Metric and type a new name.
Click OK.
Click Save.

Create a Time Transformation Metric Using the Metric Editor

Import data with a time attribute or time enrichment attribute.
In the Objects panel, click Create Metric.
In Formula, type your time transformation metric using the following format: PreviousQuarter([Order Data (Day interval)], 1, Sales).

You can also use the following time formulas, depending on your needs:
- PreviousYear([Order Data (Day interval)], 1, Sales)
- PreviousMonth([Order Data (Day interval)], 1, Sales)
- PreviousDay([Order Data (Day interval)], 1, Sales)
Ensure the metric is valid.
Click New Metric and type a new name.
Click OK.
Click Save.

Create a Time Transformation Metric Using Auto Metric

Import data with a time attribute or time enrichment attribute.
In the Objects panel, click Create Metric.
At the bottom of the metric panel, type a message with the details for your time transformation metric.

For example, Create a time transformation metric for the previous month units sold.
Auto Metric responds with a metric formula.
To add the metric to your Mosaic model, click Create.
Click Save.