Apply Time Shift Window

This window lets you shift one dataset in time. You can shift either the entire dataset or just a portion of it. To access this window, choose Apply Time Shift from the Revise menu.

Shift the Entire Dataset in Time

If you choose to Shift the entire data in time, Windographer shows you the date and time of the first data item in the dataset. Enter the new start time and click OK to shift your data. Shifting the dataset in this way will not affect the data itself; it will only affect the time stamps.

You could use this time shift capability, for example, to correct a problem related to daylight savings time or the leap year. Or you could use it to shift the time stamps to a standard pattern, as in the example shown below. In this example, the original dataset's time stamps are offset by three minutes from the top of the hour, so the time stamps have the pattern :03, :13, :23, and so on. The user wants to shift these time stamps so that they fall on the hour, ten minutes after the hour, twenty minutes after the hour, and so on. She may need to do this to append this dataset to another dataset that has conventional time stamps, for example.

When the user clicks OK, all time stamps in her dataset will shift by three minutes, like so:

Start TimeSpdDir
2017-03-31 21:039.34180
2017-03-31 21:139.96203
2017-03-31 21:2310.86203
2017-03-31 21:3310.95203
2017-03-31 21:4310.72225
2017-03-31 21:5311.35225
2017-03-31 22:0312.29203
2017-03-31 22:1312.20180
2017-03-31 22:2310.59225
2017-03-31 22:3310.90270
2017-03-31 22:4311.39248
2017-03-31 22:5312.07315
2017-03-31 23:0310.63203
shift
Start TimeSpdDir
2017-03-31 21:009.34180
2017-03-31 21:109.96203
2017-03-31 21:2010.86203
2017-03-31 21:3010.95203
2017-03-31 21:4010.72225
2017-03-31 21:5011.35225
2017-03-31 22:0012.29203
2017-03-31 22:1012.20180
2017-03-31 22:2010.59225
2017-03-31 22:3010.90270
2017-03-31 22:4011.39248
2017-03-31 22:5012.07315
2017-03-31 23:0010.63203

These changes become permanent when she saves the .windog file.

Shift a Particular Data Segment in Time

If you choose to shift a portion of the dataset in time, Windographer will show you a list of all the data columns in your dataset. Select the data columns you wish to shift. In the example below, data from the 'Dir' column will be shifted in time, but data in the 'Spd' and 'Temp' columns will not.

Next, specify the time interval of the data to be shifted. It could be the entire column of data, or only a portion. In the example below, just one hour of data from May 2007 will be shifted in time.

Specify how many time steps to shift the data. In the example below, a shift of 2 time steps will move the data 20 minutes because the data has 10 minute time steps. Next, specify if the data should be shifted forward or backward in time.

When the user clicks OK, that one-hour segment of the 'Dir' column will be shifted two times steps, like so:

Start TimeSpdDir
2017-05-30 23:109.34180
2017-05-30 23:209.96203
2017-05-30 23:3010.86203
2017-05-30 23:4010.95203
2017-05-30 23:5010.72225
2017-05-31 00:0011.35225
2017-05-31 00:1012.29203
2017-05-31 00:2012.20180
2017-05-31 00:3010.59225
2017-05-31 00:4010.90270
2017-05-31 00:5011.39248
2017-05-31 01:0012.07315
2017-05-31 01:1010.63203
2017-05-31 01:2010.90180
shift
Start TimeSpdDir
2017-05-30 23:109.34180
2017-05-30 23:209.96203
2017-05-30 23:3010.86203
2017-05-30 23:4010.95
2017-05-30 23:5010.72
2017-05-31 00:0011.35203
2017-05-31 00:1012.29225
2017-05-31 00:2012.20225
2017-05-31 00:3010.59203
2017-05-31 00:4010.90180
2017-05-31 00:5011.39225
2017-05-31 01:0012.07315
2017-05-31 01:1010.63203
2017-05-31 01:2010.90180

This could result in data being overwritten as in the example above. Be careful with this kind of time shift!

Tip: You can offset multiple datasets in time with the Optimal Time Offset window.

See also

Optimal Time Offset window

Delete Data window

Apply Scale and Offset window


Written by: Linda Sloka
Contact: windographer.support@ul.com
Last modified: August 6, 2021