Filter deleted records

The reporting database for Data Explorer accumulates data over time to allow historical analysis of that data. Records that would normally be deleted from a database are not actually removed from Data Explorer. Instead, these files are flagged to indicate their deleted status. To ensure accurate results in reporting, you must apply a filter to remove the deleted records from your questions. The following table displays three data types that require these filters and the corresponding subjects and fields you must use to filter out the deleted records:

Subject Name Field

Agent Adherence Report

Agent Adherence Report IsDeleted

Agent Schedule

Schedule Activity IsDeleted

Forecast

Forecast IsDeleted

Filter deleted records

  1. In the Filters section of the Question tab, click [limit]. The Select Filter dialog box opens.

  2. Select the appropriate subject name according to the previous table.
  3. Select the appropriate field for that subject name according to the previous table.
  4. Clear the All values check box.
  5. Select the 1 check box. In this filter, 1 means “true.”
  6. Click Add. This first sets the report to include only deleted values.
  7. In the Filters section of the Question tab, click the is drop-down menu in the filter and select is not. The deleted records are removed from the report.