Editing existing logged measurement data

Edit existing data logs to adjust incorrect data, outliers, roll overs, jitter, and other unexpected or unwanted data. You can also fill in missing data and insert missing data records.

To edit existing logged measurement data:

  1. In Manual Data Editor, click Load New Data to open the Load Data dialog box.

    NOTE: Load Data opens automatically when you start Manual Data Editor.

  2. In Load Data:
    • Select the Source for which you want to edit the logged data.
    • Select the Measurement for which you want to edit the logged data.
    • Click Add Data to Selection to add the source/measurement to the list of items to be opened in the data editor.
  3. (Optional) Repeat step 2 to add additional sources and measurements to the selection list.
  4. In Load Data, select the Time Range for the logged data you want to open in the data editor.
  5. (Optional) In Load Data, set the following data editor options:
    • Timezone - Set the timezone for the display of the configurable timestamp in the data editor. The data editor shows two timestamps for each data record, one timestamp in UTC and one in a configurable timezone.
    • Timestamp Format - Set the format for the timestamp display in the data editor.
    • Number Format - Set the number of decimals that are displayed for the logged data in the data editor.
    • Is Interval Data - Select the check box to enable this property. Set the expected logging interval for the data.

      This setting ensures that there is a data row in the editor for every expected log entry. If there is no data record for an expected entry in the database, then the Manual Data Editor inserts a timestamped row with a <no data> data values in the editor. This makes it easier to identify missing records and correct them.

      NOTE: The data editor shows all logged records in the selected time range, regardless of the Interval Data settings. No records are hidden or filtered out.

  6. Click Load Data to open the source/measurement data in the data editor.
  7. (Optional) In the data editor, click Load New Data to change which data is loaded, the time range, or the editor options.
  8. (Optional) In the data editor, click View Issue Report to see which data issues were identified with the loaded data by Manual Data Editor.
  9. (Optional) In the data editor, use Locate Issues to find and step through the data issues identified by Manual Data Editor. The data editor uses different color highlights to mark data issues.
  10. Locate data records that you want to edit and use any of the following tools or methods to edit the data:
    • Click a data record and edit the data value.
    • Insert Timestamp - Insert a new data record with a timestamp that you specify. The timestamp must be in the time range of the data that is loaded into the editor. The new record has <no data> data values.

      NOTE: A historical data log timestamp marks the end of the logging interval. For example, a data log with a 15 minute logging interval and timestamp of 17:00 represents data for the time interval of 16:45 - 17:00.

    • Smart Gap Fill - Automatically fill missing data values in a selected time range, or the entire time range of the loaded data set. You can choose between different interpolation algorithms to fill the missing data. See Smart Gap Fill UI for more details.
    • Delete a data record or data value. These options are available in the right-click context menu.
    • Set a data value to <null>. This option is available in the right-click context menu.
    • Copy one or more data values and paste them into an external editor, such as Microsoft Excel, for bulk editing. Paste the modified data values back into Manual Data Editor. The copy and paste options are available in the right-click context menu.

      NOTE: Only select the data values for copy/paste, not the timestamps.

    TIP: Modified data values are shown in bold font in the Manual Data Editor.

  11. (Optional) In the data editor, use Locate Changes to find and step through the edited data records.
  12. (Optional) Revert edited data values back to their original value. This option is available in the right-click context menu. Use Undo all Changes to revert all edits in the loaded data set.
  13. Click Apply Changes to write the data log changes to the database.

    NOTE: The Apply Changes command permanently writes the data log changes to the database. There is no undo option for this command. See Reverting previous data edits for more information.

  14. (Optional) Click View Log to see a historical audit log of all the data log changes.
  15. Close Manual Data Editor.

 

For information on how to use the Manual Data Editor , see:

For reference information see: