...
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.
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.
Stack (one row per data point)
If a single subject has more than one value for the concept, multiple rows will display for the subject.
List Distinct
If a single subject has more than one value for the concept, all distinct values will be listed in a single row separated by a semi colon. No repeated values will be listed.
List All
If a single subject has more than one value for the concept, all values will be listed in a single row separated by a semi colon. Repeated values will be listed.
Count Distinct
If a single subject has more than one value for the concept, a count of distinct values will be displayed.
Count All
If a single subject has more than one value for the concept, a count of all values will be displayed.
Most Frequent Value
If a single subject has more than one value for the concept, only the most frequent value (or 2nd most frequent, or 3rd most frequent…) will be displayed. Additional options can be set to display the count or both the count and the value.
Latest Value
If a single subject has more than one value for the concept, only the latest value (or 2nd latest value, or 3rd latest value…) added will be displayed.
Earliest Value
If a single subject has more than one value for the concept, only the earliest value (or 2nd earliest value, or 3rd earliest value…) added will be displayed.
Has Value
If a single subject has more than one value for the concept, you can display True/False for specific values. You can also choose to display a count for specific values.
Aggregation Methods Examples
Below are some screenshots showing examples of these different methods using 2 columns of data: Patient ID and numeric codes that represent Medications that the patient has indicated they are taking over the course of the study.
Aggregation Method | Result |
|---|---|
List All: for each patient ID, all Medication Codes, including duplicates, are listed in a row separated by a semi colon. |  |
List Distinct: for each patient ID, distinct Medication Codes are listed in a row separated by a semi colon. Duplicates 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. |  |
Save Query
Save your Results View as a Report by using the Save Query button. The report will save both your selected columns but also any cohort filters.
...