Missing Data

From the Data Quality Reports page, you can view a Missing Data report. To view:

1. Click the hyperlink of the Name field to view the Missing Data report
   
2. Click to exclude the attribute from the report. Click to include the attribute in the report.
   NOTE: All attributes are included in the report by default.
3. Click the Show Removed checkbox to show excluded attributes. Unclick the Show Removed checkbox to hide excluded attributes.
4. Enter the percentages for the RAG thresholds. Click the Update button to save the RAG thresholds.
5. Click the hyperlink of the Missing (Blank/Null) Records field to filter the Data Records table
   1. The selected attribute is displayed in the heading
      
   2. Click to clear the selected attribute

Data Records

The Data Records tab provides the ability to manage data records in the data quality report.

Available operations:

• View data records in the data quality report
  • Columns available depend on what is defined for the data type
• View the properties of data records by clicking the hyperlink of the Name field
• Edit data records by selecting a record (row) and clicking the Edit Record button on the toolbar
• Assign data records to a wave
  • Select all records (rows) on the page by clicking the Select All button on the toolbar
• You can also change the number of visible rows in the table, view full screen, set column visibility, export to CSV or Excel, refresh the table, and search for text

Edit Record

From the Data Records tab, you can edit the properties of data records. To edit:

1. Select a record (row) to edit
   
2. Click the Edit Record button on the toolbar to bring up the Edit Record dialog
   
   1. The edit button is grayed out unless a record (row) is selected
      
      
   2. The edit function is only available to users in the Administrator security group
3. Edit the properties of the data record
   
   1. Name – Name of the data record (required)
   2. Data Type Specific Columns – Columns specific to the data type
      NOTE: Lookups with a large number of records will be converted from a normal drop down menu to a dialog.
4. Click the Update button when finished to update the data record. Click the Close button to cancel the operation.

Assign to Wave

From the Data Records tab, you can assign data records to a wave. To assign:

1. Select one or more records (rows) to assign to a wave
   
2. Click the Assign to Wave button on the toolbar to bring up the Assign Records to Wave dialog
   
   1. The assign button is grayed out unless a record (row) is selected
      
      
   2. The assign function is only available to users in the Administrator security group
3. Select the waves that you want to assign to from the Waves drop down and then click the Assign button. Click the Close button to cancel the operation.