Explorer

Charts

Add time series to a new chart

Description	Illustration
To add one or more time series to a new chart data view, select the time series in the time series explorer and click “Add to new chart → All”. This will add the entire time series to a new chart. Alternatively, if the active data view is not a chart data view, a time series can be added to a new data view simply by double-clicking on a time series in the time series explorer.
Notice that when the first time series is added to a chart, the unit of the primary y-axis will take the unit of that time series. Additional series with the same unit will be associated to the same axis. If a time series with a different unit is added to the same chart view, a secondary y-axis will be created. If a third time series is added, a new chart within the chart view will be created etc.

Add time series to existing chart

Description	Illustration
To add one or more time series to an existing chart view, make the chart view the active view. Next, select the time series that shall be added to the chart, right-click and select “Add to active chart → All” from the context menu.
Alternatively, select the time series and drag-and-drop them on the chart data view.

Add Ensemble time series to chart

Description	Illustration
Ensemble time series are added to a chart the same way as ordinary time series, but when adding an ensemble to a chart, only the ensemble mean will be shown in the chart. By default the ensemble mean will be shown in a dashed style (line or column)

Apply a chart template

Description	Illustration
To apply a saved template to an existing chart, click the View settings button (), and select “Apply template → Template name” from the menu. The selected template will be applied on the chart.

Copy chart series between chart areas

Description	Illustration
To copy a chart series from one chart area to a new chart area in the same chart view, right-click on a series and select “Copy to new chart area” from the context menu.
A new chart area will be created, and a copy of the selected chart series is added.

Copy a chart to the clipboard

Description	Illustration
To copy a chart view to the windows clipboard, click the “Copy” button in the chart view toolstrip. After copying to the clipboard, the chart can be pasted in e.g. Microsoft office as graphics.

Create a chart template

Description	Illustration
To create a chart template, start by creating a new chart view and customize it. When the chart appears as desired, click the View settings button (), and select “Save as template” from the context menu.
Type in a template name in the pop-up dialog, select which chart elements that shall be included in the template, and click OK to save.
To overwrite an existing template, select an existing template in the drop-down list and click Save.

Customize a chart area

Description	Illustration
To edit the appearance of a chart area, click on a chart area. This will make the properties of the chart area appear in the property control.
The properties are shown in two tabs in the property control: Background Borderline Edit the properties to obtain the desired chart area appearance. Select the individual properties to get a short description in the property control.

Customize a chart series

Description	Illustration
To edit the appearance of a chart series, click on a chart series in a legend area. This will make the properties of the chart series appear in the property control.
The properties related to appearance are shown in two tabs in the property control: Appearance Marker lines Q/A Edit the properties to obtain the desired chart series appearance. The properties of the core time series are displayed under the last two tabs: Statistics Time series

Customize a chart axis

Description	Illustration
To edit the appearance of a chart axis, click on an axis. This will make the properties of the chart axis appear in the property control. Edit the properties to obtain the desired chart axis appearance. Select the individual properties to get a short description in the property control.

Customize the chart view background

Description	Illustration
To edit the appearance of the chart view background, click on a blank spot on the chart view. This will make the properties of the chart view appear in the property control.
The properties are shown in three tabs in the property control: Chart background Legend area Titles Edit the properties to obtain the desired background appearance. Select the individual properties to get a short description in the property control.

Default chart template

Description	Illustration
Optionally, a default chart template can be specified. The default template is the template that will be applied each time a new chart view is created. To set the default template, click the View settings button (), and select “Template manager” from the menu.
The template manager dialog opens. To select a default template, click the star in the first column. To deselect a template, click the star again. Close the dialog.

Export a chart series to a file

Description	Illustration
Export a chart series to a file by right-clicking on a series in the legend, a select “Export time series” from the context menu.
Select an output file format from the pop-up menu and click OK. Select a name and location to save to in the file save dialog that appears.

Export chart to file

Description	Illustration
Export a chart to a graphics file by clicking the “Export to graphics” tool in the chart toolstrip. A file-save dialog appears. Select the export file format, file name and folder, and click OK to save.

Move chart series between chart areas

Description	Illustration
Move a chart series to an existing chart area by right clicking on the chart series and select “Move to existing chart area → \<name of chart area>” from the context menu.
The selected chart series is moved to the selected chart area.
Move a chart series to a new chart area by selecting “Move to new chart area” in the chart series context menu.

Remove a chart series from a chart

Description	Illustration
Remove a chart series from a chart view by selecting “Remove” from the chart series context menu. Notice that the underlying time series from which the chart series was created will not be deleted from the database, and can still be accessed from the time series explorer.

Save a chart series to the database

Description	Illustration
If a chart series was created by e.g. running a tool and adding the result to a chart, the chart series can be saved to the database by selecting “Save as” from the chart series context menu.
Specify the name and group to save the series to, and click ok. The saved time series can now be accessed in the time series explorer.

Show ensemble statistics in a chart

Description	Illustration
After adding an ensemble time series to a chart it will by default be shown as the ensemble mean (i.e. the individual members will not be shown). To add statistics such as max/min range, or mean +/- one standard deviation, start by selecting the chart time series in the chart legend.
Next, select the statistics in the ensemble statistics drop-down list which can be found in the chart toolstrip. Finally, click the button next to the drop-down list, and the selected statistics will be calculated and added as a new series to the chart. The new series will have the name of the original series appended with the name of the selected statistics.

Toggle flag visibility

Description	Illustration
The time series values that have been flagged can be marked in the chart by clicking the flag visibility dropdown button in the chart toolstrip. The marker symbol will have the color of the flag. Below the chart areas a flag legend will become visible. To hide the flags, click the flag visibility dropdown button again, and select the same flag description used to show the flags initially.

Print a Chart

To print a chart:

1. Make the chosen chart active in the Data View

2. Select the ‘Print’ button
   in the chart toolbar. A print dialogue will open.

3. Select printer preferences

4. Select ‘Print’

Charts can be previewed by selecting the ‘Print Preview’ button.

Print Preview a Chart

To print preview a chart:

1. Make the chosen chart active in the Data View

2. Select the ‘Print Preview’ button
   in the chart toolbar. A print preview dialogue will open.

3. The print preview allows various views and zooming to inspect the pages to be printed. Closing the print preview will abort the printing process.

4. Select the ‘Print’ button to print to the computer’s default printer.

Setup Printing for a Chart

To setup printing for a chart:

1. Make the chosen chart active in the Data View

2. Select the ‘Page Setup’ button
   in the chart toolbar. A page setup dialogue will open.

3. The page setup dialogue allows defining paper sizes, orientation, and margins as well as printer setup Cancelling out of the page setup will abort the printing process.

4. Select ‘OK’ to save the page setup.

Zooming in a chart

Description	Illustration
To zoom in a chart click, hold and drag a box around the zoom area. When releasing, the chart will zoom in on the selected period.
To disable box-zoom, such that only zoom along the x-axis will be allowed, click the View settings button (), and select “Box zoom mode” from the menu.
Use the scroll-bars to move the zoom window.
To zoom to previous extent on a single axis, click the button in the lower left corner.
To zoom to full extent in all chart areas, click the “Zoom to extent” button in the chart tool strip.
To zoom to previous extent in all chart areas, click the “Zoom to previous” button in the chart tool strip.
By default, the time axes of the chart areas in a chart view are synchronized, such that they cover the same period. To disable synchronized zoom, click the View settings button (), and select “Synchronized zoom” from the menu to disable.

Chart favorites

Add chart to favorites

Description	Illustration
Add a chart to Favorite by clicking on the “Add to favorite” button in the chart view toolstrip. All layout settings as well as a link to the time series are stored with a favorite. This implies that if the time series changes after creating the favorite, the changes will be reflection when the favorite is opened.
The chart will now appear in the Favorite manager.

Create time series

This section describes how to create new, empty time series.

Create a new time series Manually

This section relates to Ordinary time series only. Ensembles will have to be created either by using one of the available import tools, generating it with an ensemble generation tool, or produced as output of an ensemble simulation. |Description|Illustration| |--|--| | To create a new time series in the database, select the “Add new time series” entry in the Database node context menu in the time series explorer. | | | The “Create time series” dialog pops up.

Enter the required time series properties.

The time series properties are:

Name

Time series variable

Unit

Value type

The time step properties are:

Number of time steps

Start time

Time type

Time step

Click “Create time series” to create the time series.

Click “Cancel” to close the form without creating a new time series. | | | The new time series will now appear in the Time series explorer, and can be edited. | |

Create a New Time Series from Tool Results

To create a new time series from Tool Results:

1. Execute|topic=How To Execute A Tool the tool to a chart

2. Right click on the time series legend in the chart area

3. Select ‘Save As’

4. If desired, change the name of the time series that was automatically created by the tool

5. Select the time series group

6. Select ‘OK’

The saved time series will contain the output data from the executed tool.

Create a New Time Series through Models

Time series will automatically created when registering|topic=How To Register A Model a model, defining|topic=How To Define A Scenario a new scenario and when executing|topic=How To Execute A Scenario a scenario.

Time series created during model registration or when defining new scenarios will contain the data available at that time. Time series created when running a scenario will contain the model output for the conditions defined in the scenario.

Export time series

Export to file

Description	Illustration
Time series and time series groups can be exported to a range of file formats using the To file time series tool (see the documentation of the tool).

GIS and time series

Associating time series with GIS features

Description	Illustration
Create an association between a GIS feature and a time series by selecting on or more features in a map view, and select “Add association” from the time series context menu.
Alternatively, drag a time series directly from the time series explorer to a feature in the active GIS layer.

Removing associations

Description	Illustration
To remove all associations between a time series and a GIS feature, right-click on a time series in the time series explorer and select “Remove associations” from the context menu.

Find associated features

Description	Illustration
Start by opening the GIS layer for which the associations shall be displayed. Next, select “Select associated features” from the time series context menu. The associated feature will now be marked as selected in the active map view.

Find associated time series

Description	Illustration
To find the time series that are associated with a map layer or feature, use the Time series query tool (see tool documentation for details)

Import time series

Import time series

This section refers to Ordinary time series only. Ensembles will have to be imported using the “Import from dfs0” tool. |Description|Illustration| |--|--| | To import one or more time series from the disk to the database, right-click on the group to which the series shall be imported, and select Import time series from the context menu.| | | The time series import wizard opens.

The first page contains a list of the time series to be imported.

Initially the list will be empty.

To add time series to the list, click the “Add…” button.| | | A new dialog pops up where the import format can be selected. | | | When OK is clicked, a file-open browser opens, and the user can select a file that will be added to the list.

This is repeated until the list contains all the time series that shall be imported.

Click next to proceed to the next step. | | | The next page contains a list of the time series that will be imported, along with the import settings. Settings include:

Associations to GIS features (Default: none)

Group to import to (Default: The group that was selected when the wizard was started).
To edit the settings, select a time series in the table.

The settings options below become enabled.

The properties for multiple time series can be set in one go by selecting multiple time series in the table (hold the ctrl-key while selecting).

Click next to proceed to the next step.| | | The last page contains a summary of the import settings.

Click “Start Import” to execute the importer.| | | When the import is completed, the status is indicated by color in the list.

Items that have been successfully imported are marked by green color.

Click “Finish” to close the wizard.| |

Batch import of time series

This section refers to Ordinary time series only. |Description|Illustration| |--|--| | Import from DFS0 and Import from ASCII tools both offer a Batch import mode, allowing multiple files to be imported in one operation.

When selecting Batch the Import specification format can be either CSV or Spreadsheet, meaning a list of input specifications should come for either a comma-separated csv-file or a spreadsheet in the database.

In both cases the tabular information must include column headings EXACTLY like these for the import to work:

File name

Item no.

Group Feature class (path)

Feature (display attribute)

Other columns may exist, but are ignored.

The first line (in the file or spreadsheet) contains the header.

An example is shown at the end of this section.|| | Each line in the file or spreadsheet contains a specification of which file and item to import and to which group in time series manager and optionally a feature class and feature to associate the file with.

The feature class field with the feature identifier must be selected as “Display attribute“ for the feature class in GIS Manager for the association to be established. | | | Limitations/requirements for the import are:

Batch specification
“Feature class (path)” and “Feature (display)” fields are optional.

CSV-file
The file must be comman separated.

File name
Extension must be either “.dfs0” or “.txt” (case sensitive) for the respective tool. The file name should include the absolute path to the file.

Item no.
A positive value larger than or equal to 1

Group
A path in Time Series Explorer starting with “/”.It will be created if it does not exist If empty the default Group set for the tool will be used.

Feature class (path)
A full path to an existing feature class in GIS Explorer.

Feature (display)
The value of the field selected as Display Attribuute for the feature class.| | | ASCII File import requires the Variable, Unit and Value type properties to be specified.

These will act as default value for all the imported time series.

But it is possible to add one to more columns to the import specification and override these settings for the individual time series.

The field headings are:

Variable

Unit

ValueType


The possible values are the same as what is show in the drop-down boxes in the Properties dialog.

Unit depends on Variable, so if Variable is specified Unit should also be. | | | ASCII time series have some additional requirements:

Files must have extension “.txt” (lower case)

The header should have a field called “Time” holding date and time.

The data is read following the line with field “Time”

Data can be comma- or TAB-separated

If “Time series overwrite option” is “CreateAndReplace”, item columns should have unique names. In case of non-unique names that last column of the non-unique name will be used.

If “Time series overwrite option” is “CreateButRename”, non-unique columns/items will be renamed with an index suffix

If “Time series overwrite option” is “DontCreate”, non-unique items are handled like for “CreateAndReplace”, but if the target data series already exists in the database it will eventually be skipped.

DateTime is parsed using Current Culture, which means regional settings are used, but using a dateimte in this format : “yyyy-MM-dd HH:mm:ss”, should ensure proper interpretation.

Numbers should be with decimal point

All numbers are interpreted as values.

A missing value should be indicated with an empty “cell” or a text that is not a number. | |

Example of a CSV-file for importing ASCII files

Example of a similar spreadsheet import specification

Managing time series

Create a group

Description	Illustration
To create a new group in the time series explorer, right-click on a node in the time series explorer, and select “Add new group”. The new group is created under the node that was selected. Groups are created with a default name that can be changed by the user.

Rename a group

Description	Illustration
Groups are renamed by selecting “Rename” from the group context menu. When clicked, the node name becomes editable.

Copy groups

Description	Illustration
To copy one or more groups, right-click on the group(s) and select “Copy” from the group context menu. The selected group(s), including the time series and sub-groups contained in the selected group(s) will be copied to the clipboard.
To paste the copied group(s) to a new location, right-click on the destination node and select “Paste” from the context menu. The selected group(s) will be copied to the selected destination. If the destination already contains a group of the same name, the time series will be appended by an index 1, 2, 3…). Groups and time series can also be copied between nodes by drag-and-drop. Select one or more groups, click while holding the ctrl key pressed, and drag them to a new location. When the mouse button is released, the selected groups will be copied to the new location.

Move groups

Description

Illustration

To move one or more groups, right-click on the group(s) and select “Cut” from the group context menu. The selected group(s), including the time series and sub-groups contained in the selected group(s) will be copied to the clipboard. When the groups are cut, the will appear in grey font. To paste the group(s) to a new location, right-click on the destination node and select “Paste” from the context menu. The groups will be removed from the original location, and pasted to the destination. Groups can be moved between nodes by drag-and-drop. Select one or more groups, click, and drag them to a new location. When the mouse button is released, the selected groups will be “dropped” on the new location.

Copy time series

Description

Illustration

To copy one or more time series, select the series, right-click and select “Copy” from the context menu. The selected time series will be copied to the clipboard. Right-click on the destination folder and select “Paste” to paste the copied time series to the destination node. Notice that if a time series is associated to a GIS feature, the association(s) will be copied as well. Time series can be copied between groups by drag-and-drop. Select one or more time series, click, and drag them to a new location while holding the ctrl-key. When the mouse button is released, the selected time series will be copied to the new location.

Move time series

Description

Illustration

To move one or more time series, select the series, right-click and select “Cut” from the context menu. The selected time series will be cut to the clipboard. Right-click on the destination folder and select “Paste” to paste the time series to the destination node. Time series can be moved between groups by drag-and-drop. Select one or more time series, click, and drag them to a new location while holding the ctrl-key. When the mouse button is released, the selected time series will be moved to the new location.

Time series properties

View and edit time series properties

Description	Illustration
To view the properties of a time series, select the time series in the time series explorer to get the properties displayed in the property control. Select the properties to get a short description. Changes in properties that are not read-only will be reflected in the database.

Time series tables

Add time series to table

Description	Illustration
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

Description	Illustration
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: Copy the values from the spreadsheet to the clipboard. Select the cell in the table where the first value in the clipboard shall be added. 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

Description	Illustration
If desired, changes can be committed imManagertely 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.

Print a Table

To print a table:

1. Make the chosen data table active in the Data View.

2. Select the ‘Print’ button .
   A print preview dialogue will be opened

3. The print preview allows various views and zooming to inspect the pages to be printed. Closing the print preview will abort the printing process.

4. Select the ‘Print’ button to print to the computer’s default printer.