All datetime data coming into Domo is presumed to be UTC. You can set the time zone for a DataSet Job in Workbench, which will convert the time back to UTC before transmitting to Domo.
American Daylight Savings is taken into account for time zones in Workbench, but you may see the gaining or losing of an hour in your data depending on the time of year.
You apply a time zone to a DataSet using the Shift Date Timezone Transform. Note the UTC offset in the example below. In this case, 7 hours would be added to your datetime value in order to bring it inline with UTC.
To set the time zone for a DataSet job,
-
In Workbench, click
in the left-hand icon bar.
-
In the Jobs listing, double-click the DataSet job with columns you want to filter.
-
Click Transforms to expand that section of the pane.
-
In the Add a transform menu, select Filter Transform.
-
Click the
button.
The Filter Transform Editor appears. -
In the Data Timezone menu, select the desired time zone.
-
Click Apply.
-
Click
at the top of the pane to save your transform.
Comments
0 comments
Please sign in to leave a comment.