Questions Scoring Calculation

Using the COUNT Function on Question Scores

The COUNT function, combined with the FILTER function, enables you to calculate the number of questions that have achieved a specific risk score within a workflow.

Prerequisites

1. Question Set Setup
   Ensure at least one question set has been configured in the workflow.
2. Scoring Setup
   Scoring must be enabled and configured within the question set. Follow this guide to set up scoring.

Syntax and Usage

The COUNT and FILTER functions work together to identify and count the questions that meet the specified scoring criteria.

Syntax Example

COUNT(FILTER(#[question].[Name Of Question Set].[scores], #[question].[Name Of Question Set].[scores] = scoreValue))

Explanation:

• #[question]: Accesses the questions in the workflow.
• [Name Of Question Set]: Refers to the specific question set (e.g., Design and Operating Tests).
• [scores]: Accesses the scores of the answered questions.
• scoreValue: The specific score you are counting (e.g., 5).

This function can be used for both automatically-scored and manually scored questions.

Example

To count the number of questions in the Design and Operating Tests question set that have a score of 5, the calculation would look like this:

COUNT(FILTER(#[question].[Design and Operating Tests].[scores], #[question].[Design and Operating Tests].[scores] = 5))

Inputs

Returns

The COUNT function returns a number representing the total questions with the specified score across all categories within the workflow.

Note: The count is calculated across all question categories within the workflow, not just a specific subset unless filtered accordingly.

This approach ensures accurate identification of questions meeting the scoring criteria.