Instructions

1. From the Analytics CDA app, open the Comparative Lab Results sheet, (or any sheet that has a data listing.)
2. Click the Full Screen icon to Expand the listing at the bottom of the window.
3. In the header of the column of interest that you want to check for null values (e.g. Result in Standard Units), click the magnifying glass icon.
4. From the pop-up window, click the ellipsis button to open the Selections menu.
5. Click Select all.
6. Click the Green check button to confirm your selection.
7. In a key column that as a unique value for each row (e.g. Subject ID), again click the magnifying glass icon.
8. From the pop-up window, click the ellipsis button to open the Selections menu.
9. Click Select excluded.
10. Click the Green check button to confirm your selection.

The table will update to show results filtered for all subjects’ lab results with null values in the column of interest, e.g. Result in Standard Units.