Each of the three non-graphical data editors support select, shift-select, CTRL-select, click-drag selection capabilities, and a right-click menu options. Right-click a data point in the Value column to bring up the following menu:
- Restore from Raw copies value from the raw database to the final Value and resets flags
- Set to Minimum Detectable Limit sets data value to MDL configured in Parameter Editor
- Set AQS Code brings up a pick list to apply new AQS null codes
- Set Qualifier Code brings up a selection box for AQS qualifier (exception) codes
- View All Flags s(for single data points only) shows all data logger and system flags and allows you to change or clear flags
- Set Annotations brings up an annotation screen so you can add an annotation
- Batch Edit allows you to scale two or more selected data values as mX+b ( Original Value times a Multiplier plus a Constant Value), for example, divide by 10 and clear the suspect flag. In addition you have the option to combine scaling with one or more of the following:
Update Values
Set Annotations
Set AQS Code
Set Qualifier Code
Set Flags
Set Method Code
- Show Children brings up another instance of the Data Editor with the selected parameters and time range for the Child parameter(s) of the selected parameter. This function requires that Parent-Child Parameter relationships are configured in Configuration Editors > Site/Parameter.
- Drill-Down brings up an instance of the editor with the selected range of data with a smaller averaging interval (e.g., drilling down from hourly data to minute data)
- Export to Excel exports the selected data range to an Excel document, including color, font, and layout details. This right-click option is different from the Export to Excel button in the ribbon at the top of the screen because the button on the ribbon exports the entire data set in the data editor and the right-click option exports only selected data.
- Analyze brings up a sub window that allows the user to determine the average, min, max, or other statistics of the selected data.
- Copy to Clipboard copies the array of selected data into the clipboard so it can be pasted into Excel or other applications.
Click a column heading to sort data by a different heading, for example to group data according to flags. Default is to sort by date.
Click-hold-drag columns to change the order of columns or to drag a column heading to the
Drag a column header here to group by that column area.