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.
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.
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.
Use this feature to toggle into data editing mode and display the data editing toolbar.
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.
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.
Value displays the parameter values.
State displays the state name associated with each value.
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.
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.
Click and drag over the table to quickly select multiple records.
Apply filters to select records based on quality.
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.
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.
Set value
assigns a specific value to selected records.
Offset by value
adds a value to to selected records.
Scale by value
multiplies selected records by a specific value.
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.
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.
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.
Hover or click the annotation icon to display the annotation text.
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.
The delete operation permanently removes the selected records from the historic dataset.
The undo command reverts the last edit operation. You can continue to undo all edit operations since the last save.
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.