Add New Measurement Time Calculation

This article describes how to add a new Measurement Time Calculation interval. This interval defines the :measurement_time variable that can be used in the Dataset SQL statement.

1. Start Creating a New Measurement Time Calculation Command

Access Admin > Reference Objects > Meas. Time Calcs

Measurement Time Calculation Commands - Google Chrome

[+New Measurement Time Calculation Command] to open Editor

2. Input New Measurement Time Calculation Command data

Measurement Time Calculation Commands - Google Chrome

 

  1. Data Collected Using: Select the SQL Data Source
  2. SQL Statement: Enter the fetch command
  3. [Validate]

If Validation is successful, the SQL statement box will turn green. [Save] the Measurement Time Calculation interval.

3. Add Measurement Interval

Open Measurement Interval tab

  1. [+Add Measurement Interval]
  2. Select the Measurement Intervals by selecting corresponding checkboxes
  3. [Add Selected]

4. Check the "Set :measurement_time value" Dropdown in Dataset Editor

Dataset Editor - Google Chrome

The new Measurement Time Calculation interval will appear in the dropdown menu of the Set :measurement_time value field of the Data Collection Trigger of the Dataset is the same as the Measurement Interval assigned to the Measurement Time Calculation command.

For more details about ":measurement_time" variable check the Usage of the ":measurement_time" Bind Variable article.