Dashboard Library

Program Performance Dashboard

Release Date: 05/23/2022

Purpose

The Program Performance Dashboard was created to encourage performance review and analysis on a program basis. Inspired by the System Performance Measures and other federal and local reporting benchmarks, this 25 tile dashboard provides a breadth of data points to begin analysis efforts and conversations about a program’s performance, system-wide improvements, and data quality completion and compliance. 

This dashboard highlights data points within 6 sections - Persons Served, Length of Time in Program, Obtaining/Increasing/Maintaining Income and Non-Cash Benefits, Average Program Utilization, Housing Move-in Date Review, and Data Quality. Each section header contains information on what will be covered and what project types are applicable for the Looks within the section. More specific information about the Look can be found within the info bubble like a summary of the data being depicted, client universe information, and applicable filters. 

Dashboard Details

This dashboard is accessible in Looker by utilizing the following pathway:

  • “All Folders” 
    • “LookML Dashboards”
      • “Program Performance”

Once selected, the dashboard will begin to run. This dashboard utilizes the HMIS Performance, Population Over Time, and Data Quality Models. 

Filters

Program Performance Filters

The following filters are available for this dashboard:

  • Reporting Period
    • Select the Reporting Period for the dashboard. The date range selected will include client data for those enrolled within the select time frame.
    • Default: “Is in the last 90 days”
  • CoC Code
    • Select the CoC(s) to include in the dashboard. Once selected Agency Name, and Program Name filters will update to only reflect information associated with the CoC(s) selected.
    • Default: “is any value” 
  • Agency Name
    • Select the Agency(-ies) to include in the dashboard. Like the CoC Code, this filter will also update Program Name to only include programs associated with the selected agency(-ies). 
    • Default: “is any value” 
  • Program Name
    • Select the name of the program(s) to include in the dashboard. 
    • Default: “is any value” 
  • Project Type
    • Filtering by project type is also available. This filter will update Program Name to only include programs associated with the selected project type(s). 
    • Default: “is any value” 

All filters are optional. Filters in this dashboard are not limited to a single selection. Applicable filters for each Look will be listed below in Tile Overview. 

Tile Overview

The dashboard contains 25 tiles built to assist in program performance review and analysis. Each section header includes applicable project types. Each Look has an info bubble note for more information about the data present within the tile. 

Persons Served

Applicable Project Types: ES, SO, SH, TH, PH, RRH, and CE-SSO

Program Performance - Persons Served Section

Client/Household/Enrollment Counts Within the Reporting Period

This Look contains a multiple value visualization with a distinct count of clients, unduplicated count of households, and count of enrollments within the set reporting period.  

Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

  • Measures
    • Clients - Number of Clients
    • Entry Screen - Count Households
    • Enrollments - Count
  • “Explore from Here”
    • There are two ways to explore this Look to obtain more information.
      • Select “Explore from Here”, then click on any count in the data section for a drill down. Each count will display different information. 
        • Client Count: Drill down contains Personal ID, Unique Identifier, Client Full Name, and Current Age. 
        • Household Count: Drill down contains ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date.
        • Enrollment Count: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date. 
      • The drill down Looks can also be achieved by selecting any count on the dashboard tile.
    • Tip: For a data quality review, “Explore from Here” and change the “Year: is not null” filter to “is null”. Drill down on the null count to identify and review clients that were entered or exited on a date that has not yet occurred, or have a project exit date before their project start date. 

Program Performance - Perons Served - Client_HH_Enrollment Count

Annual Enrollment Counts 

This Look contains a column visualization with active client counts for the past 5 complete years, a YTD count, and an average reference line. To be counted within a year, clients must either have an enrollment start date within the year or were active at that point in time.   

Applicable Filters: CoC, Agency Name, Program Name, and Project Type Code

  • Filters
    • Enrollments Report Period Filter: is in the past 6 years
    • Custom Dimension - Year: is not null 
  • Custom Fields
    • Custom Dimension
      • Year
        • Expression: 

if(${enrollments.start_date}<=now() 

AND (${enrollments.end_date}>=trunc_years(now()) 

OR is_null(${enrollments.end_date})),extract_years(now()),

 if(${enrollments.start_date}<trunc_years(now()) 

AND (${enrollments.end_date}>=add_years(-1,trunc_years(now())) 

OR is_null(${enrollments.end_date})),extract_years(add_years(-1,now())),

 if(${enrollments.start_date}<add_years(-1,trunc_years(now())) 

AND (${enrollments.end_date}>=add_years(-2,trunc_years(now())) 

OR is_null(${enrollments.end_date})),extract_years(add_years(-2,now())),

      if(${enrollments.start_date}<add_years(-2,trunc_years(now())) 

AND (${enrollments.end_date}>=add_years(-3,trunc_years(now())) 

OR is_null(${enrollments.end_date})),extract_years(add_years(-3,now())),

        if(${enrollments.start_date}<add_years(-3,trunc_years(now())) 

AND (${enrollments.end_date}>=add_years(-4,trunc_years(now())) 

OR is_null(${enrollments.end_date})),extract_years(add_years(-4,now())),

 if(${enrollments.start_date}<add_years(-4,trunc_years(now())) 

AND (${enrollments.end_date}>=add_years(-5,trunc_years(now())) 

OR is_null(${enrollments.end_date})),extract_years(add_years(-5,now())),

null))))))

  • Measures
    • Enrollments - Number of Enrollments
  • “Explore from Here”
    • There are two ways to explore this Look to obtain more information.
      • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date.
      • The drill down Looks can also be achieved by selecting any column count on the dashboard tile.

Program Performance - Persons Served - Annual Counts

Monthly Entry/Exit Counts

This Look contains a column visualization with monthly counts for clients entering and exiting a project within the past 13 months. This Look helps identify typical inflow/outflow and monthly trends.   

Applicable Filters: CoC, Agency Name, Program Name, and Project Type Code

  • Custom Fields
    • Custom Measures
      • Clients Entering
        • Filtered Measure: Enrollments - Count
        • Custom Filter

extract_months(${enrollments.start_date})=extract_months(${population.observation_date_month}) AND extract_years(${enrollments.start_date})=extract_years(${population.observation_date_month})

      • Clients Exited 
        • Filtered Measure: Enrollments - Count
        • Custom Filter

extract_months(${enrollments.end_date})=extract_months(${population.observation_date_month}) AND extract_years(${enrollments.end_date})=extract_years(${population.observation_date_month})

  • Dimensions
    • Observation Date • Population - Month 
  • “Explore from Here”
    • There are two ways to explore this Look to obtain more information.
      • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date.
      • The drill down Looks can also be achieved by selecting any column count on the dashboard tile.
Program Performance - Persons Served - Monthly Entry-Exit

Inbound Recidivism - Returners

This Look contains a column visualization with a count of clients that have returned to the system or the same program. The Look contains counts of clients that are enrolled within the reporting period and have previously been enrolled with the same program(s) selected in the filters and/or the system, or within a 2 year lookback period from the reporting period end date. 

Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

  • Custom Fields
    • Custom Measures
      • Program (Filtered: 2 Year Lookback)
        • Field Measured: Inbound Recidivism - Count Clients Appeared Before in Same Program
        • Custom Filter

diff_days(${inbound_recidivism.previous_exit_in_same_program_date},${enrollments.reporting_period_end_date})<=730

    • System (Filtered: 2 Year Lookback)
      • Field Measured: Inbound Recidivism - Count Clients Appeared Before
      • Custom Filter

diff_days(${inbound_recidivism.previous_exit_date},${enrollments.reporting_period_end_date})<=730

  • Measures
    • Inbound Recidivism - Count Clients Appeared Before (System)
    • Inbound Recidivism - Count Clients Appeared Before In Same Program (Program)
  • “Explore from Here”
    • There are two ways to explore this Look to obtain more information.
      • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Enrollment ID, Program Name, Project Type Code, and Appeared Before (Yes/No).
      • The drill down Looks can also be achieved by selecting any column count on the dashboard tile.

Program Performance - Persons Served - Returners

First Time in System/Same Program

This Look contains a column visualization with the percentage of clients that are enrolled in the system or same program for the first time with and without a filtered 2 year lookback period from the reporting period end date. 

Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

    • Custom Fields
      • Custom Measures
        • Program (Filtered: 2 Year Lookback)
          • Filtered Measure: Inbound Recidivism - Count Clients Appeared Before in Same Program
          • Custom Filter

    diff_days(${inbound_recidivism.previous_exit_in_same_program_date},${enrollments.reporting_period_end_date})<=730

        • System (Filtered: 2 Year Lookback)
          • Filtered Measure: Inbound Recidivism - Count Clients Appeared Before
          • Custom Filter

     diff_days(${inbound_recidivism.previous_exit_date},${enrollments.reporting_period_end_date})<=730

    • Table Calculations
      • First Time in System
        • Expression:
    (${clients.count}-${inbound_recidivism.count_clients_appeared_before})/${clients.count}
      • First Time in System (Filtered: 2 Year Lookback)
        • Expression:

    (${clients.count}-${count_clients_appeared_before_system_2_year_lookback})/${clients.count}

      • First Time in Program
        • Expression: 

    (${clients.count}-${inbound_recidivism.count_clients_appeared_before_in_same_program})/${clients.count}

      • First Time in Program (Filtered: 2 Year Lookback)
        • Expression: 

    (${clients.count}-${count_clients_appeared_before_same_program_2_year_lookback})/${clients.count}

    • Measures
      • Inbound Recidivism - Count Clients Appeared Before (System)*
      • Inbound Recidivism - Count Clients Appeared Before In Same Program (Program)*
      • Clients - Number of Clients* 
    • “Explore from Here”
      • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Enrollment ID, Program Name, Project Type Code, and Appeared Before (Yes/No). Table Calculations do not have drill down functionality. 

    *Note: Fields are hidden from the visualization. Counts can be reviewed by utilizing “Explore from Here” or the Inbound Recidivism - Returners Look. 

    Program Performance - Persons Served - First Time

    Length of Time in Program

    Applicable Project Types: ES, SO, SH, TH, PH, RRH, and CE-SSO

    Program Performance LoT Section

    Length of Time (LoT) in Program

    This Look contains a table visualization containing average, median, minimum, and maximum length of time; count of long-term stayers; and counts of clients, households, and enrollments broken down by stayers, leavers, and all clients (totals row). Stayers are clients that were enrolled within the reporting period and do not have an exit date within the reporting period. Leavers are clients that were enrolled within the reporting period and have an exit date within the reporting period.

    Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

    • Custom Fields
      • Custom Measures
        • Long Term Stayers (365+ Days)
          • Filtered Measure: Clients - Number of Clients
          • Filter: Enrollments - Days in Project > 364 Days
        • Max Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Max
        • Median Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Median
        • Min Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Min
      • Custom Dimensions
        • Stayers/Leavers
          • Expression:  

    case( when((${enrollments.end_date}>=${enrollments.reporting_period_start_date}  AND ${enrollments.end_date}<${enrollments.reporting_period_end_date}),"Leavers"), when((is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date})),"Stayers"),null)

    • Measures
      • Clients - Number of Clients
      • Enrollments - Average Days in Project 
      • Enrollments - Count
      • Entry Screen - Count Households 
    • “Explore from Here”
      • There are two ways to explore this Look to obtain more information.
        • Drill down functionality is available for Average Days in Project, Long Term Stayers, Client Count, Household Count, and Enrollment Count. 
      • Select “Explore from Here”, then click on any count listed above in the data section for a drill down (details below).
        • Average Days in Project: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, Housing Move-in Date, and Days in Project.
        • Long Term Stayers and Client Count: Drill down contains Personal ID, Unique ID, Client Full Name, and Current Age.
        • Household Count: Drill down contains ID, Household ID, Personal ID, Unique Identifier, Client Full Name, Project Start Date, and Project Exit Date.
        • Enrollment Count: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date.
      • The drill down Looks can also be achieved by selecting the table count for Average Days in Project, Long Term Stayers, Client Count, Household Count, or Enrollment Count on the dashboard tile.

    Program Performance - LoT - Stayers vs Leavers

    Length of Time Comparisons - Project Type

    This Look contains a table visualization containing average, median, minimum, and maximum length of time; count of long-term stayers; and counts of clients, households, and enrollments broken down by stayers, leavers, and all clients (total row) for all clients by project type. This Look cannot be filtered by Agency Name, Project Name, or Project Type as it was designed to be used to compare a program’s LoT data points to similar project types systemwide. 

    Stayers are clients that were enrolled within the reporting period and do not have an exit date within the reporting period. Leavers are clients that were enrolled within the reporting period and have an exit date within the reporting period. 

    Applicable Filters: Reporting Period and CoC

    • Custom Fields
      • Custom Measures
        • Long Term Stayers (365+ Days)
          • Filtered Measure: Clients - Number of Clients
          • Filter: Enrollments - Days in Project > 364 Days
        • Max Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Max
        • Median Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Median
        • Min Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Min
    • Dimensions
      • Programs - Project Type Code
    • Measures
      • Clients - Number of Clients
      • Enrollments - Average Days in Project 
      • Enrollments - Count
      • Entry Screen - Count Households 
    • “Explore from Here”
      • There are two ways to explore this Look to obtain more information.
        • Drill down functionality is available for Average Days in Project, Long Term Stayers, Client Count, Household Count, and Enrollment Count. 
        • Select “Explore from Here”, then click on any count listed above in the data section for a drill down (details below).
          • Average Days in Project: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, Housing Move-in Date, and Days in Project.
          • Long Term Stayers and Client Count: Drill down contains Personal ID, Unique ID, Client Full Name, and Current Age.
          • Household Count: Drill down contains ID, Household ID, Personal ID, Unique Identifier, Client Full Name, Project Start Date, and Project Exit Date.
          • Enrollment Count: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date.
        • The drill down Looks can also be achieved by selecting the table count for Average Days in Project, Long Term Stayers, Client Count, Household Count, or Enrollment Count on the dashboard tile.

    Program Performance - LoT in Program - Project Type Comparison

    Length of Time - Leavers by Destination Category

    This Look contains a table visualization containing Length of Time in project, count of clients, and percent of clients by destination category for leavers (exited within the reporting period). 

    Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

    • Custom Filter
      • Leavers 

    ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date}

    • Custom Fields
      • Custom Measures
        • Long Term Stayers (365+ Days)
          • Filtered Measure: Clients - Number of Clients
          • Filter: Enrollments - Days in Project > 364 Days
        • Max Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Max
        • Median Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Median
        • Min Days in Project
          • Filtered Measure: Enrollments - Days in Project
          • Measure Type: Min
      • Table Calculations
        • Percent of Exits 
          • Expression

    ${clients.count}/${clients.count:total}

    • Dimensions
      • Update/Exit Screen - Destination Category
    • Measures
      • Clients - Number of Clients
      • Enrollments - Average Days in Project 
      • Enrollments - Count
      • Entry Screen - Count Households 
    • “Explore from Here”
      • There are two ways to explore this Look to obtain more information.
        • Select “Explore from Here”, then click on any count in the data section for a drill down. Table Calculations do not have drill down functionality. 
          • Average Days in Project: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, Housing Move-in Date, and Days in Project.
          • Client Count: Drill down contains Personal ID, Unique Identifier, Client Full Name, and Current Age.
        • The drill down Looks can also be achieved by selecting the table count within the dashboard tile. 

    Program Performance - LoT - Leavers+Destination

    Income and Non-Cash Benefits 

    Applicable Project Types: ES, SO, SH, TH, PH, RRH, and CE-SSO

    Program Performance - Income and Benefits Section

    Increased/Maintained Total Household Income 

    This Look contains a table visualization with All Clients, Stayers, and Leavers that increased or maintained total household income from entry screen to latest screen (status update or exit).

    Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

    • Custom Fields
      • Custom Measures
        • Enrollments - Increased/Maintained Total Household Income at Update/Exit*
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ${household_entry_screen.total_household_income}<=${household_exit_screen.total_household_income} OR (is_null(${household_entry_screen.total_household_income}) AND ${household_exit_screen.total_household_income}>0)

        • Enrollments - Total Household Income at Project Start*
          • Filtered Measure: Enrollments - Count
        • LEAVERS Enrollments*
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date}

        • LEAVERS Enrollments - Increased/Maintained Total Household Income at Update/Exit*
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ((${household_entry_screen.total_household_income}<=${household_exit_screen.total_household_income} OR (is_null(${household_entry_screen.total_household_income}) AND ${household_exit_screen.total_household_income}>0))) AND ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date}

        • STAYERS Enrollments*
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date})

        • STAYERS Enrollments - Increased/Maintained Total Household Income at Update/Exit*
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ((${household_entry_screen.total_household_income}<=${household_exit_screen.total_household_income} OR (is_null(${household_entry_screen.total_household_income}) AND ${household_exit_screen.total_household_income}>0)))

    AND ((is_null(${enrollments.end_date})) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date}))

    • Table Calculations
      • All Clients
        • Expression:

    ${enrollments_increasedmaintained_total_household_income_at_updateexit}/${enrollments_total_household_income_at_project_start}

      • Leavers
        • Expression:

    ${leavers_enrollments_increasedmaintained_total_household_income_at_updateexit}/${leavers_enrollments}

      • Stayers
        • Expression:

    ${stayers_enrollments_increasedmaintained_total_household_income_at_updateexit}/${stayers_enrollments}

    • “Explore from Here”
      • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Enrollment ID, Program Name, Project Start Date, and Project Exit Date. Table Calculations do not have drill down functionality. 

    *Note: Fields are hidden from the visualization. Counts for hidden fields can be reviewed by utilizing “Explore from Here”. 

    Program Performance - Income and Benefits - Income

    Obtained/Maintained Non-Cash Benefits 

    This Look contains a table visualization with All Clients, Stayers, and Leavers (18 or older) that obtained or maintained non-cash benefits from entry screen to latest screen (status update or exit). The logic for obtaining/maintaining non-cash benefits is broken down for each benefit type (i.e., WIC, SNAP, TANF, etc.) 

    Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

    • Filters
      • Entry Screen - Age at Report Start/Project Start/Current Date: is greater than 17
      • Enrollments - Enrollment Household: is HUD Age
    • Custom Fields
      • Custom Measures
        • LEAVERS Enrollments
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date}

        • LEAVERS Enrollments - Obtained/Maintained Non-Cash Benefits
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    (((${entry_screen.benefits_other}="Yes") AND (${last_screen.benefits_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_other}="Yes") AND (${last_screen.benefits_tanf_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_childcare}="Yes") AND (${last_screen.benefits_tanf_childcare}="Yes")) OR

    ((${entry_screen.benefits_tanf_transportation}="Yes") AND (${last_screen.benefits_tanf_transportation}="Yes")) OR

    ((${entry_screen.benefits_snap}="Yes") AND (${last_screen.benefits_snap}="Yes")) OR

    ((${entry_screen.benefits_wic}="Yes") AND (${last_screen.benefits_wic}="Yes"))

    OR

    ((${entry_screen.benefits_other}="No") AND (${last_screen.benefits_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_other}="No") AND (${last_screen.benefits_tanf_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_childcare}="No") AND (${last_screen.benefits_tanf_childcare}="Yes")) OR

    ((${entry_screen.benefits_tanf_transportation}="No") AND (${last_screen.benefits_tanf_transportation}="Yes")) OR

    ((${entry_screen.benefits_snap}="No") AND (${last_screen.benefits_snap}="Yes")) OR

    ((${entry_screen.benefits_wic}="No") AND (${last_screen.benefits_wic}="Yes")))

     AND (${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date})

        • Obtained/Maintained Non-Cash Benefits
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    (((${entry_screen.benefits_other}="Yes") AND (${last_screen.benefits_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_other}="Yes") AND (${last_screen.benefits_tanf_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_childcare}="Yes") AND (${last_screen.benefits_tanf_childcare}="Yes")) OR

    ((${entry_screen.benefits_tanf_transportation}="Yes") AND (${last_screen.benefits_tanf_transportation}="Yes")) OR

    ((${entry_screen.benefits_snap}="Yes") AND (${last_screen.benefits_snap}="Yes")) OR

    ((${entry_screen.benefits_wic}="Yes") AND (${last_screen.benefits_wic}="Yes"))

    OR

    ((${entry_screen.benefits_other}="No") AND (${last_screen.benefits_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_other}="No") AND (${last_screen.benefits_tanf_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_childcare}="No") AND (${last_screen.benefits_tanf_childcare}="Yes")) OR

    ((${entry_screen.benefits_tanf_transportation}="No") AND (${last_screen.benefits_tanf_transportation}="Yes")) OR

    ((${entry_screen.benefits_snap}="No") AND (${last_screen.benefits_snap}="Yes")) OR

    ((${entry_screen.benefits_wic}="No") AND (${last_screen.benefits_wic}="Yes")))

        • STAYERS Enrollments
          • Filtered Measure: Enrollments - Count 
          • Custom Filter

    is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date})

        • STAYERS Enrollments - Obtained/Maintained Non-Cash Benefits
          • Filtered Measure: Enrollments - Count 
          • Custom Filter 

    (((${entry_screen.benefits_other}="Yes") AND (${last_screen.benefits_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_other}="Yes") AND (${last_screen.benefits_tanf_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_childcare}="Yes") AND (${last_screen.benefits_tanf_childcare}="Yes")) OR

    ((${entry_screen.benefits_tanf_transportation}="Yes") AND (${last_screen.benefits_tanf_transportation}="Yes")) OR

    ((${entry_screen.benefits_snap}="Yes") AND (${last_screen.benefits_snap}="Yes")) OR

    ((${entry_screen.benefits_wic}="Yes") AND (${last_screen.benefits_wic}="Yes"))

    OR

    ((${entry_screen.benefits_other}="No") AND (${last_screen.benefits_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_other}="No") AND (${last_screen.benefits_tanf_other}="Yes")) OR

    ((${entry_screen.benefits_tanf_childcare}="No") AND (${last_screen.benefits_tanf_childcare}="Yes")) OR

    ((${entry_screen.benefits_tanf_transportation}="No") AND (${last_screen.benefits_tanf_transportation}="Yes")) OR

    ((${entry_screen.benefits_snap}="No") AND (${last_screen.benefits_snap}="Yes")) OR

    ((${entry_screen.benefits_wic}="No") AND (${last_screen.benefits_wic}="Yes"))) AND (is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date}))

      • Table Calculations
        • All Clients
          • Expression:

    ${obtainedmaintained_non_cash_benefits}/${enrollments.count}

        • Leavers
          • Expression:

    ${leavers_obtainedmaintained_non_cash_benefits}/${leavers_enrollments}

        • Stayers
          • Expression:

    ${stayers_obtainedmaintained_non_cash_benefits}/${stayers_enrollments}

    • Measures
      • Enrollments - Count
    • “Explore from Here”
      • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, and Project Exit Date. Table Calculations do not have drill down functionality. 

    *Note: Fields are hidden from the visualization. Counts for hidden fields can be reviewed by utilizing “Explore from Here”. 

    Program Performance - Income and Benefits - Non-Cash Benefits

    Obtained/Maintained Health Insurance

    This Look contains a table visualization with All Clients, Stayers, and Leavers that obtained or maintained health insurance from entry screen to latest screen (status update or exit). The logic for obtaining/maintaining health insurance is not dependent upon the type of insurance but rather if the client is covered by any health insurance. 

    Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

    • Custom Fields
      • Custom Measures
        • LEAVERS Enrollments
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date}

        • LEAVERS Enrollments - Obtained/Maintained Health Insurance
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ((${entry_screen.health_insurance}="Yes" AND ${last_screen.health_insurance}="Yes") OR (is_null(${entry_screen.health_insurance}) AND ${last_screen.health_insurance}="Yes") OR (${entry_screen.health_insurance}="No" AND ${last_screen.health_insurance}="Yes")) AND (${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date})

        • Obtained/Maintained Health Insurance
          • Filtered Measure: Enrollments - Count
          • Custom Filter

    ((${entry_screen.health_insurance}="Yes" AND ${last_screen.health_insurance}="Yes") OR (is_null(${entry_screen.health_insurance}) AND ${last_screen.health_insurance}="Yes") OR(${entry_screen.health_insurance}="No" AND ${last_screen.health_insurance}="Yes"))

        • STAYERS Enrollments
          • Filtered Measure: Enrollments - Count 
          • Custom Filter

    is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date})

        • STAYERS Enrollments - Obtained/Maintained Health Insurance
          • Filtered Measure: Enrollments - Count 
          • Custom Filter 

    ((${entry_screen.health_insurance}="Yes" AND ${last_screen.health_insurance}="Yes") OR (is_null(${entry_screen.health_insurance}) AND ${last_screen.health_insurance}="Yes") OR(${entry_screen.health_insurance}="No" AND ${last_screen.health_insurance}="Yes")) AND is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date})

      • Table Calculations
        • All Clients
          • Expression:

    ${obtainedmaintained_insurance_enrollment_count}/${enrollments.count}

        • Leavers
          • Expression:

    ${leavers_obtainedmaintained_insurance_benefits}/${leavers_enrollments}

        • Stayers
          • Expression:

    ${stayers_obtainedmaintained_insurance_benefits}/${stayers_enrollments}

    • Measures
      • Enrollments - Count
    • “Explore from Here”
      • Select “Explore from Here”, then click on any count in the data section for a drill down containing Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, and Project Exit Date. Table Calculations do not have drill down functionality. 

    *Note: Fields are hidden from the visualization. Counts for hidden fields can be reviewed by utilizing “Explore from Here”. 

    Program Performance - Income and Benefits - Health Insurance

    Average Utilization

    Applicable Project Types: ES, SH, TH, PH, RRH

    Each Look within this section is specific to the project types listed within the tile. When reviewing program utilization, if programs do not have an applicable project type, the Look will produce a null value.

    Program Performance - Average Utilization Section

    Average Program Utilization Rate within Analysis Period (ES - E/E, TH, SH)

    This Look contains a single value visualization containing the average rate of utilization within the Reporting Period for Emergency Shelter (Tracking Method: Entry/Exit), Transitional Housing, and Safe Haven programs. 

    Applicable Filters: Reporting Period, CoC, Agency Name, and Program Name

    • Filters
      • Programs - Project Type Code: is equal to Emergency Shelter, Transitional Housing, Safe Haven
      • Programs - Tracking Method: matched(advanced) Entry/Exit Date,NULL
    • Custom Fields
      • Table Calculation
        • Program Utilization
          • Expression:

    ${enrollments.total_days_in_project_during_reporting_period}/${program_inventory_hmis.total_bed_inventory_ap}

    • Measures
      • Enrollments - Count*
      • Enrollments - Total Days in Project During the Reporting Period*
      • Bed and Unit Inventory - Total Bed Inventory for Analysis Period • Bed Allocations for Analysis Period*
    • “Explore from Here”
      • Select “Explore from Here”, then click on any count in the data section for a drill down. Table Calculations do not have drill down functionality. 
        • Enrollment Count: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date
        • Total Days in Project During the Reporting Period:  Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, Housing Move-in Date, and Days in Project During the Reporting Period
        • Total Bed Inventory for Analysis Period • Bed Allocations for Analysis Period: Drill down contains Agency ID, Agency Name, Program ID, Program Name, ID, Household ID, Availability, Bed Type, and Total Bed Inventory for Analysis Period

    *Note: Fields are hidden from the visualization. Counts for hidden fields can be reviewed by utilizing “Explore from Here”. 

    Program Performance - Average Utilization - ES TH SH

    Average Program Utilization Rate within Analysis Period (ES - NbN)

    This Look contains a single value visualization containing the average rate of utilization within the Reporting Period for Emergency Shelter (Tracking Method: Night-by-Night) programs. 

    Applicable Filters: Reporting Period, CoC, Agency Name, and Program Name

    • Filters
      • Programs - Project Type Code: is equal to Emergency Shelter
      • Programs - Tracking Method: is equal to Night-by-Night
      • Services - Service Category: is equal to Housing
      • Custom Filter

    ${service_dates.date_date}>=${enrollments.reporting_period_start_date} AND ${service_dates.date_date}<${enrollments.reporting_period_end_date} 

    • Custom Fields
      • Table Calculation
        • Program Utilization
          • Expression:

    ${service_dates.count}/${program_inventory_hmis.total_bed_inventory_ap}

    • Measures
      • Enrollments - Count*
      • Bed and Unit Inventory - Total Bed Inventory for Analysis Period • Bed Allocations for Analysis Period*
      • Service Attendance Dates - Count*
      • “Explore from Here”
        • Select “Explore from Here”, then click on any count in the data section for a drill down. Table Calculations do not have drill down functionality. 
        • Enrollment Count: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date
        • Total Bed Inventory for Analysis Period • Bed Allocations for Analysis Period: Drill down contains Agency ID, Agency Name, Program ID, Program Name, ID, Household ID, Availability, Bed Type, and Total Bed Inventory for Analysis Period
        • Service Attendance Dates - Count: Drill down contains Personal ID, Service ID, Service Name, Service Item ID, Service Item Name, Service Attendance Dates, First Attendance Dates, and Last Attendance Dates

      *Note: Fields are hidden from the visualization. Counts for hidden fields can be reviewed by utilizing “Explore from Here”.Program Performance - Average Utilization - ES NbN

      Average Program Utilization Rate within Analysis Period (PH/RRH)

      This Look contains a single value visualization containing the average rate of utilization within the Reporting Period for Permanent Housing and Rapid Re-Housing programs. 

      Applicable Filters: Reporting Period, CoC, Agency Name, and Program Name

      • Filters
        • Programs - Project Type Code: contains PH 
        • Programs - Tracking Method: matches (advanced) Entry/Exit Date,NULL
      • Custom Fields
        • Custom Dimension
          • LoT in Project During the Reporting Period (HMD)
            • Expression:

      case(when(((is_null(${enrollments.end_date})AND ${entry_screen.move_in_date}<=${enrollments.reporting_period_start_date})),(diff_days(${enrollments.reporting_period_start_date},${enrollments.reporting_period_end_date}))),

       when(((is_null(${enrollments.end_date})AND ${entry_screen.move_in_date}>${enrollments.reporting_period_start_date})),(diff_days(${entry_screen.move_in_date},${enrollments.reporting_period_end_date}))), 

      when((((${enrollments.end_date}>=${enrollments.reporting_period_end_date}) AND ${entry_screen.move_in_date}<=${enrollments.reporting_period_start_date})),(diff_days(${enrollments.reporting_period_start_date},${enrollments.reporting_period_end_date}))), 

      when((((${enrollments.end_date}>=${enrollments.reporting_period_end_date}) AND ${entry_screen.move_in_date}>${enrollments.reporting_period_start_date})),(diff_days(${entry_screen.move_in_date},${enrollments.reporting_period_end_date}))),

      when((((${enrollments.end_date}<${enrollments.reporting_period_end_date}) AND ${entry_screen.move_in_date}>${enrollments.reporting_period_start_date})),(diff_days(${entry_screen.move_in_date},${enrollments.end_date}))),

      when((((${enrollments.end_date}<${enrollments.reporting_period_end_date}) AND ${entry_screen.move_in_date}<${enrollments.reporting_period_start_date})),(diff_days(${enrollments.reporting_period_start_date},${enrollments.end_date}))), null)

        • Table Calculations
          • Program Utilization
            • Expression:

      ${sum_days_in_project_in_reporting_period}/${program_inventory_hmis.total_bed_inventory_ap:total}

          • Sum - Days in Project in the Reporting Period
            • Expression: 

      sum(${lot_in_project_during_the_reporting_period_hmd}*${enrollments.count})

      • Measures
        • Enrollments - Count*
        • Enrollments - Total Days in Project During the Reporting Period*
        • Bed and Unit Inventory - Total Bed Inventory for Analysis Period • Bed Allocations for Analysis Period*
      • “Explore from Here”
        • Select “Explore from Here”, then click on any count in the data section for a drill down. Table Calculations do not have drill down functionality. 
          • Enrollment Count: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, and Housing Move-in Date
          • Total Days in Project During the Reporting Period: Drill down contains Personal ID, Enrollment ID, Head of Household (Yes/No), Program Name, Project Start Date, Project Exit Date, Housing Move-in Date, and Days in Project During the Reporting Period
          • Total Bed Inventory for Analysis Period • Bed Allocations for Analysis Period: Drill down contains Agency ID, Agency Name, Program ID, Program Name, ID, Household ID, Availability, Bed Type, and Total Bed Inventory for Analysis Period

      *Note: Fields are hidden from the visualization. Counts for hidden fields can be reviewed by utilizing “Explore from Here”.

      Program Performance - Average Utilization - PH RRH

      Housing Move-in Date Review

      Applicable Project Types: PH and RRH

      Program Performance - HMD review section

      Enrolled in PH/RRH w/ a Housing Move-in Date

      This Look contains a liquid fuel gauge visualization containing the percent of clients enrolled in a PH/RRH program with a housing move-in date within the reporting period. 

      Applicable Filters: Reporting Period, CoC, Agency Name, and Program Name

      • Filters
        • Programs - Project Type: contains PH 
      • Custom Fields
        • Custom Measure
          • Enrollment w/ Housing Move-in Date
            • Filtered Measure: Enrollments - Count
            • Filters: 
              • Entry Screen - Housing Move-in Date is not null
              • Custom Filter

      ${entry_screen.move_in_date}>=${enrollments.start_date}

        • Table Calculations
          • Enrolled w/ Housing Move-in Date
            • Expression: 

      ${enrollment_w_housing_move_in_date}/${enrollments.count}

      • Measures
        • Enrollments - Count 

      Program Performance - Housing Move-in Date - Enrolled w HMD

      Average Days From Project Start Date to Housing Move-in Date 

      This Look contains a single value visualization containing the length of time in project from Project Start Date to Housing Move-in Date within the Reporting Period.

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Filters
        • Programs - Project Type: contains PH 
      • Measures
        • Entry Screen - Average Days from Project Start to Move-in

      Program Performance - Housing Move-in Date - avg days

      Data Quality

      Applicable Project Types: ES, SO, SH, TH, PH, RRH, and CE-SSO

      Program Performance - DQ  Section

      UDE Completion

      This Look contains a radial gauge visualization containing the percent of clients with an enrollment within the Reporting Period without any Universal Data Element errors.

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Custom Fields
        • Custom Measure
          • DQ UDE = None Enrollments Count
            • Filtered Measure: Enrollments - Count
            • Custom Filter

      ${dq_client_program_demographics.client_location_error}="None" AND ${data_quality.name_data_quality_error}="None" AND

      ${data_quality.name_error}="None" AND

      ${dq_client_program_demographics.disabling_condition_error}="None" AND

      ${data_quality.dob_error}="None" AND

      ${dq_client_demographics.ethnicity_error}="None" AND

      ${dq_client_program_demographics.exit_destination_error}="None" AND

      ${dq_client_demographics.gender_error}="None" AND

      ${dq_client_program_demographics.household_id_error}="None" AND

      ${dq_client_program_demographics.housing_move_in_date_error}="None" AND

      ${dq_client_program_demographics.approximate_date_homelessness_started_a_error}="None" AND

      ${dq_client_program_demographics.length_of_stay_at_prior_place_a_error}="None" AND

      ${dq_client_program_demographics.living_situation_a_error}="None" AND

      ${dq_client_program_demographics.number_of_months_homeless_in_past_three_years_a_error}="None" AND

      ${dq_client_program_demographics.number_of_occurrences_client_has_been_in_homeless_situation_a_error}="None" AND

      ${dq_client_program_demographics.approximate_date_homelessness_started_b_error}="None" AND

      ${dq_client_program_demographics.length_of_stay_at_prior_place_b_error}="None" AND

      ${dq_client_program_demographics.less_than_7_nights_b_error}="None" AND

      ${dq_client_program_demographics.living_situation_b_error}="None" AND

      ${data_quality.name_data_quality_error}="None" AND

      ${data_quality.name_error}="None" AND

      ${dq_client_program_demographics.number_of_months_homeless_in_past_three_years_a_error}="None" AND

      ${dq_client_program_demographics.number_of_months_homeless_in_past_three_years_b_error}="None" AND

      ${dq_client_program_demographics.number_of_occurrences_client_has_been_in_homeless_situation_a_error}="None" AND

      ${dq_client_program_demographics.number_of_occurrences_client_has_been_in_homeless_situation_b_error}="None" AND

      ${dq_client_program_demographics.night_before_on_streets_es_sh_b_error}="None" AND

      ${dq_client_programs.end_date_error}="None" AND

      ${dq_client_programs.start_date_error}="None" AND

      ${dq_client_demographics.race_error}="None" AND

      ${dq_client_program_demographics.relationship_to_hoh_error}="None" AND

      ${data_quality.ssn_error}="None" AND

      ${dq_client_demographics.theatre_of_operations_afghanistan_operation_enduring_freedom_error}="None" AND

      ${dq_client_demographics.theatre_of_operations_iraq_operation_iraqi_freedom_error}="None" AND

      ${dq_client_demographics.theatre_of_operations_iraq_operation_new_dawn_error}="None" AND

      ${dq_client_demographics.theatre_of_operations_korean_war_error}="None" AND

      ${dq_client_demographics.theatre_of_operations_persian_gulf_war_operation_desert_storm_error}="None" AND

      ${dq_client_demographics.theatre_of_operations_other_peacekeeping_operations_or_military_interventions_such_as_lebanon_panama_somalia_bosnia_kosovo_error}="None" AND

      ${dq_client_demographics.theatre_of_operations_world_war_ii_error}="None" AND

      ${dq_client_demographics.veteran_status_error}="None" AND

      ${dq_client_demographics.year_entered_military_service_year_error}="None" AND

      ${dq_client_demographics.year_separated_from_military_service_year_error}="None"

        • Table Calculation
          • UDE Completion
            • Expression: 

      ${dq_ude_none_enrollments_count}/${dq_client_programs.count}

      • Measures
        • Enrollments - Count 

      Program Performance - DQ - UDE Completion

      Exit Destination Completion

      This Look contains a radial gauge visualization containing the percent of clients that exited within the Reporting Period without any Exit Destination errors. Exit Destinations flagged as errors are Client Doesn’t Know, Client Refused, Data Not Collected, No Exit Interview Completed, and Other. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Custom Fields
        • Custom Measure
          • Exit Destination Completed - Enrollments Count 
            • Filtered Measure: Enrollments - Count
            • Filter: Update/Exit Screen - Destination is not Client Doesn’t Know, Client Refused, Data Not Collected, No Exit Interview Completed, and Other
        • Table Calculation
          • Exit Destination Completion
            • Expression: 

      ${exit_destination_completed_enrollments}/${enrollments.count}

      • Measures
        • Enrollments - Count

      Program Performance - DQ - Exit Destination Compliance

      Annual Assessment Compliance

      This Look contains a radial gauge visualization containing the percent of clients with an enrollment within the Reporting Period that have a completed or due Annual Assessment Status. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Filters
        • DQ Annual Assessments  - Annual Assessment Status: matches (advanced) -No Targeted Annual Assessment,-Enrolled Less than 1 Year,-Assessment Window Opening in 30 Days or Less,-Assessment Window Opening More Than 30 Days
      • Custom Fields
        • Table Calculation
          • Annual Assessment Compliance
            • Expression: 

      (${dq_client_programs.count:total}-${dq_annual_assessments.annual_assessment_error_count:total})/${dq_client_programs.count:total}

      • Dimensions 
        • DQ Annual Assessments - Annual Assessment Status  
      • Measures
        • DQ Annual Assessments - Count Annual Assessment Errors
        • Enrollments - Count

      Program Performance - DQ - Annual Assessment Compliance

      Universal Data Element Errors - Profile Screen

      This Look contains a bar chart visualization containing the count of clients with an enrollment within the Reporting Period with Name, Name Data Quality, SSN, Date of Birth, Gender, Race, Ethnicity, Veteran, and Relationship to Head of Household errors. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Measures
        • DQ Client UDE Error Counts • Name Error Count
        • DQ Client UDE Error Counts • Name Data Quality Error Count
        • DQ Client UDE Error Counts • SSN Error Count
        • DQ Client UDE Error Counts • DOB Error Count
        • DQ Client UDE Error Counts • Gender Error Count
        • DQ Client UDE Error Counts • Race Error Count
        • DQ Client UDE Error Counts • Ethnicity Error Count
        • DQ Client UDE Error Counts • Veteran Status Error Count
        • DQ Client UDE Error Counts • Relationship to HoH Error Count

      Program Performance - DQ - UDE Errors Profile Screen

      Exit Destination Errors 

      This Look contains a bar chart visualization containing the count of clients that exited within the Reporting Period with Exit Destination errors broken down by Destination. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Filters
        • Update/Exit Screen: is equal to Client Doesn't Know, Client Refused, Data Not Collected, No Exit Interview Completed, Other OR is null 
        • Custom Filter:

      ${enrollments.end_date}>=${enrollments.reporting_period_start_date}AND${enrollments.end_date}<${enrollments.reporting_period_end_date}

      • Dimensions
        • Update/Exit Screen - Destination
      • Measures
        • Enrollments - Count

      Program Performance - DQ - Exit Destination Errors

      Annual Assessment Status Overview

      This Look contains a pie chart visualization containing an Annual Assessment Status breakdown of clients with a Past Due, Due, Completed, or Completed Out of Range status. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Filters
        • DQ Annual Assessments  - Annual Assessment Status: matches (advanced) -No Targeted Annual Assessment,-Enrolled Less than 1 Year,-Assessment Window Opening in 30 Days or Less,-Assessment Window Opening More Than 30 Days
      • Dimensions
        • DQ Annual Assessments - Annual Assessment Status
      • Measures
        • Enrollments - Count

      Program Performance - DQ - Annual Assessment pie

      Universal Data Element Errors - Enrollment Screen

      This Look contains a bar chart visualization containing the count of clients with an enrollment within the Reporting Period with Project Start Date, Project End Date, Exit Destination, Client Location, Disabling Condition, and Prior Living Situation errors. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Custom Fields
        • Custom Measure
          • Prior Living Situation Errors
            • Filtered Measure: Enrollments - Count
            • Custom Filter

      ${dq_client_program_demographics.approximate_date_homelessness_started_a_error}!="None" OR ${dq_client_program_demographics.length_of_stay_at_prior_place_a_error}!="None" OR ${dq_client_program_demographics.living_situation_a_error}!="None" OR ${dq_client_program_demographics.number_of_months_homeless_in_past_three_years_a_error}!="None" OR ${dq_client_program_demographics.number_of_occurrences_client_has_been_in_homeless_situation_a_error}!="None" OR ${dq_client_program_demographics.approximate_date_homelessness_started_b_error}!="None" OR ${dq_client_program_demographics.did_you_stay_less_than_90_days_b_error}!="None" OR ${dq_client_program_demographics.length_of_stay_at_prior_place_b_error}!="None" OR ${dq_client_program_demographics.less_than_7_nights_b_error}!="None" OR ${dq_client_program_demographics.living_situation_b_error}!="None" OR ${dq_client_program_demographics.number_of_months_homeless_in_past_three_years_b_error}!="None" OR ${dq_client_program_demographics.number_of_occurrences_client_has_been_in_homeless_situation_b_error}!="None" OR ${dq_client_program_demographics.night_before_on_streets_es_sh_b_error}!="None"

      • Measures
        • DQ Client UDE Error Counts • Client Location Error Count
        • DQ Client UDE Error Counts • Disabling Condition Error Count
        • DQ Client UDE Error Counts • Project End Date Error Count
        • DQ Client UDE Error Counts • Project Start Date Error Count
        • DQ Client UDE Error Counts • Exit Destination Error Count

      Program Performance - DQ - UDE Errors Enrollment

      Data Entry Timeliness

      This Look contains a table visualization with the count of enrollments within each Data Entry Timeliness group (0 Days, 1-3 Days, 4-6 Days, and 7+ Days), average length of time, and percent of enrollments within the group. Data Entry Timeliness calculations are based on the number of days between data collection and data entry in HMIS. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Filter
        • Custom Dimension - Data Entry Timeliness Groups: "Is not equal to null"
      • Custom Fields
        • Custom Dimension
          • Data Entry Timeliness Groups
            • Expression

      case(
        when((is_null(${dq_client_program_demographics.timeliness})),"null"),
        when(${dq_client_program_demographics.timeliness}="0","0 Days"),
        when(${dq_client_program_demographics.timeliness}="1","1 - 3 Days"),
        when(${dq_client_program_demographics.timeliness}="2" ,"1 - 3 Days"),
        when(${dq_client_program_demographics.timeliness}="3" ,"1 - 3 Days"),
        when(${dq_client_program_demographics.timeliness}="4","4 - 6 Days"),
        when(${dq_client_program_demographics.timeliness}="5","4 - 6 Days"),
        when(${dq_client_program_demographics.timeliness}="6","4 - 6 Days"),"7+ Days")

        • Table Calculation
          • Percent of Enrollments 
            • Expression

      ${dq_client_programs.count}/${dq_client_programs.count:total}

      • Measures
        • Enrollments - Average Timeliness of Data Entry
        • Enrollments - Count 

      Program Performance - DQ - Data Entry Timeliness

      Client Notes - Enrollment Level Timeliness

      This Look contains a table visualization with the count of enrollment level client notes within each Client Notes Entry Timeliness group (0 Days, 1-3 Days, 4-6 Days, and 7+ Days), and percent of client notes within the group. Client Notes Entry Timeliness is calculated by the days between Client Notes - Enrollment Level Case Note Date and Added Date. 

      Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, and Project Type Code

      • Filter
        • Custom Dimension - Client Notes Entry Timeliness: "Is not equal to null"
      • Custom Fields
        • Custom Dimension
          • Client Notes Timeliness
          • Expression:

      diff_days(${client_notes_enrollment_level.date_date},${client_notes_enrollment_level.added_date})

        • Client Notes Entry Timeliness
          • Expression

      case(
       when((is_null(${client_note_timeliness})),"null"),
       when(${client_note_timeliness}=0,"0 Days"),
       when(${client_note_timeliness}<=3,"1 - 3 Days"),
       when(${client_note_timeliness}<=6,"4 - 6 Days"), "7+ Days")

      • Table Calculation
        • Percent of Client Notes - Enrollment Level 
          • Expression

      ${client_notes_enrollment_level.count}/${client_notes_enrollment_level.count:total}

      • Measures
        • Enrollments - Counts

      Program Performance - DQ - Client Note Timeliness