Instructions

1. From the Analytics CDA app, open the Lab Summary sheet.
2. Click the duplicate button to duplicate the sheet so you can edit it directly, and add a new button to the sheet called Study. When the sheet is duplicated, you will enter Edit mode and be able to modify the duplicated sheet.
3. Select the by variable buttons area so it is outlined.
4. Click to expand Values from the panel on the right.
5. Click the Add Alternative button.
6. Give the button a value of 7 since it’s the seventh button, then label it Study.
7. To link the data to that button so the visualization will be able to display by study, select the table area so it is outlined.
8. Click to expand Data from the panel on the right.
9. From the Dimensions section, click in the Column field to expand it.
10. Click the field Expression Editor button to edit the data sources for the columns. The Edit Expression Window opens with the existing expression for the current buttons displayed.

11. Add a comma after the closing single quotation mark for ‘[LB.Standard Toxicity Grade]’, and type: ‘[DM.Study]’ .

    Note: OK displays in the bottom left corner. If there is an error, it would display here.

12. Click the Apply button at the bottom right to confirm your changes.
13. In the Label field, click the Expression Editor button to edit the chart title. The existing expression for updating the chart title displays in the Edit Expression Window.
14. Add a comma after the closing single quotation mark for ‘Toxicity’, and type: ‘Study’ .
15. Click the Apply button at the bottom right to confirm your change.
16. Click the Done editing button at the top right to confirm all changes to your sheet.

17. Click the newly added Study button, and your lab averages display by study.

    Tip: To further filter your results to specific studies of interest, click the Study filter and select those studies from the selections menu. Click the green check button to confirm your selections.

18. Select any abnormal labs by clicking the name of the lab.

    Tip: The lab values are highlighted according to the color scale at the top right of the sheet, which lets you know which labs fall into the lower than normal or higher than normal ranges.

19. Click the Green Check button to confirm your selection.

Now you have selected all subjects with abnormal lab results, and can jump to any other sheet to view information related to your selection, e.g. Adverse Event Summary sheet to explore any potential related AEs for the subset population with abnormal lab values.