Time series tables

Add time series to table

Time series are added to a new table view by selecting one or more time series in the time series explorer and selecting Add to new table.

Time series can be added to the active table by selecting Add to active table from the time series context menu.

The first column contains the time stamps of the added time series.

The next columns contain the values of the added time series, one column for each time series.

If a time series does not have a time stamp defined for a given time stamp in the table, this will be indicated by a blue cell color.

If a time series has a time stamp defined, but no value, this is indicated by a blank cell (white background).

Editing time series

To edit a time series value or a time stamp, double click on the cell in the time series table.

The cell becomes editable, and the value can be changed.

After a value has been edited, the Save button in the toolstrip becomes enabled.

To save the changes, click the Save (or Save as...) button.

To discard the changes, close the time series table without saving.

To undo a change, click the Undo button.

To redo a change that was previously undone, click the Redo button.

Notice that only changes done after the latest Save can be undone.

To copy one value, or a range of values from e.g. a spreadsheet to the table:

1. Copy the values from the spreadsheet to the clipboard.
2. Select the cell in the table where the first value in the clipboard shall be added.
3. Click the Paste button.

To copy one value, or range of values from a time series table to the windows clipboard, select the cells to be copied in the table, and click the Copy button.

Auto-commit changes

If desired, changes can be committed immediately after a change has been made, without requiring the user to actively save first.

This is done by opening the DHI.Solution.Shell.exe.Config file in a text editor.

Browse to the ApplicationsSettings section and change the UserInitiatedSave setting to false.

After restarting the application, changes in time series will automatically be committed to the database, without requiring the user to actively save changes.