Table

icon-table Historic table is accessible from the List View toolbar and Node context menus. The most recent data is always displayed first. Scroll down to automatically load older data or use the Jump to date control to quickly move to a specific date.

The timestamps are always displayed in your preferred timezone and time format. See configuring user preferences for full details.

If you have assigned quality codes to the data the associated quality color is displayed in the table cell(s). Move your mouse over a table cell to display its corresponding quality code and description in the toolbar.

../../../_images/historic_table.jpg

Note

Historic data for all parameters being displayed is automatically interleaved, therefore you may notice empty cells where the parameter(s) do not have a value for the corresponding row timestamp.


Toolbar

icon-filter Filters

Filter the dataset by selecting quality codes associated with the data points that you want to include. While editing data, apply filters to automatically select associated data points and temporarily disable filtered data point cells to prevent modification.

../../../_images/historic_table_filters.jpg
icon-customise Edit data

Use this feature to toggle into data editing mode and display the data editing toolbar.

../../../_images/historic_table_edit_toolbar.jpg

Note

Users must have edit data or edit quality & annotations permission for the parameters they are trying to edit. Data editing is not available on STARTER accounts.


Parameter selection

The historic data dialog will only display the first 15 selected parameters by default. Use the Parameter selection panel accessible via the arrow on the right to refine your selection and change how the data should be displayed, including any aggregate calculations to be applied.

../../../_images/historic_parameter_selection2.jpg

Display type

Value displays the parameter values.

State displays the state name associated with each value.

Aggregate
Aggregates provide a method to resample raw data over a specified period. See the list of available aggregates for full details. Select RAW to display the original raw data with no aggregation applied (Interval and Base time options will be hidden).
Interval
Specify the data range that is included for each calculated value. Example 30M will calculate a value for each 30 minute window of data.
Base time
Base time is used to determine the start of the aggregate calculations. Example D+9H will start the calculations at 9am (start of current day + 9 hours). See working with relative time for full details.

Data editing

icon-customise The edit data button toggles into data editing mode.

Users must have edit data or edit quality & annotations permission for the parameters they are trying to edit. Data editing is not available on STARTER accounts. Table cells or records with a light grey background can not be selected or modified.

Historic data is always edited as raw unprocessed records without any aggregate or transform options applied. Data editing can also be performed in historic charts.

Note

All saved changes are permanent. You should restrict access with the edit data user permission and audit changes via the events view. Limits apply when editing historic data.


Selecting records

icon-selection Click a table cell to select an individual record or click a timestamp to select an entire row.

Selected cells are displayed with a yellow background when the user has both edit data and edit quality & annotations permissions for the parameter. Alternatively a dark grey background will be displayed when the user only has edit quality & annotations permission.

While selecting records, hold the shift key to add or alt key to remove from the current selection.

../../../_images/historic_table_edit_select.jpg

Click and drag over the table to quickly select multiple records.

../../../_images/historic_table_edit_multiselect.jpg

Apply filters to select records based on quality.


Editing records

An individual record can include value, quality and annotation.

Right-click on an editable cell or selection of cells to quickly perform operations via the cell context-menu.

../../../_images/historic_table_edit_contextmenu.jpg


Set value

icon-pencil Enter a new value to be assigned to the selected cell(s) and press enter or click the set value icon. Change the functionality of the value input by selecting a value operation from the dropdown menu.

Use set value to change all selected records to a specific value or offset by value to offset each record by a specific amount.

../../../_images/historic_table_edit_value.jpg

You can also use set value to unset a value (leave blank) which will result in historic charts showing a gap in the series when displaying RAW historic data.


Set quality

icon-quality Select a quality to be assigned to the selected cell(s) from the dropdown quality menu. You can only assign quality codes that have been pre-configured in account settings.

../../../_images/historic_table_edit_quality.jpg


Set annotation

icon-info To set an annotation for a single record either change to annotate mode from the edit toolbar and click on a cell or right-click on a cell and select annotate from the context menu.

Annotations can be set on multiple cells at once by first selecting the cells then selecting annotate from the context menu.

../../../_images/historic_table_edit_annotation_dialog.jpg

Hover or click the annotation icon to display the annotation text.

../../../_images/historic_table_edit_annotation.jpg

To remove an annotation clear the text in the annotation entry dialog or right-click on the cell annotation icon and select remove annotation from the context menu.

../../../_images/historic_table_edit_annotation_contextmenu.jpg


Delete record

icon-remove The delete operation permanently removes the selected records from the historic dataset.


Undo last edit

icon-undo The undo command reverts the last edit operation. You can continue to undo all edit operations since the last save.


Save changes

Save all changes to the modified records.

Note

All saved changes are permanent. You should restrict access with the edit data user permission and audit changes via the events view.

PDF HTML Epub Powered by Read The Docs