Night-by-Night Shelter Daily Analysis Dashboard
A daily LookML dashboard for Emergency Shelter – Night-by-Night programs: clients in beds, bed availability, missing ROIs, and universal data element errors for any date you choose.
Table of Contents
Purpose
The Night-by-Night Shelter Daily Analysis LookML dashboard analyzes clients with a night-by-night emergency shelter bed night on the date specified in the "Analysis Date" filter with the default set to the last complete day (yesterday). The content is broken down into 5 Looks focusing on "Clients in Beds on the Analysis Date", "Available Beds", Missing ROIs", "Profile Screen Data Quality (DQ) Errors", and "Enrollment Screen DQ Errors".
This dashboard only works with programs that use the HUD "Emergency Shelter - Night-by-Night" Project Type Code. This dashboard will not show data for programs that do not have a project type of "Emergency Shelter - Night-byNight".
Dashboard Access
Dashboards are available to all instances with Data Analysis enabled. This dashboard is a LookML Dashboard. How you access this dashboard depends on whether you use standalone or embedded Looker and the access rights assigned to your access role. At a minimum, your access role must have the Data Analysis access right enabled. For details on all access rights, see Rights Glossary for Access Roles.
Standalone Looker
This dashboard is accessible in Looker via the following path: All Folders > LookML Dashboards > Night-by-Night Shelter Daily Analysis Dashboard.
Once selected, your dashboard will start running. The utilized models are dashboard-dependent.
Embedded Looker
This dashboard is accessible in Clarity by navigating to Reports > Data Analysis > Built In Reports > Night-by-Night Shelter Daily Analysis Dashboard. Click Run to open and start running the dashboard.
LookML Dashboards accessed through embedded Looker must first be enabled in the Data Analysis settings before they're available. For steps to enable and access these reports, see the Embedded Looker: Looker - Clarity Human Services Integration article.
Dashboard Filters
The dashboard has 5 filters to limit the data by "Analysis Date", "Agency Name", "Project Type Code", "Program", and "Project Type".
| Dashboard Filter | Details |
|
Analysis Date Default: Last Complete Day (Yesterday) |
Applies to all looks |
|
Agency Name Default: is any value |
Applies to all looks |
|
Project Type Code Default: is "Emergency Shelter - Night-by-Night" |
Applies to all looks |
|
Program Default: is any value |
Applies to all looks |
The "Project Type Code" filter is locked to a specific value due to the requirements of the dashboard. It is displayed in the filter section to filter the results for "Agency Name" and "Program" to match this selected filter.
Content
The following Looks make up the Night-by-Night Shelter Daily Analysis LookML dashboard. The overview below is broken down by dashboard summary and includes a brief summary of the Looks’ content. For more information on how the Look is configured, what fields are used, or custom fields, please review the Look by selecting ‘Explore from Here’ within the ellipses in the upper right corner.
Clients in Beds on the Analysis Date
This Look contains a table showing the clients served in the night-by-night shelter on the selected analysis date. This table includes "Unique Identifier", "Personal ID", "Current Age", "Project Start Date", "Project Exit Date", and "Days in Project" information.
Available Beds
This Look contains a donut pie chart showing the available beds separated into "Occupied" and "Available Beds". The donut pie chart defaults by showing the percentages but you can hover your mouse over the percentage to see the associated count information.
Missing ROIs
This Look contains a single count showing clients served in the night-by-night shelter on the selected analysis date that are missing ROIs.
Profile Screen DQ Errors
This Look contains error counts by the client for universal data elements found on the client profile screen (DE# 3.01 - 3.07).
Enrollment Screen DQ Errors
This Look contains error counts by the client for universal data elements found on the enrollment screen (DE# 3.08, 3.15, 3.16, and 3.917).
Updated: 10/19/2026