Time Dimensions


Read more about Data Workbench’s End-of-life announcement.

A time dimension enables you to create a set of periodic or absolute local time dimensions (such as Day, Day of Week, Hour of Day, Reservation Time, and so on) based on any timestamp field that you specify for the Input Time (1970 epoch) parameter.

When defining time dimensions, you also can choose a day other than Monday to be used as the start of a week by specifying the Week Start Day parameter. You can define more than one set of time dimensions in your dataset as long as the dimensions have different names.

Time dimensions are defined by the following parameters:

Parameter Description Default
Name Descriptive name of the dimension as it appears in data workbench. The dimension name cannot include a hyphen (-).
Comments Optional. Notes about the extended dimension.

You can specify dimension names for any of the following periods:

  • Day
  • Day of Week
  • Hour
  • Hour of Day
  • Month
  • Week

The names that you enter here are the names that appear in dimension menus and in visualizations in data workbench. If you leave the name of a time dimension blank, the dimension is not created in the dataset.

Hidden Determines whether the dimension appears in the data workbench interface. By default, this parameter is set to false. If, for example, the dimension is to be used only as the basis of a metric, you can set this parameter to true to hide the dimension from the data workbench display. true
Input Time (1970 epoch)

The name of the timestamp field to use as input.

Note: The field's values must represent the number of seconds since January 1st, 1970, at 00:00:01. If the input time is not a valid time (1970 to 2037), the transformation process will fail, and the data workbench server will generate an error.

Parent The name of the parent dimension. Any countable dimension can be a parent dimension. For web data, the parent is Session.
Week Start Day

The day to use as the first day of a week.

This parameter affects the Week dimension, the Day of Week dimension, and any reporting time dimensions defined in terms of weeks.


This example creates a set of time dimensions based on the user-defined input field x-time-1970. The set of time dimensions is named “Session Time.” Because the parent of each dimension is the Session dimension, each element of the time dimensions corresponds to the time at which a session began. The Week Start Day parameter specifies that each week of the Week dimension starts on Monday.

On this page