Dashboard Library
      Back to home
      1. Clarity Human Services Help Center
      2. Data Analysis
      3. Dashboard Library

      Coordinated Entry: Length of Time Overview

      Purpose 

      The Coordinated Entry: Length of Time Overview dashboard includes metrics highlighting the average length of time for various process steps within the typical Coordinated Entry process. This dashboard provides a general Coordinated Entry Enrollments overview for reference and counts, and Length of Time intervals covering high-level CE processes in addition to more granular data for each phase related to CE from enrollment, assessment, referred, and housed/exited dates. 

      CE LoT - 1 CE LoT - 2CE LoT - 3CE LoT - 4

      Dashboard Details 

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

      • “All Folders”  
        • “LookML Dashboards” 
          • “Coordinated Entry: Length of Time Overview 

      Once selected, your dashboard will begin to run. This dashboard utilizes the Client, Coordinated Entry, and HMIS Performance Models for all Looks. 

      Filters 

      The following filters are available for this dashboard:  

      • CE Enrollment CoC 
        • Select the CE Enrollment CoC(s) to include in this dashboard. The filter is built around the Program's Primary Site CoC. 
      • Analysis Period 
        • Select the enrollment reporting period for the Analysis Period.  
        • Default: Last 90 Days  
      • CE Agency Name 
        • Select the CE Agency Name(s) to include in this dashboard.  
      • Project Type 
        • Default: is Coordinated Entry (default and only option)  
      • CE Program Name  
        • Select the CE Program Name(s) to include in this dashboard. 
          • This filter is set to only show Coordinated Entry Programs and is applied to all Looks.  
      • Community Queue Name 
        • Select the Community Queue Name(s) to include in this dashboard. 
      • Assessment Name  
        • Select the Assessment Name(s) to include in this dashboard. 
      • CE Household Type  
        • Select the CE Enrollment Household Type(s) to include in this dashboard. 
      • Veteran Status 
        • Select the Veteran Status(-es) to include in this dashboard.  
      • Chronically Homeless 
        • Select the Chronically Homeless Status(-es) to include in this dashboard. 
      • Race  & Ethnicity
        • Select the Race(s) & Ethnicity(-ies) to include in this dashboard. 
      • Gender 
        • Select the Gender(s) to include in this dashboard. 
      • Referto: Project Type 
        • Select the Referto: Project Type(s) to include in this dashboard. 
      • Referto: Program Name 
        • Select the Referto: Program Name(s) to include in this dashboard. 

      Tile Overview 

      The dashboard contains 18 tiles within 3 sections. The tile overview will contain information about dimensions, measures, custom filters, table calculations, and applicable filters that were utilized to make each Look. Information on how to access drill downs and their content will also be listed below within each subsection.  

      Note: All Looks are filtered to Project Type: Coordinated Entry within the Dashboard Filters.  

      CE Enrollments Overview 

      Clients/Households Enrolled Within the Analysis Period 

      This Look contains a single value visualization with the count of clients and households enrolled within the Analysis Period.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Measures 
        • Clients – Number of Clients 
        • 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. 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 Screen ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date. 
        • The drill down Looks can also be achieved by selecting any count on the dashboard tile. 

      CE LoT - Clients HH Enrolled

      Clients/Households Assessed Within the Analysis Period 

      This Look contains a single value visualization with the count of clients and households assessed within the Analysis Period. Assessments must be connected to an enrollment to be included in this Look.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Only Enrollment Connected Assessments: is Yes 
          • Custom Filter: Assessment Date is within Analysis Period 
            • ${client_assessments.assessment_date}>=${enrollments.reporting_period_start_date} AND ${client_assessments.assessment_date}<${enrollments.reporting_period_end_date} 
      • Measures 
        • Clients – Number of Clients 
        • 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. 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 Screen ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date. 
          • The drill down Looks can also be achieved by selecting any count on the dashboard tile. 

      CE LoT - Clients HH Assessed

      Clients/Households Exited Within the Analysis Period 

      This Look contains a single value visualization with the count of clients and households that exited within the Analysis Period.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Custom Filter: Exit Date is within Analysis Period 
          • ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date} 
      • Measures 
        • Clients – Number of Clients 
        • 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. 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 Screen ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date. 
          • The drill down Looks can also be achieved by selecting any count on the dashboard tile. 

      CE LoT - Client HH Exited

      Project Start Month for Those Enrolled in CE During the Analysis Period  

      This Look contains a column visualization with the count of clients enrolled in CE each month during the analysis period.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Only Enrollment Connected Assessments: is Yes 
          • Custom Filter: Assessment Date is within Analysis Period 
            • ${client_assessments.assessment_date}>=${enrollments.reporting_period_start_date} AND ${client_assessments.assessment_date}<${enrollments.reporting_period_end_date} 
      • Dimensions 
        • Enrollments – Project Start Month 
      • Measures 
        • Clients – Number of Clients 
      • “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. The Client Count drill down contains Screen ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date. 
          • The drill down Look can also be achieved by selecting any count on the dashboard tile. 

      CE LoT - Project Start Month

      Enrolled: HH Type  

      This Look contains a pie visualization with the percent of enrolled household types active in CE within the analysis period.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Dimensions 
        • Enrollments – Household Type  
      • Measures 
        • Entry Screen – Household 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. The Household Count drill down contains Screen ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date 
          • The drill down Look can also be achieved by selecting any radial slice on the dashboard tile. 

      CE LoT - HH Type Pie

      Clients by CE Assessment  

      This Look contains a table visualization with the count of clients by assessment name that were assessed within the analysis period. Assessments must be connected to an enrollment to be included in this Look. 

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Dimensions 
        • Client Assessments – Name  
      • Measures 
        • Clients – Number of Clients  
      • “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. The Client Count drill down contains Screen ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date. 
          • The drill down Look can also be achieved by selecting any count on the dashboard tile. 

      CE LoT - Assessment Name + Counts

      Exited Clients by Destination Category 

      This Look contains a pie visualization with the percent of clients by destination category for those that exited within the Analysis Period.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Custom Filter: Exit Date is within Analysis Period 
          • ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date} 
      • Dimensions 
        • Update/Exit Screen – Destination Category 
      • Measures 
        • Clients – Number of Clients 
      • “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. The Client Count drill down contains Screen ID, Household ID, Personal ID, Unique Identifier Client Full Name, Project Start Date, and Project End Date. 
          • The drill down Looks can also be achieved by selecting any radial slice on the dashboard tile. 

      CE LoT - Exit Pie

      CQ Count Overview 

      This Look contains a multiple value visualization with the count of clients referred to a community queue within the analysis period, the count of clients on a community queue within the analysis period, the count of clients referred to a program from a community queue within the analysis period, and the count of clients that were removed from a community queue within the analysis period.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Deleted (Yes/No): is No 
        • Clients – Deleted (Yes/No): is No 
        • Enrollments – Deleted (Yes/No): is No 
        • Referrals – Deleted (Yes/No): is No 
        • Referrals – Ever on Queue: is Yes  
        • Custom Filter:  
          • ${assessing_program.enrollment_id}=${enrollments.id} AND ( is_null(${referral_settings_community_queues.ref_coc_text})) 
      • Custom Fields 
        • Custom Measures 
          • Clients on a Community Queue Within the Analysis Period 
            • Field to Measure: Clients – Number of Clients  
            • Custom Filter: 
              • (${referrals.date_date}<${enrollments.reporting_period_end_date} AND (${referrals.Currently_On_Queue}="Yes" OR coalesce(${referrals.reassigned_date_date},${referrals.end_date_date})>${enrollments.reporting_period_start_date})) 
          • Clients Referred to a Community Queue Within the Analysis Period 
            • Field to Measure: Clients – Number of Clients  
            • Custom Filter: 
              • (${referrals.date_date}>=${enrollments.reporting_period_start_date} AND ${referrals.date_date}<${enrollments.reporting_period_end_date}) 
          • Clients Referred to a Program from a Community Queue Within the Analysis Period 
            • Field to Measure: Clients – Number of Clients  
            • Custom Filter: 
              • (${referrals.reassigned_date_date}>=${enrollments.reporting_period_start_date} AND ${referrals.reassigned_date_date}<${enrollments.reporting_period_end_date}) 
          • Clients Removed from a Community Queue Within the Analysis Period 
            • Field to Measure: Clients – Number of Clients  
            • Custom Filter: 
              • (${referrals.removed_from_queue_date}>=${enrollments.reporting_period_start_date} AND ${referrals.removed_from_queue_date}<${enrollments.reporting_period_end_date}) 
      • “Explore from Here” 
        • Drill down functionality is not available for custom measures in this Look.  

      CE LoT - CQ Count Overview

      Length of Time Overview 

      Average Days in CE Program 

      This Look contains a single value visualization with the count of clients active within the analysis period and the average days spent in CE programs.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Measures 
        • Clients – Number of Clients 
        • Enrollments – Average Days in Project  
      • “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.  
            • 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 any count on the dashboard tile. 

      CE LoT - Average Days in CE Program

      CE LoT: Stayers vs. Leavers 

      This Look contains a multiple value visualization with the average length of time (days) in CE programs and the count of clients for stayers and leavers. Stayers are defined as clients that are still actively enrolled within the analysis period and leavers who have exited the CE program within the analysis period.   

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Custom Fields  
        • Custom Measures 
          • Average Days in CE Program – Stayers 
            • Field to Measures: Enrollments – Average Days in Project  
            • Custom Filter:  
              • is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date}) 
          • Stayers 
            • Field to Measure: Clients – Number of Clients 
            • Custom Filter:  
              • is_null(${enrollments.end_date}) OR (${enrollments.end_date}>=${enrollments.reporting_period_end_date}) 
          • Average Days in CE Program – Leavers 
            • Field to Measures: Enrollments – Average Days in Project  
            • Custom Filter:  
              • ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date} 
          • Leavers 
            • Field to Measure: Clients – Number of Clients 
            • Custom Filter:  
              • ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date} 
      • “Explore from Here” 
        • Drill down functionality is not available for custom measures in this Look. 

      CE LoT - Stayers v Leavers

      LoT: Project Start to Referred to Queue  

      This Look contains a multiple value visualization with the average length of time (days) from the CE project start date to the first referral to a community queue, an unduplicated client count, and an unduplicated referral count. 

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Referrals – Ever on Queue: is equal to Yes 
        • Referrals – Is First Referral per Client (Filter Dependent): is equal to Yes 
        • Custom Filter:  
          • ${referrals.date_date}>=${enrollments.start_date} AND ${referrals.added_date}=${referrals.date_date} AND  ${assessing_program.enrollment_id}=${enrollments.id} 
      • Custom Fields 
        • Custom Dimensions 
          • LoT: Project Start Date to Referral to Queue Date 
            • Expression: 
              • diff_days(${enrollments.start_date},${referrals.added_date}) 
        • Table Calculations 
          • Average LoT 
            • Custom Expression:  
              • sum(${lot_value_number_of_referrals})/${total_referral_count} 
          • Client Count 
            • Custom Expression:  
              • sum(${client.count}) 
          • LoT Value * Number of Referrals  
            • Custom Expression:  
              • (${lot_project_start_date_to_referral_to_queue_date}*${referrals.count}) 
          • Total Referral Count 
            • Custom Expression:  
              • ${referrals.count:total} 
      • Measures 
        • Clients – Number of Clients 
        • Referrals – Count  
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or referrals 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.  
          • Referrals Count: Drill down contains Personal ID, Referral ID, and Referral Method.  
        • Drill down functionality is not available from the dashboard tile.  

      CE LoT- Project Start to First Referral

      LoT: Program Referral to Referral Connected Housing Move-in Date/Exit Date  

      This Look contains a multiple value visualization with the average length of time (days) from program referral (reassigned date) to referral connected housing move-in date(HMiD) OR if HMiD is null – referral connected exit date, an unduplicated client count, and an unduplicated referral count. 

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, Gender, Referto: Project Type, and Referto: Program Name 

      • Filters 
        • Referrals – Ever on Queue: is equal to Yes 
        • LoT: Program Referral Date to Referral Connected Housing Move-in/Exit: is greater than 0 
        • Custom Filter:  
          • ${enrollments.id}=${assessing_program.enrollment_id} AND if(is_null(${referral_connection_enrollment_household_move_in_dates.move_in_date_date}),${referral_connections_enrollment.end_date}>=${enrollments.start_date},${referral_connection_enrollment_household_move_in_dates.move_in_date_date}>=${enrollments.start_date}) 
      • Custom Fields 
        • Custom Dimensions 
          • LoT: Program Referral Date to Referral Connected Housing Move-in/Exit 
            • Expression: 
              • diff_days(${referrals.reassigned_date_date}, ((if(is_null(${referral_connection_enrollment_household_move_in_dates.move_in_date_date}),${referral_connections_enrollment.end_date},${referral_connection_enrollment_household_move_in_dates.move_in_date_date})))) 
        • Table Calculations 
          • Average LoT 
            • Custom Expression:  
              • sum(${lot_value_number_of_referrals})/${referral_count} 
          • Client Count 
            • Custom Expression:  
              • ${client.count:total} 
          • LoT Value * Number of Referrals  
            • Custom Expression:  
              • (${lot_program_referral_date_to_referral_connected_housing_move_inexit}*${referrals.count} 
          • Referral Count 
            • Custom Expression:  
              • ${referrals.count:total} 
      • Measures 
        • Clients – Number of Clients 
        • Referrals – Count  
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or referrals 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.  
          • Referrals Count: Drill down contains Personal ID, Referral ID, and Referral Method.  
        • Drill down functionality is not available from the dashboard tile. 

      CE LoT-Prog Ref to HMiD or Exit

      CE Process Review 

      CE Project Start Date to First CE Assessment Date 

      This Look contains a single value visualization with the average length of time (days) from the CE project start to the first CE assessment date and the unduplicated count of assessed clients.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Only Enrollment Connected Assessments: is Yes 
        • Client Assessments – Is Coordinated Entry: is equal to Yes  
        • Client Assessments – Is First Assessment per Client (Filter Dependent): is equal to Yes 
        • Custom Filter:  
          • ${client_assessments.assessment_date}>=${enrollments.start_date} AND ${assessing_program.enrollment_id}=${enrollments.id} 
      • Custom Fields  
        • Custom Dimensions 
          • LoT: Project Start Date to Assessment Date 
            • Expression:  
              • diff_days(${enrollments.start_date},${client_assessments.assessment_date}) 
        • Table Calculations 
          • Assessed Client Count  
            • Custom Expression:  
              • ${clients.count:total} 
          • Average LoT: CE Project Start Date to First CE Assessment Date  
            • Custom Expression:  
              • sum(${lot_value_number_of_assessments})/${client_assessments.count:total} 
          • LoT Value * Number of Assessments  
            • Custom Expression:  
              • ${lot_project_start_date_to_assessment_date}*${client_assessments.count} 
      • Measures 
        • Client Assessments – Count  
        • Clients – Number of Clients 
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or assessments 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.  
          • Assessments Count: Drill down contains Personal ID, Unique Identifier, Assessing Agency Name, Assessing Program, Assessment ID, and Assessment Score.  
        • Drill down functionality is not available from the dashboard tile. 

      CE LoT - CE Project Start to CE Assessment

      Assessment Date to Referred to Queue  

      This Look contains a multiple value visualization with the average length of time (days) from the CE assessment date to the first referral to a queue, an unduplicated count of clients, and an unduplicated count of referrals sent to a queue.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Is Coordinated Entry: is equal to Yes  
        • Referrals – Ever on Queue: is equal to Yes 
        • Client Assessments – Is First Referral per Client (Filter Dependent): is equal to Yes 
        • Custom Filter:  
          • ${referrals.date_date}>=${enrollments.start_date} AND ${referrals.added_date}=${referrals.date_date} AND ${assessing_program.enrollment_id}=${enrollments.id} 
      • Custom Fields  
        • Custom Dimensions 
          • LoT: Assessment Date to Referral to Queue Date 
            • Expression:  
              • if(diff_days(${referral_first_assessments.assessment_date},${referrals.date_date})>=0,diff_days(${referral_first_assessments.assessment_date},${referrals.date_date}),null) 
        • Table Calculations 
          • Average LoT: Assessment Date to Referral to Queue Date 
            • Custom Expression:  
              • sum(${lot_value_number_of_referrals})/${referrals.count:total} 
          • LoT Value * Number of Referrals 
            • Custom Expression:  
              • ${lot_assessment_date_to_referral_to_queue_date}*${referrals.count} 
          • Total Referral Count 
            • Custom Expression:  
              • ${referrals.count:total} 
          • Unduplicated Client Count  
            • Custom Expression:  
              • ${client.count:total} 
      • Measures 
        • Client Assessments – Count  
        • Clients – Number of Clients 
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or referrals 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.  
          • Referrals Count: Drill down contains Personal ID, Referral ID, and Referral Method.  
        • Drill down functionality is not available from the dashboard tile. 

      CE LoT - Assessment Date to Referred to Queue

      Referred to Queue to Program Referral  

      This Look contains a multiple value visualization with the average length of time (days) from referral added to a queue to program referral (reassigned date), an unduplicated count of clients referred, and a count of program referrals. 

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, Gender, Referto: Project Type, and Referto: Program Name 

      • Filters 
        • Referrals – Ever on Queue: is equal to Yes 
        • Custom Filter:  
          • ${referrals.reassigned_date_date}>=${enrollments.start_date} AND  ${assessing_program.enrollment_id}=${enrollments.id} 
      • Custom Fields 
        • Custom Dimensions 
          • LoT: Referral to Queue Date to Program Referral Date  
            • Expression:  
              • diff_days(${referrals.date_date},${referrals.reassigned_date_date}) 
        • Table Calculations 
          • Average LoT Per Referral  
            • Custom Expression:  
              •  sum(${lot_value_number_of_referrals})/${referrals.count:total} 
          • LoT Value * Number of Referrals   
            • Custom Expression: 
              • ${lot_referral_to_queue_date_to_program_referral_date}*${referrals.count} 
          • Referral Count 
            • Custom Expression: 
              • ${referrals.count:total} 
          • Unduplicated Clients 
            • Custom Expression: 
              • ${client.count:total} 
      • Measures 
        • Clients – Number of Clients 
        • Entry Screen – Count Households 
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or referrals 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.  
          • Referrals Count: Drill down contains Personal ID, Referral ID, and Referral Method.  
        • Drill down functionality is not available from the dashboard tile. 

      CE LoT - Referral to Queue to Program Referral Reassigned date

      Reassigned Date to Referral Connected Enrollment Start Date  

      This Look contains a multiple value visualization with the average length of time (days) from program referral (reassigned date) to the referral-connected enrollment start date, an unduplicated count of clients referred, and a count of referral-connected enrollments. 

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, Gender, Referto: Project Type, and Referto: Program Name 

      • Filters 
        • Client Assessments – Is Coordinated Entry: is equal to Yes  
        • Referrals – Ever on Queue: is equal to Yes  
        • Custom Filter:  
          • ${assessing_program.enrollment_id}=${enrollments.id} AND ${referrals.date_accepted_in_program_date}>=${enrollments.start_date} 
      • Custom Fields 
        • Custom Dimensions 
          • LoT: Program Referral Date to Referral Connected Project Start Date 
            • Expression: 
              • diff_days(${referrals.reassigned_date_date},${referrals.date_accepted_in_program_date}) 
        • Table Calculations  
          • Average LoT 
            • Custom Expression:  
              • sum(${lot_value_number_of_referrals})/${referral_count} 
          • LoT Value * Number of Referrals 
            • Custom Expression: 
              • if(${lot_program_referral_date_to_referral_connected_project_start_date}<0,0,${lot_program_referral_date_to_referral_connected_project_start_date}*${referrals.count}) 
          • Referral Count 
            • Custom Expression: 
              • ${referrals.count:total} 
          • Unduplicated Client Count 
            • Custom Expression: 
              • ${client.count:total} 
      • Measures 
        • Clients – Number of Clients 
        • Referrals – Count 
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or referrals 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.  
          • Referrals Count: Drill down contains Personal ID, Referral ID, and Referral Method.  
        • Drill down functionality is not available from the dashboard tile.  

      CE LoT - Program referral to referral connected enrollment

      Referral Connected Enrollment Start Date to Housing Move-in Date 

      This Look contains a multiple value visualization with the average length of time (days) from the referral-connected enrollment start date to the referral-connected enrollment housing move-in date, an unduplicated count of clients, and a count of referral-connected enrollment housing move-in dates. 

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, Gender, Referto: Project Type, and Referto: Program Name 

      • Filters 
        • Client Assessments – Referred Assessments: is Referred Assessments 
        • Client Assessments – Deleted (Yes/No): is No 
        • Clients – Deleted (Yes/No): is No 
        • Referral Connected Enrollments – Deleted (Yes/No): is No 
        • Referrals – Deleted (Yes/No): is No 
        • Custom Filter:  
          • ${referral_connection_enrollment_household_move_in_dates.move_in_date_date}>=${enrollments.start_date} AND ${assessing_program.enrollment_id}=${enrollments.id} 
      • Custom Fields 
        • Custom Dimensions 
          • LoT: Referral Connected Project Start Date to Housing Move-in Date 
            • Expression: 
              • diff_days(${referral_connections_enrollment.start_date}, ${referral_connection_enrollment_household_move_in_dates.move_in_date_date}) 
        • Table Calculations  
          • Average LoT 
            • Custom Expression:  
              • sum(${lot_value_number_of_referrals})/${referral_count} 
          • LoT Value * Number of Referrals 
            • Custom Expression: 
              • ${lot_referral_connected_project_start_date_to_housing_move_in_date}*${referrals.count} 
          • Referral Count 
            • Custom Expression: 
              • ${referrals.count:total} 
          • Client Count 
            • Custom Expression: 
              • ${client.count:total} 
      • Measures 
        • Clients – Number of Clients 
        • Referrals – Count  
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or referrals 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.  
          • Referrals Count: Drill down contains Personal ID, Referral ID, and Referral Method.  
        • Drill down functionality is not available from the dashboard tile. 

      CE LoT- RC Enrollment Start Date to HMiD

      Referral Connected Enrollment Start Date to Exit (null HMiD) 

      This Look contains a multiple value visualization with the average length of time (days) from the referral-connected enrollment start date to the referral-connected exit date when the housing move-in date is null, an unduplicated count of clients, and a count of referral-connected enrollment exits without housing move-in dates.  

      Applicable Filters: CE Enrollment CoC, Analysis Period, CE Agency Name, Project Type, CE Program Name, Community Queue Name, Assessment Name, Household Type, Veteran Status, Chronic, Race & Ethnicity, Gender, Referto: Project Type, and Referto: Program Name 

      • Filters 
        • Client Assessments – Referred Assessments: is Referred Assessments 
        • Client Assessments – Deleted (Yes/No): is No 
        • Clients – Deleted (Yes/No): is No 
        • Referral Connected Enrollments – Deleted (Yes/No): is No 
        • Referral Connected Enrollments – Housing Move-in Date: is null 
        • Referrals – Deleted (Yes/No): is No 
        • Custom Filter:  
          • ${referral_connections_enrollment.end_date}>=${enrollments.start_date} AND ${assessing_program.enrollment_id}=${enrollments.id} 
      • Custom Fields 
        • Custom Dimensions 
          • LoT: Referral Connected Project Start Date to Exit Date (null HMiD) 
            • Expression: 
              • diff_days(${referral_connections_enrollment.start_date}, ${referral_connections_enrollment.end_date}) 
        • Table Calculations  
          • Average LoT 
            • Custom Expression:  
              • sum(${lot_value_number_of_referrals})/${referral_count} 
          • LoT Value * Number of Referrals 
            • Custom Expression: 
              • ${lot_referral_connected_project_start_date_to_housing_move_in_date}*${referrals.count} 
          • Referral Count 
            • Custom Expression: 
              • ${referrals.count:total} 
          • Client Count 
            • Custom Expression: 
              • ${client.count:total} 
      • Measures 
        • Clients – Number of Clients 
        • Referrals – Count  
      • “Explore from Here” 
        • Select “Explore from Here”, then click on the number of clients or referrals 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.  
          • Referrals Count: Drill down contains Personal ID, Referral ID, and Referral Method.  
        • Drill down functionality is not available from the dashboard tile. 

      CE LoT - Referral Connect Start Date to Exit Date null HMID

       

      Updated: 10/1/2023