Faceting to Check Data Integrity

Use the data faceting function to check the integrity of your data.

This example shows how to use the faceting function to check the integrity of the HR column.

Procedure

  1. Click the data type icon before the HR column header, and change its data type to Integer.
  2. From the HR column menu, click Facet > Numeric facet.
    A bar chart is displayed in the HR facet panel. The heart rates of patients consist of numeric, non-numeric, blank and error data. The heart rate ranges from 10 to 910 beats a minute.

  3. Move to restrict the range of data display.

    If the heart rate of a patient is beyond the reasonable range, for example, from 10 to 200 beats a minute, the data is invalid. For information about how to remove or modify the invalid data, see Removing Invalid Data and Modifying Invalid Data.