Set Variables

Set Variables

To create, modify or delete variables and/or metadata variables, select Variables in the Configure Group on the DataSight Ribbon. The Variables grid view appears listing the existing database variables.

 

Add a Variable

  1. Select the Variables tab in the Main Panel.
  2. Click New in the Quick Access Toolbar and a new row at the bottom of the Variables grid view will be added.
  3. Click in the Variable Name cell to enter the variable name. This cannot be empty.
  4. Click in the Description cell to enter a description.
  5. Click in the Units cell to enter the unit of measurement.
  6. Click in the CAS Number cell to enter the CAS Registry Number identifier.
  7. Select either Data or Metadata from the Type drop-down list.
  8. Click in the Display Format cell to specify the format of your data.

When a number is formatted, it is always rounded to as many decimal places as there are digit placeholders ("0") to the right of the decimal point. If the number contains no decimal point or the format is not specified, the value being formatted is rounded to the nearest whole number. Example number formats are:

0.0 will display 3 as 3.0, 30 as 30.0

0.00 will display 3 as 3.00, 30 as 30.00

It is also possible to display numeric data in scientific notation. 

Note

There are currently limitations on applying Display Format on very large sets of data.

Scientific notation is a method of writing or displaying numbers in terms of a decimal number between 1 and 10, multiplied to the power of 10.  In scientific notation, the letter E is used to mean "10 to the power of."  For example, 1.314E+1 means 1.314 * 101 which is 13.14 .

When the variable display format is set, this format is preferentially used in the Summary Reports.
  1. Click Save in the Quick Access Toolbar or press CTRL + S at any point to save changes and continue, otherwise when you Close the Variables table you will be prompted to save your changes. Variables will appear under the All Variables list in the Variables Panel.

 

Modify a Variable

  1. Select the Variables tab in the Main Panel.
  2. Modify the variables as required. Any changes will appear in italics.
  3. Click Save in the Quick Access Toolbar or press CTRL + S at any point to save changes and continue, otherwise when you Close the Variables grid view you will be prompted to save your changes.

 

Delete a Variable

  1. Select the Variables tab in the Main Panel.
  2. Click to check the Delete checkbox(es) against any variable(s) that you wish to delete.
  3. Click Save in the Quick Access Toolbar at any point to save changes and continue, otherwise when you Close the Variables grid view you will be prompted to save your changes.

Note

If the variable that you intend to delete has associated data, you will need to remove this data from the database to delete this variable from the Variables grid view.

 

    • Related Articles

    • Video: Set Variables

      This video tutorial demonstrates how to set variables in DataSight.

    • Set Standards

      To create, modify or delete standards, select Standards on the DataSight Ribbon. The Standards grid view appears listing existing Standards, and the Standards you have created or modified. Add a Standard Select the Standards tab in the Main Panel. To ...

    • Variables

      DataSight can be used to record data for all types of measured parameters. In DataSight, we refer to these measured parameters as Data Variables. The combination of location, date, time and data variable defines a unique datum. Additional information ...

    • Set Configurations

      To set DSApp configurations from DSApp you will be required to: Tap the Config tab button on the Home Then tap either: New Configuration to create a new configuration. Edit Configuration to edit the settings of the current configuration. You will ...

    • Set Pages

      You can set the viewable pages in a DSApp configuration. You can modify the pages selected, or the mapped sample code variable or the standard, as required. View Options You may enable or disable either the Collect Data and View Data tabs on the Home ...