- Clarity Human Services Help Center
- Data Analysis
- Looker Field Spotlight
-
New Clarity Human Services Interface
-
2024 Data Standards
-
News and Announcements
-
Clarity Human Services: INVENTORY
-
Clarity Human Services: Outreach
-
Coordinated Entry
-
Getting Started
- Accessing Clarity Human Services
- Client Records and Households
- Program Enrollments
- Managing Client Data in Screens
- Services
- Entering Client Location Data
- Files, Notes, and Contacts
- Charts and Goals
- The Attendance Module
- Working with the Referrals Tab and Community Queues
- Recording and Managing Referrals in the Client Record
-
System Administration
-
Agency Management
-
HUD and Federal Partner Resources
-
Report Library
- Introduction
- Administrator Reports
- Agency Management Reports
- Assessment-Based Reports
- Client Reports
- Community and Referrals
- Data Quality Reports
- Housing Reports
- HUD and Federal Partner Reports
- Profile Screen Reports
- Program-Based Reports
- Service-Based Reports
- Pentaho Release Notes - Current Year
- Pentaho Release Notes - Previous Years
-
Data Analysis
-
Data Integration and Migration
-
Submit a Request
-
System Status
-
COVID-19 Resources
Looker Field Spotlight - Deleted Data Overview
The Client Model and Project Descriptor Model are the two models that contain deleted data. However, there are instances where deleted data fields may be included in other models.
To ensure that reports produce the expected results, use the following tips to identify deleted fields and filter appropriately.
Searching for Deleted Fields in Looker
By searching "deleted" in the "Find a Field" search bar in Looker, you can locate fields associated with data that may have been deleted. These deleted data fields can be included in Looks to review if data has been deleted.
Filtering Deleted Fields in Looker
Additionally, once the fields from applicable views are identified, Looker users can utilize filtering (basic filters or custom filters) within a Look using these "Deleted (Yes/No)" fields to include/exclude deleted data based on your analysis needs. This enables more precise control when creating content allowing you to either include or ignore records that are marked as deleted, depending on your business logic or reporting requirements.
