Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Calculation examples

These synthetic examples teach configuration. They are not validated clinical scoring rules.

Requires: Write access to the questionnaire and synthetic answers with known values.

Mean of three numeric answers

For Daily check-in, select the three numeric question references in an AVERAGE operator. Leave Per item off.

Input: 2, 4, 6. Output: 4.

Only select the intended questions. Missing numeric values are omitted rather than imputed; the mean may therefore use fewer answers than expected.

Reverse one 0–10 answer, then total

Assume the first question must be reversed and the second is scored directly.

  1. Add SUBTRACT, select only the first numeric question, enable Per item, and set Value to 10.
  2. Leave Create unique key off so the selected question value is replaced within this pipeline.
  3. Add ADD, leave Per item off, and select the first and second question references explicitly.

Inputs: first 2, second 4. Reversed first: 10 − 2 = 8. Total: 8 + 4 = 12.

This reverses a numeric scale. For individual value mappings, use RECODE.

Map answer values before totaling

Add RECODE, select the intended numeric references and add the mappings 2 → 1, 4 → 2, 6 → 3. Leave Create unique key off. Add ADD and select only the mapped references.

Inputs 2, 4, 6 become 1, 2, 3; their total is 6. Test every allowed answer value: an unmapped value passes through unchanged and produces a result note.

Flag a synthetic threshold

Create a total pipeline that adds the intended questions. In a later pipeline, select total under Other calculations and apply GREATER_THAN_OR_EQUAL with Value 12.

Input total 12 → result 1; input total 11 → result 0. The comparison tests the first numeric value, not every item of a list.

Count unique text items

Use DISTINCT with Per item off and explicitly select the intended Text or Answer items inputs. Then apply COUNT to the generated DISTINCT result.

Input: ["walk", "rest", "walk"]. Distinct list: ["walk", "rest"]. Count: 2.

Operator reference · Create a calculation.