Dashboard Library

Program Performance Dashboard

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

Capture 2023-02-02 at 9.48.27

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 selected time frame.
    • Default: “Is in the last 90  complete days”
    • Note: For accurate average utilization results, a date range or complete days/weeks/months/quarters/years should be used for the reporting period filter. 
  • 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” 
    • Note: Agency Name filter results are impacted by CoC and Program Name filter selection. 
  • Program Name
    • Select the name of the program(s) to include in the dashboard. 
    • Default: “is any value” 
    • Note: Program Name filter results are impacted by CoC, Agency Name, Project Type, Continuum Project, and HMIS Participating Project filter selections. 
  • Project Type
    • Select the project type(s) to include in the dashboard. 
    • Default: “is any value” 
    • Note: Project Type filter results are impacted by Program Name filter selection. 
  • Continuum Project
    • Select to filter on continuum projects or non-continuum projects. 
    • Default: “is any value” 
  • HMIS Participating Project 
    • Select to filter on HMIS participating projects or non-participating projects. 
    • Default: “is any value” 
  • Veteran Status
    • Select veteran status(-es) to include in the dashboard. 
    • Default: “is any value” 
  • Chronically Homeless Household at Project Start 
    • Select chronic homeless status to include in the dashboard. 
    • 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

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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

  • 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, Project Type Code, Continuum Project , HMIS Participating Project , Veteran Status, and Chronically Homeless at Project Start -  Household

  • 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, Project Type Code, Veteran Status, and Chronically Homeless at Project Start -  Household

  • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

  • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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

    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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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. 

    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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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 

    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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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 merged 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, Program Name, Continuum Project, and HMIS Participating Project

    • Primary Query - Inventory within Date Filter (Project Descriptor Model) 
      • Filters
        • Filters - Date Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to Emergency Shelter, Transitional Housing, Safe Haven
        • Programs - Tracking Method: is null OR is equal to Entry/Exit Date 
        • Custom Filter: 

    ${program_inventory.start_date}<${date_filter.date_filter_end_date} AND (is_null(${program_inventory.end_date}) OR ${program_inventory.end_date}>=${date_filter.date_filter_end_date}) 

      • Dimensions
        • Agencies - Agency Name*
        • Programs - Name* 
    • Secondary Query - Bed Count for Analysis Period (Project Descriptor Model) 
      • Filters
        • Programs - Analysis Period Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to Emergency Shelter, Transitional Housing, Safe Haven
        • Programs - Tracking Method: is null OR is equal to Entry/Exit Date
      • Dimensions
        • Agencies - Agency Name *
        • Programs - Name* 
      • Measure
        • Bed and Unit Inventory - Total Bed Inventory for Analysis Period*
    • Tertiary Query - Total Days in Project During the Reporting Period (HMIS Performance Model) 
      • Filters
        • Enrollments - Reporting Period Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to Emergency Shelter, Transitional Housing, Safe Haven
        • Programs - Tracking Method: is null OR is equal to Entry/Exit Date
      • Dimensions
        • Agencies - Agency Name*
        • Programs - Name*
      • Measure
        • Enrollments - Total Days in Project During the Reporting Period*
    • Merged Results 
      • Merge Rules 
        • Merged by Agencies - Agency Name and Programs - Name for all queries 
      • Added Calculations 
        • Total Days in Project Transformation* (to transform null values to zeros) 
        • Average Utilization Rate 
        • Utilization Rate Per Program*
    • “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. 
        • 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
        • Bed and Unit Inventory - Total Bed Inventory 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”. 

    Capture 2023-01-27 at 9.59.23

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

    This merged 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, Program Name, Continuum Project, and HMIS Participating Project

    • Primary Query - Inventory within Date Filter (Project Descriptor Model) 
      • Filters
        • Filters - Date Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to Emergency Shelter
        • Programs - Tracking Method: is Night-by-Night
        • Custom Filter: 

    ${program_inventory.start_date}<${date_filter.date_filter_end_date} AND (is_null(${program_inventory.end_date}) OR ${program_inventory.end_date}>=${date_filter.date_filter_end_date}) 

      • Dimensions
        • Agencies - Agency Name
        • Programs - Name
    • Secondary Query - Bed Count within Analysis Period (Project Descriptor Model) 
      • Filters
        • Programs - Analysis Period Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to Emergency Shelter
        • Programs - Tracking Method: is Night-by-Night
      • Dimensions
        • Agencies - Agency Name 
        • Programs - Name
      • Measure
        • Bed and Unit Inventory - Total Bed Inventory for Analysis Period
    • Tertiary Query - Night-by-Night Bed Night Count  (HMIS Performance Model) 
      • Filters
        • Enrollments - Reporting Period Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to Emergency Shelter
        • Programs - Tracking Method: is 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}

      • Dimensions
        • Agencies - Agency Name 
        • Programs - Name
      • Measure
        • Service Attendance Dates - Count 
    • Merged Results 
      • Merge Rules
        • Merged by Agencies - Agency Name and Programs - Name for all queries 
      • Added Calculations 
        • Service Attendance Dates Count Transformation* (to transform null values to zeros) 
        • Average Utilization Rate 
        • Utilization Rate Per Program*
    • “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. 
        • Bed and Unit Inventory - Total Bed Inventory 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”. 

    Capture 2023-01-27 at 10.03.51

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

    This merged Look contains a single value visualization containing the average rate of utilization within the Reporting Period for all Permanent Housing programs. 

    Applicable Filters: Reporting Period, CoC, Agency Name, Program Name, Continuum Project, and HMIS Participating Project

    • Primary Query - Inventory within Date Filter (Project Descriptor Model) 
      • Filters
        • Filters - Date Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to PH - Housing Only, PH - Housing with Services (no disability required), PH - Permanent Supportive Housing (disability required), PH - Rapid Re-Housing
        • Custom Filter: 

    ${program_inventory.start_date}<${date_filter.date_filter_end_date} AND (is_null(${program_inventory.end_date}) OR ${program_inventory.end_date}>=${date_filter.date_filter_end_date}) 

      • Dimensions
        • Agencies - Agency Name*
        • Programs - Name* 
    • Secondary Query - Bed Count for Analysis Period (Project Descriptor Model) 
      • Filters
        • Programs - Analysis Period Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to PH - Housing Only, PH - Housing with Services (no disability required), PH - Permanent Supportive Housing (disability required), PH - Rapid Re-Housing
      • Dimensions
        • Agencies - Agency Name *
        • Programs - Name* 
      • Measure
        • Bed and Unit Inventory - Total Bed Inventory for Analysis Period*
    • Tertiary Query - Total Days in Project During the Reporting Period (HMIS Performance Model) 
      • Filters
        • Enrollments - Reporting Period Filter: is in the past 90 complete days 
        • Programs - Project Type Code: is equal to PH - Housing Only, PH - Housing with Services (no disability required), PH - Permanent Supportive Housing (disability required), PH - Rapid Re-Housing
      • Dimensions
        • Agencies - Agency Name*
        • Programs - Name*
      • Measure
        • Enrollments - Total Housed Days in Project During the Reporting Period*
    • Merged Results 
      • Merge Rules 
        • Merged by Agencies - Agency Name and Programs - Name for all queries 
      • Added Calculations 
        • Total Housed Days in Project Transformation* (to transform null values to zeros) 
        • Average Utilization Rate 
        • Utilization Rate Per Program*
    • “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. 
        • 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
        • Bed and Unit Inventory - Total Bed Inventory 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”. 

    Capture 2023-01-30 at 15.16.38

    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, Program Name, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household
    • 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, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household
    • 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

    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, Project Type Code, Continuum Project, HMIS Participating Project, and Chronically Homeless at Project Start -  Household

    • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household
    • 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, Project Type Code, Continuum Project, HMIS Participating Project, and Chronically Homeless at Project Start -  Household
    • 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, Project Type Code, Continuum Project, HMIS Participating Project, and Chronically Homeless at Project Start -  Household
    • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household
    • 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, Project Type Code, Continuum Project, HMIS Participating Project, and Chronically Homeless at Project Start -  Household
    • 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, Project Type Code, Continuum Project, HMIS Participating Project, and Chronically Homeless at Project Start -  Household
    • 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, Project Type Code, Continuum Project, HMIS Participating Project, and Chronically Homeless at Project Start -  Household

    • 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, Project Type Code, Continuum Project, HMIS Participating Project, Veteran Status, and Chronically Homeless at Project Start -  Household

    • 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

     

    Updated: