...
Below are some screenshots showing examples of these different 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
...
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. |  |
...