Pivoted Datasheets

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 or 2 of DataSight. In DataSight Version 3, the back end data set has been normalised.  This means that each data record consists of a singular site, date, time, variable name and value, together with other data properties such as Flags and Data Collection. This means that the pivoted datasheet is no longer the only, nor default, view of your data.

 

Pivot your data

  1. Load a datasheet and filter it as desired.
  2. Right-click in the datasheet and select Pivot Datasheet.mceclip0.png

In the above image, the same data set is displayed as that shown in the Datasheets image.

Note

You cannot Filter By Level to change the filter conditions in a pivoted datasheet.  To change the filter conditions, please impose new filter conditions from within the Filter Panel.

Saving the pivoted datasheet will save the:

  • Filter conditions used within the Filter Panel
  • Column Visibility (hidden/shown) and the order in which they appear (left-to-right)
  • Sort preferences (ascending/descending)

Data grouping utilising the Group By Box, or find parameters entered into the Find Panel are not saved with the pivoted datasheet. Column Headers used within the Group By Box revert back to the pivoted datasheet.

Saving pivoted datasheets

  1. Click Save or Save As. A Save As dialogue box appears entitled Pivoted Datasheet.
  2. Select the folder into which you wish to save the pivoted datasheet, then Name the pivoted datasheet and click OK. The pivoted datasheet can now be found in the Saved Views Panel.

    • Related Articles

    • 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 ...

    • Video: Normalised Datasheets

      This video tutorial demonstrates how to view datasheets in DataSight.

    • 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 ...

    • 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 ...