...
Including the subject Record ID as a column is often the best place to start and this column is included by default. Next, use the Edit Columns link to select additional concepts to include as columns in your Results view. Here you can also remove and reorder columns.
...
▶ Video Example: Add columns of data in Results View
...
Aggregation Method
Use the pencil icon at the top of each column to see a menu with a number of options for how to display multiple values for the selected concept.
...
Below are some screenshots showing examples of Aggregation aggregation methods using 2 columns of data:
Patient ID
Medication Code: numeric codes that represent Medications that the patient has indicated they are taking over the course of the study
The screenshot shows the result of applying each aggregation method to the same set of data.
Aggregation Method | Result |
|---|---|
List All: for each Patient ID, all Medication Codes, including duplicates, are listed in a single row separated by a semi colon. |  |
List Distinct: for each Patient ID, distinct Medication Codes are listed in a single row separated by a semi colon. Unlike with List All, each patient’s duplicate codes have been removed. |  |
Stack: Each Medication code is listed one per row. If a patient has more than one Medication Code, their Patient ID can be seen listed multiple times in the Patient ID column. |  |
Count Distinct: Instead of displaying the Medication Code values for a patient, show the count of unique codes for each patient. |  |
Count All: Instead of displaying the Medication Code values for a patient, show the count of all codes (including duplicates) for each patient. |  |
Most Frequent Value: Display only the most frequent Medication Code that is associated with each patient. |  |
...