...
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.
...