Datasheets

Datasheets

The Datasheet panel displays data from the database in a tabular normalised format.

Every row of data is a unique record in the database defined by its

  • Level 3 name
  • Datetime stamp
  • Variable, and
  • Value

Metadata consisting of Person Name, Equipment Name, Flag and Quality are also shown by default. Metadata Variables are hidden by default but can be displayed using the Column Chooser.

The datasheet is linked to the Filter Panel to enable you to define filter conditions, which determine the data displayed in the datasheet. Filters can also be set using the Levels panel (See Filtering by Levels for more details).

 mceclip0.png

See also:

  • Filter Panel
  • Filtering by Levels

    • Related Articles

    • Pivoted Datasheets

      Pivoted datasheets allow you to view data in a spreadsheet or grid layout, with the variable headings at the top of the spreadsheet and the data for each site and datetime stamp below in rows. You may be familiar with this grid layout from Version 1 ...

    • Video: Normalised Datasheets

      This video tutorial demonstrates how to view datasheets in DataSight.

    • Video: Pivoted Datasheets

      This video provides a basic overview of pivoted datasheets in DataSight.

    • Microsoft SQL views of Pivoted Datasheets

      Reported: January 31, 2017. Version(s) affected: DataSight 3.0 and 3.1. Issue: Microsoft SQL views of pivoted datasheets are not saved in pivoted tables. Linking the views to other software products such as Microsoft Excel, then does not produce the ...

    • Save a Datasheet

      DataSight helps you save datasheets for reference later without needing to re-construct the filters. Save a datasheet With the datasheet tab selected, click Save or Save As in the Quick Access Toolbar and the Save As dialogue window appears. Click on ...