04 Data Display and Data Editor

Data Display and Data Editor

The Data Display and Data Editor offer graphical displays for presenting and editing of data. Both have the nearly the same functionality but only the Data Editor allows you to edit data.

This display offers the following features:

• Display of time series in:
• graphs (scalar/longitudinal profiles)
• tables (scalar/longitudinal profiles)
• Tabular data editor
• Display of actual data with:
• Historical events__
• Threshold levels__

Data is displayed in a table and a graph simultaneously. The splitter between the table and the graph can be moved to modify the display. Select the data series, that should be displayed with help of the List Boxes and/or the Map Display (see also Filters ).

When the display is started through the FEWS Tools menu item Data Editor , data can be edited and the edited data can be stored in the FEWS data base. When the display is started through the FEWS Tools menu item Data Display or through the FEWS toolbar, the data can only be viewed.
1.1 <ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="bfa550ab-a8de-4191-93de-234fc353e296"><ac:parameter ac:name="">_Toc172823841</ac:parameter></ac:structured-macro><ac:structured-macro ac:name="anchor" ac:schema-version="1" ac:macro-id="fdc5d69b-371f-454a-bdc2-8d494058d322"><ac:parameter ac:name="">_Toc140564169</ac:parameter></ac:structured-macro>Data Display
Press the [Data Display ] button on the toolbar to present graphs displaying the data. The splitter is normally positioned on the left of the display.

When data series of different data types have been selected, the data will be presented in different subplots with the data series of a single data type merged into one subplot.

The data in the graph is updated automatically in case new data becomes available.

Following buttons are used in the Time Series Display:

Table

By clicking this button the time series in the graph is also displayed in tabular format. Please note that in case you like to edit data, you have to select the Data Editor from the Tools menu (see section 4.3).

Shortcuts

Display templates are available for rapid assessment of data. The templates can be activated by clicking the above mentioned button. The left side of the display shows the available shortcuts in a pre-configured grouping.

The data shown via the Shortcuts belong to the forecasts selected in the Forecasts panel of the FEWS Explorer. Please note that the current forecast is always displayed in the graphs.

Graph

 
This button can be used to hide the graph. If the table was not yet selected, it will show up.

Descriptive statistics

This button will add a table to the display with descriptive statistical information. The statistics only appear if a column in the table is selected. Use the right mouse button to copy this table to the clipboard for pasting in Excel.

Statistical Functionality available (if configured):

• Mean/Min/Max
• Standard deviation
• Percentiles (exceedance and non-exceedance)

Supported time series information:

• number of values
• number of missing values

Rotate Splitter

With this button the splitter between table and graph can be placed in a horizontal position. Clicking the same button again returns the splitter to its default vertical position.

Rotate Legend

This button can be used to place the graph legend underneath the graph. Clicking the same button again returns the legend to its default position at the right hand side of the graph.

Toggle Graph

When multiple data series are selected for a single data type (parameter), the graphs will be placed in one subplot of the graph. This sometimes complicates the analysis of time series with different data ranges. By clicking the above mentioned button you can change the layout of the chart:

• Merged into a single graph
• Stacked in different subplots

Scale to show unreliable Data

This button can be used to focus on time intervals with unreliable data within the selected time series. Data is marked as unreliable, if values exceed hard limits.

Show no Thresholds

By clicking this button all pre-configured thresholds which can also be shown in the graphs with the selected time series disappear.

Scale to show relevant Thresholds

With this option the graph is scaled in such a way, that relevant thresholds (the closest threshold values) are displayed together with the selected time series in the graph.

Scale to show all Thresholds

This button can be used to show all pre-configured thresholds of a certain parameter at the selected location(s). This means that all thresholds levels (e.g. Standby, Flood Watch, Flood Warning and Severe Flood Warning) are displayed in the graph.

Show data labels

Clicking the 'Show data labels' will you to display quality flags for the data you are presenting. The information is shown at the bottom of the screen.

The following colour codes have been used:

• the upper line indicates the origin of the data
• original data: no line is displayed
• corrected data (original data flagged as unreliable and automatically interpolated): blue line
• completed data (original data is missing and interpolated by system): magenta line

• the middle line indicates the quality of the data
• reliable data: no line is displayed
• doubtful data: light yellow
• unreliable data: dark yellow

• the lower line indicates where comments have been added to the data
• no comment: no line is displayed
• comment available: dark red

The lines are displayed under the data points. The colours correspond with the colouring used in the tables.

 
Statistical graphing functions
If switched on in the configuration, statistical graphing functions are available to display aggregations, moving averages or duration curves. This functionality works independently from the descriptive statistics table.

Historical Events

With this button historical events can be activated (provided that they are pre-configured). They will be displayed in the same graph to enable a comparison with the actual timeseries. Further explanation is given in section 4.4.

Display time

To change the view period in the graph, the field Display time in the Status Bar below the graph should be double clicked. The display time can now be changed with help of the menu. Press [OK ] to accept the changed view period. The next time the chart is opened the original configured display time will be used again.

Datum Toggle

The Datum Toggle at the lower right hand corner of the display allows levels to be displayed with reference to Local Datum or mAOD .

Navigating in Graphs

Zooming in and out can be done with help of the scroll wheel of the mouse. Scrolling away from the user results in zooming in while scrolling towards the user results in zooming out.

Zooming is also possible by selecting a zoom range. Drag the mouse holding down the right button to form a rectangular area to zoom in to.

When clicking the right mouse button, the dropdown menu presented below appears. The menu gives you some additional options.

Save As

You can save the graph to file with this option.

Print

This option allows you to print the graph.

Zoom in / out

You can select to zoom in and out along one or both axis with this option.

Allow Vertical / Horizontal Axis Zoom

You can select to allow for zooming in and out along one of the axis with this option.

Auto Range

This feature allows you the set automatic scaling along one or both axis.

Data Editor

Select the Data Editor option of the FEWS Tools menu to present tables displaying the data. The splitter can be positioned in such a way, that the complete table is visible.

The most left column shows the date and time of the data. The period displayed spans the overall period defined in the filters for all time series.

The colours in the headings of the columns correspond with the line colour in the graph.

In the date/time column different colours are used to provide a logical meaning to certain important moments:

• Light blue: historical data, either observed or hindcast (data before T~0~ )
• Dark blue: forecast data (data after T~0~ )

For the data columns the background colour is used to indicate the quality of the data, identified by the data flags set of the Validation utility. Further, an indication of the editability of the data is given by the the background colour. The meaning of the background colours in the data fields is:

• White: reliable, editable
• Light yellow: doubtful
• Bright yellow: unreliable
• Gray: not editable

The font colour in the data fields indicates the data origin. Following colours are used:

• Black: original data
• Blue: corrected (original data flagged "Unreliable" and interpolated)
• Magenta: completed (original data missing and interpolated)

Data (only those with a white background) can be edited by double clicking a field in the column. Editing may be done in the table directly. The result of an edit action is directly displayed in the corresponding graph. Manually corrected data will be saved to the database by clicking [Apply ]. With [Cancel ] before saving, changes can be undone. With [Enter ] the changes are validated.

Through manual editing of data, the source of the data changes from original to corrected. The font colour used for edited data is blue to indicate that it is completed data. The background colour remains white, as the data has not yet been validated. If however, after pressing [Apply ] validation indicates that the value exceeds certain validation limits, the background colour will be set accordingly.

Editing Data

By pressing the right mouse button a list with edit actions appears on the screen. These includes the option to copy and fill in data. The display that pops up after clicking the right mouse button on an equidistant timeseries is shown below:

The options have the following meaning...

If the selected timeseries is non-equidistant two extra options will be shown:

The extra options are: 

Historic Events

A special option in the Data Display is the option to add historic events to the chart window.

To show historic events for a specific location take following steps:

• Select the location from the location list box in the FEWS explorer
• Select the parameter from the parameter list box
• Open the chart display by pressing the chart button
• Press the button in the Chart Display and select one of the historical events from the list

A new (red) line will be added to the chart. This event line can now be shifted forwards and backwards in time using the "+" and "-" keys on your keyboard. To activate this shift procedure press the [Historic Events ] button in the Chart Display and select Shift Time.

A small pop-up window shows that you can now shift the historic event forwards and backwards by pressing the "+" or "-" keys on your keyboard. When the shift procedure is completed press [Done ].

Longitudinal profile

Since release 2007.02, the display offers also the opportunity to show longitudinal profiles. In such graph, the parameter values (Y-axis) are plotted against the river chainage (X-axis). The graph can progress over time, eitehr step by step or animated, via the time control toolbar, described in the Spatial display. both the graph and table will change over time as they shown data along the profile.