Calculation Templates

Calculation Templates

DataSight allows you to save your Calculation as a template that can be accessed later:

  • To pre-fill level, variable, time shifting, formula, flags and output fields in Calculation as defined in the saved template.
  • To be used as reference by any other user.

The Calculation Template window consists of the following items:

  • Name - the name of the saved calculation template.
  • Formula - the formula used in the calculation template.
  • When Saving, Delete - a check-box allowing you to select and delete a calculation template.

 

Open a Calculation Template

  1. On a Calculation, click Open from the Quick Access Toolbar or press ALT+O. The Calculation Templates Window opens.
  2. Select a suitable template from the list and click Open. The calculation is pre-filled with preferences as defined in your selected template. You may also edit these preferences further if necessary.

 

Save a Calculation Template

  1. With your Calculation preferences set, click Save on the Quick Access Toolbar or press CTRL+S. The Calculation Templates Window opens.
  2. Enter a name for your template.
  3. Click Save. Your Calculation Template is now saved.

 

Modify a Calculation Template

  1. Open a Calculation Template.
  2. Edit preferences on Calculation as required.
  3. Click Save. Your Calculation Template has now been modified.

 

Delete a saved Calculation Template

  1. On a Calculation, click Save on the Quick Access Toolbar or press CTRL+S. The Calculation Templates Window opens.
  2. Click on a template to delete it.
  3. Check the Delete
  4. Click Save.
  5. A dialogue box confirms your action. Click OK.

    • Related Articles

    • Manual Data Entry Templates

      When entering data with Manual Data Entry, templates can replicate your field datasheets, and be saved so data records can be keyed in quickly. These are called Manual Data Entry templates. Save a Manual Data Entry Template To save the current Manual ...

    • Sharing Report Templates

      You can create customised reports using Report Designer. If the report needs to be re-created in a new database with the same design, this can be done by sharing the report template. DataSight allows you to save the report, and share its template ...

    • Flag During a Calculation

      During a calculation, you may wish to flag your output data set. The Flags section allows you to: Use the current Flag to your calculated data as set for the input variable Change to a new flag from the available Flags Calculate or compute the ...

    • Check all import templates have date time delimiters

      Reported: October 4, 2018 Version(s) affected: DataSight 3.4 onwards Issue: Date and Time Delimiters in Step 1 of the Import need to be precisely identified. Data validation is strictly enforced in DataSight version 3.4 onwards and any change in date ...

    • Microsoft SQL Server Privileges

      Administrators need to be aware of the how Microsoft SQL Server privileges for users are managed within DataSight. We can group DataSight users or administrators into four different categories. User Category Limited User Standard User Advanced User ...