View a metric result

Metric results contain values that represent an evaluated record's performance for a specific metric, based on a single evaluation from one user or from the execution of a script. Metric results contain actual values as well as calculated values. The system uses values from metric results to calculate category results.

Before you begin

Role required: assessment_admin or admin

About this task

If there is an active scripted metric when the assessment is generated, the system automatically produces a metric result for each associated assessable record. The system produces an additional metric result for each question a user answers on a completed assessment questionnaire. If multiple users complete questionnaires with the same questions on the same assessable records, the system produces metric results for each user's responses. For example, three users complete questionnaires that contain the same four questions about the Acme Corporation record. The system produces 12 metric results: one per user for each question.


  1. Navigate to Assessments > Results > Metric Results.
  2. Click the reference icon (Reference icon) to open the metric result record.
  3. View the Metric Result form.
    All fields on the form except Updated and String value are read-only.
    Table 1. Metric Result form fields
    Field Description
    Assessment group Assessment group to which the metric result is associated.
    Metric Name of the metric to which these metric result values apply.
    Data type Data type of the metric.
    Method Method of the metric.
    Updated Date and time the metric result was last updated.
    Source Source record of the assessable record evaluated.
    Assigned to User who completed the assessment questionnaire. This field is blank when the method is Script.
    Instance Assessment instance completed by the Assigned to user. This field is blank when the method is Script.
    Actual value
    Unscaled value from a user response or script, depending on the method:
    • Assessment: Value obtained from the user response to the assessment instance question. The actual value is determined by the metric data type:
      • Checkbox: The actual value is 0 if the check box is cleared and 1 if it is selected.
      • Choice or Likert Scale: The actual value is equal to the Value of the metric definition associated with the chosen answer option.
      • Date, Date/Time, or String: The actual value is -1 to indicate that these data types do not contribute to category result calculations.
      • Template: The actual value is equal to the Value of the template definition associated with the chosen answer option.
      • Yes/No: The actual value is 0 if the response is No and 1 if it is Yes.
    • Script: Value the script placed in the actual_result variable.

    This field is hidden and left blank when the data type is Duration.

    Duration value Specific kind of actual value that is only applicable if the data type is Duration. The duration value is the value obtained by the script query from the actual_result parameter, such as the average duration of outages for a vendor.
    Scaled value

    Appropriate value from the scaled_result variable in the associated metric script. The code in a scripted metric defines a scaling scheme for the actual values it obtains. For example, a scripted metric queries the CMDB to return the number of configuration items (CIs) for a vendor. The code includes this scaling scheme, where actual_result is the number of CIs, and scaled_result is a representation of the quantity of CIs:

    if (actual_result < 1)
    	scaled_result = 0;
    else if (actual_result < 1000)
    	scaled_result = 1;
    else if (actual_result < 10000)
    	scaled_result = 2;
    else if (actual_result < 25000)
    	scaled_result = 3;
    else if (actual_result < 100000)
    	scaled_result = 4;
    	scaled_result = 5;

    If the script detects 315 CIs for the vendor, the Actual value is 315 and the Scaled value is 1 for this metric result.

    Note: Although this field is visible only when the method is Script, the system populates the field with the Actual value when the method is Assessment, as the scaled value is used in the Normalized value calculation.
    Normalized value Adjusted value that accounts for weights, scale definition, minimum and maximum values, and other factors that impact the metric. The normalized value is calculated as follows:

    Normalized value = (Input Value - Min value defined in metric) / (Max value defined in metric - Min value defined in metric) * current metric weight / (sum of valid metric weight) * scale_factor

    This formula cannot be customized.

    As an example, calculate the normalized value for this metric: Please rate the competency of the technician. This metric has the following values:
    • Input value = 3
    • Minimum value = 1
    • Maximum value = 6
    • Current metric weight = 10
    • Number of responses = 6
      • 4 of type=number
      • 1 of type=yes/no
      • 1 of type=string (invalid data type; value cannot be calculated)
    • Valid metric weight of each response = 10
    • Scale factor = 10

    Normalized value = (3 - 1) / (6 - 1) * 10 / (10 + 10 + 10 + 10 + 10) * 10 = 0.8

    Several data types are ignored because the values cannot be calculated.

    These invalid data types include string, date, and datetime. For reporting purposes, use the Metric Result [asmt_metric_result] table.

    String value Value that displays the response as it appears on a questionnaire. In some cases this is the same as the Actual value, such as when the metric data type is Percentage. The string value is N/A for unanswered questions of certain data types.