You can view and edit time series using the Table dialog.

Values of time series that are not being edited yet, always appear in grey at first.

Non-editable values of time series which are being edited are shown in grey; editable values in black.

Measured values of non-editable time series always appear in grey in the table.

Related Links:

▪Working with graphs

▪Working with tables

▪Legend

▪Axis properties

▪Graph

Features in the table display of measured values

Filter time series table using an error code group

You can adjust the time series in the table to show only values with a certain error code. The selection of an error code or an error code set is done using status code groups. Based on error codes in a selected error code group, values in the table are subsequently filtered. Depending on the need, it is necessary to create a new error code group, if necessary also with only one error code.

To filter time series by error codes,

▪first select the Set status code > Error code context menu entry.

▪The Set status for time range dialog opens.

▪This dialog lists all error code groups created in the system using a drop-down list.

▪In the Time range section, you can select the time range for which you want to filter the table view. This way you can conveniently set the time range.

▪Select an error code group.

▪Confirm with [Accept] and with [OK].

After confirming the selection, only the values that have an error code according to the preselected error code group are displayed in the table. The result can be – depending on the error code group – a completely changed table.

Edit measured values by manual validation

Notethat the error code of a manually validated value after a user input is set to invalid.

To manually validate a value,

▪click in the table cell of the value to be changed in the table display.

▪The table cell is now activated for user input.

▪You can now validate the value manually.

▪Confirm your entry with [Return].

▪The value is rounded if necessary and finally saved.

Setting an error code through manual validation

To set an error code manually,

▪click in the table cell of the error code to be changed in the table display.

▪The system now offers a drop-down list box with error codes.

▪These error codes are imported from the error code group manual validation.

▪If the required error code is not available in the list, proceed as follows:

▪Close the windows of the graph and table.

▪Select the Time series > Error code > Manage error code groups menu item.

▪Assign the desired error code to the error code group manual validation under system.

▪Close the dialog and save your entries.

▪Now open the time series browser again.

▪Click here the [View] button anew.

▪AquisNet reloads the time series in the time series list for table and graph.

▪Now click again in the table cell of the error code to be changed in the table display.

▪The system now offers a drop-down list box with error codes. This list has been extended by the error code just added to the manual validation group.

▪Select the desired error code.

▪Confirm your entry with [Return].

▪The new error code is now set.

Manually change error code over a time range

To set an error code manually,

▪select one or more rows in the table by moving the mouse pointer over the rows to be selected while holding down the left mouse button, or select several rows by pressing the [Ctrl] key to select several lines one after the other.

▪In the context menu, select the Set status code > Quality flag entry.

▪The Set status in the selected area dialog opens.

▪Here you can subsequently vary the edit range in the Time range section.

▪Now select the desired error code from the drop-down list box in the Status section.

▪These error codes are imported from the error code group manual validation.

▪If the required error code is not available in the list, proceed as follows:

▪Close the current dialog and the graph and table windows.

▪Select the Time series > Error code > Manage error code groups menu item.

▪Assign the desired error code to the error code group manual validation under system (New assignment of an error code to an error code group).

▪Close the dialog and save your entries.

▪Now open the time series browser again.

▪Click here the [View] button anew.

▪AquisNet reloads the time series in the time series list for table and graph.

▪Select the desired time range in the table again.

▪In the context menu, select the Set status code > Quality flag entry.

▪The Set status in the selected area dialog opens.

▪Here you can subsequently vary the edit range in the Time range section.

▪Now select the desired error code from the drop-down list box in the Status section.

▪This list has been extended by the error code just added to the manual validation group.

▪Now select the desired error code.

▪Confirm your entry with [Return].

▪The new error code is now set for all values or row entries in the marked time range.

Saving manual changes during exit (transaction)

If you change and save values or error codes in one or more time series, AquisNet proceeds as follows.

The database records before and after the change are recorded in a transaction. This makes it possible that the data before the change can be accessed again later. The data is used in the event of a possible later restoration of a previous data status.

To reduce the storage volume and the organisational effort of the transactions, AquisNet only saves the "affected" time range at a time and this - see above - with the data status before the changes.

▪In addition to the pure measurement data of all affected time series before the change, AquisNet stores an identifier, a comment and the responsible user in transactions. Furthermore, the system stores the date and a transaction ID.

▪When you close the table, the system displays a save dialog.

▪If you confirm it with [Yes], the system generates a transaction.

In the table display, changes are displayed in the Comment column for each time series individually.

This lists all changes that have been made to a time series and arranges them in chronological order. In this way, users can record changes made to a time series "at a glance".

The following information is displayed:

▪Transaction ID and transaction name

▪Date of the user action

▪Responsible user

Output options:

AquisNet automatically enumerates the changes, ordered by time stamp and time series.

▪If a graph with the same measured values is open, the units in the axis labels for the values will be adapted automatically.

Specify remarks

▪Remarks for the individual values can be entered in the Comments column.

▪Double-click in the remarks column and select further steps.