...
Subjects who received drug X within 3 months of stem cell transplant and who have brain MRI post transplant.
Subjects who scored over X on a clinical rating scale after receiving XYZ treatment at an encounter.
▶ Video Example: Create a temporal query
Results View
Use the Results menu item to view of subject-level data. The records shown will include all subjects included in the cohort defined in the Query Tool. Or, clear cohort criteria in the left column to view records for all subjects.
...
▶ Video Example: Add columns of data in Results View
...
Aggregation Method for Columns
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 methods using 2 columns of data:
Patient ID: Aggregation Method on this column is always set to ‘Stack’
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 dataMedication Code column.
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. |  |
...