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

      Coordinated Entry: Enrollment Overview

      Purpose 

      The Coordinated Entry: Enrollment Overview dashboard includes historic enrollment information for Coordinated Entry (CE) enrollments within the analysis period. This dashboard highlights general client counts, assessment details, demographics, and special population statistics, Coordinated Entry Elements review showcasing elements 4.19 Coordinated Entry Assessment and 4.20 Coordinated Entry Event, and an enrollment comparison with year-to-date (YTD) enrollments and related counts for the prior 2 years (mimicking YTD and the total annual enrollment counts).  

      Enrollments 1Enrollments 2

      Enrollments 3Enrollments 4Enrollments 5

      CEDemographics

      Enrollments 8Enrollments 9

      Dashboard Details 

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

      • “All Folders”  
        • “LookML Dashboards” 
          • “Coordinated Entry: Enrollment Overview 

      Once selected, your dashboard will begin to run. This dashboard utilizes the Coordinated Entry Model, Client Model, HMIS Performance, and Population over Time models.  

      Filters 

      The following filters are available for this dashboard:  

      • CoC Code 
        • Select the CE Enrollment CoC(s) to include in this dashboard.  
        • Based on the Primary Site CoC
      • Analysis Period 
        • Select the desired date range for the Analysis Period.  
        • Default: Last 365 Days  
      • Agency Name 
        • Select the Agency Name(s) to include in this dashboard.  
      • Project Type (November 2022 Release)  
        • 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. (November 2022 Release)  
      • Active in Project 
        • Select Yes/No. Active in Project highlights real-time client status and is not impacted by the Analysis Period filter.  
      • Assessment Name  
        • Select the Assessment Name(s) to include in this dashboard. 
      • Household Type  
        • Select the 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) to include in this dashboard. 
      • Gender 
        • Select the Gender(s) to include in this dashboard. 
      • Community Queue Name* 
        • Select the Community Queue Name(s) to include in this dashboard. 

      Tile Overview 

      The dashboard contains 25 tiles within 5 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 drilldowns and their content will also be listed below within each subsection.  

      Note: All Looks are filtered to Project Type: Coordinated Entry.  

      Client Counts 

      Client/Enrollment Counts 

      This Look contains a single value visualization with the count of clients and enrollments active at any point within the Analysis Period.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Programs – Project Type Code: is Coordinated Entry  
      • Measures 
        • Clients – Number of Clients 
        • 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.  
          • 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. 

      Clients Entered During Analysis Period 

      This Look contains a single value visualization with the count of clients and enrollments enrolled at any point within the Analysis Period.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Programs – Project Type Code: is Coordinated Entry  
        • Custom Filter:  
          • ${enrollments.start_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.start_date}<${enrollments.reporting_period_end_date} 
      • Measures 
        • Clients – Number of Clients 
        • 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.  
          • 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. 

      Clients Exited During Analysis Period 

      This Look contains a single value visualization with the count of clients and enrollments exited at any point within the Analysis Period.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Programs – Project Type Code: is Coordinated Entry  
        • Custom Filter:  
          • ${enrollments.end_date}>=${enrollments.reporting_period_start_date} AND ${enrollments.end_date}<${enrollments.reporting_period_end_date} 
      • Measures 
        • Clients – Number of Clients 
        • 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.  
          • 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. 

      Monthly CE Entry/Exit 

      This Look contains a column visualization with the count of clients entering and exiting CE programs. This Look is limited to the past 13 complete months regardless of the selected analysis period.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Population – Report Range: is in the past 13 complete months 
        • Programs – Project Type Code: is Coordinated Entry 
      • Custom Fields 
        • Custom Measures 
          • Clients Entering 
            • Field to Measure: Enrollments – Counts  
            • 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 
            • Field to Measure: Enrollments – Counts  
            • 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 
        • Population – Observation Month  
      • “Explore from Here” 
        • Drill down functionality is not available for custom measures in this Look. 

      Sub-Populations: Adult, Family, & TAY Counts 

      This Look contains a column visualization with the count of clients and households enrolled within the Analysis Period for three different sub-populations. The sub-populations are not mutually exclusive and are defined below.  

      • Adults w/o Children: Client/Enrollment Households count with no children and at least one adult 
      • Families: Client/Enrollment Households count with at least one adult and one child 
      • TAY: Client/Enrollment Households count with no household members over the age of 24 

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Enrollments – Enrollment Household: is HUD Age 
        • Programs – Project Type Code: is Coordinated Entry 
      • Custom Fields 
        • Custom Measures 
          • Adults w/o Children - Clients Count 
            • Field to Measure: Clients – Number of Clients  
            • Custom Filter:  
              • ${household_makeup.oldest}>24 AND ${household_makeup.youngest}>=18 
          • Adults w/o Children - Households Count 
            • Field to Measure: Entry Screen – Count Households 
            • Custom Filter:  
              • ${household_makeup.oldest}>24 AND ${household_makeup.youngest}>=18 
          • Families - Clients Count 
            • Field to Measure: Clients – Number of Clients  
            • Custom Filter:  
              • ${household_makeup.oldest}>24 AND ${household_makeup.youngest}<18 
          • Families - Households Count 
            • Field to Measure: Entry Screen – Count Households 
            • Custom Filter:  
              • ${household_makeup.oldest}>24 AND ${household_makeup.youngest}<18 
          • TAY - Clients Count 
            • Field to Measure: Clients – Number of Clients  
            • Custom Filter:  
              • ${household_makeup.oldest}<=24 
          • TAY - Households Count 
            • Field to Measure: Entry Screen – Count Households  
            • Custom Filter:  
              • ${household_makeup.oldest}<=24 
      • “Explore from Here” 
        • Drill down functionality is not available for custom measures in this Look. 

      Assessment Review 

      Assessment Counts 

      This Look contains a multiple value visualization with the count of completed assessments within the Analysis Period. Assessments must be connected to an enrollment to be included in the assessment counts.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Only Enrollment Connected Assessments: is Yes 
        • Programs – Project Type Code: is Coordinated Entry 
        • Custom Filter:  
          • ${client_assessments.assessment_date}>=${enrollments.reporting_period_start_date}AND${client_assessments.assessment_date}<${enrollments.reporting_period_end_date} AND (${enrollments.id}=${assessing_program.enrollment_id}) 
      • Custom Fields 
        • Custom Measures 
          • CE Assessments 
            • Field to Measure: Client Assessments - Count 
            • Custom Filter:  
              • ${screens.is_coordinated_entry}="Yes"
          • Non-CE Assessments 
            • Field to Measure: Client Assessments - Count 
            • Custom Filter:  
              • ${screens.is_coordinated_entry}="No" 
      • Measures 
        • Client Assessments - Count 
      • “Explore from Here” 
        • There are two ways to explore this Look to obtain more information. The only drill down available in this Look is the Total Assessments count.  
          • Select “Explore from Here”, then click on the Client Assessments - Count in the data section for a drill down. The drill down contains Personal ID, Unique Identifier, Assessing Agency Name, Assessing Program, Assessment ID, and Assessment Score.  
          • The drill down Look can also be achieved by selecting the "Total Assessments” count on the dashboard tile. 

      Assessment Scores 

      This Look contains a table visualization with an overview of average, minimum, and maximum assessment scores by assessment names. Assessments pulled into this section were completed 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 
        • Client Assessments – Deleted (Yes/No): is No 
        • Client Assessments – Is Coordinated Entry: is equal to Yes 
        • Clients – Deleted (Yes/No): is No  
        • Enrollments – Deleted (Yes/No): is No 
        • Programs – Project Type Code: is Coordinated Entry 
        • Custom Filter:  
          • ${enrollments.id}=${assessing_program.enrollment_id} AND ${client_assessments.assessment_date}>=${enrollments.reporting_period_start_date} AND ${client_assessments.assessment_date}<${enrollments.reporting_period_end_date} 
      • Custom Fields 
        • Custom Measures 
          • Average of Assessment Score 
            • Field to Measure: Client Assessments – Assessment Score 
            • Measure Type: Average 
          • Min of Assessment Score 
            • Field to Measure: Client Assessments – Assessment Score 
            • Measure Type: Min 
          • Max of Assessment Score 
            • Field to Measure: Client Assessments – Assessment Score 
            • Measure Type: Max 
      • Measures 
        • Client Assessments – Name 
        • Client Assessments – Count  
      • “Explore from Here” 
        • Drill down functionality is not available for custom measures in this Look. 
        • Client Assessments – Count does have drill down functionality. 
          • Select “Explore from Here”, then click on the Client Assessments - Count in the data section for a drill down. The drill down contains Personal ID, Unique Identifier, Assessing Agency Name, Assessing Program, Assessment ID, and Assessment Score.

      Community Queue Review 

      This Look contains a table visualization with the count of clients and assessments linked to the client’s referral that was on a Community Queue within the Analysis Period by Community Queue Name.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, Gender, and Community Queue Name 

      • Filters 
        • Client Assessments – Deleted (Yes/No): is No 
        • Client Assessments – Is Coordinated Entry: is equal to Yes 
        • Clients – Deleted (Yes/No): is No  
        • Enrollments – Deleted (Yes/No): is No 
        • Programs – Project Type Code: is Coordinated Entry 
        • Referrals – Deleted (Yes/No): is No  
        • Referrals – Ever on Queue: is equal to Yes 
        • 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})) AND ${assessing_program.enrollment_id}=${enrollments.id} AND is_null(${referral_settings_community_queues.ref_coc_text}) 
      • Custom Fields 
        • Custom Measures 
          • CE Assessments Ever on the Queue  
            • Field to Measure: Client Assessments – Count 
            • Filters:  
              • Ever on Queue: is Yes 
              • Is Coordinated Entry: is Yes 
          • Non-CE Assessments Ever on the Queue 
            • Field to Measure: Client Assessments – Count 
            • Filters:  
              • Ever on Queue: is Yes 
              • Is Coordinated Entry: is No 
      • Dimensions  
        • Referrals – Referral Community Queues – CoC 
        • Referrals – Referral Community Queues – 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 client count in the data section for a drill down. The 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 client count on the dashboard tile. 

      On a CQ: Assessment Scores 

      Similar to the previous Assessment Scores tile, this Look contains assessment score information. However, to be included in this dataset, a client must have been on a Community Queue within the Analysis Period.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, Gender, and Community Queue Name 

      • Filters 
        • Client Assessments – Deleted (Yes/No): is No 
        • Client Assessments – Is Coordinated Entry: is equal to Yes 
        • Clients – Deleted (Yes/No): is No  
        • Enrollments – Deleted (Yes/No): is No 
        • Programs – Project Type Code: is Coordinated Entry 
        • Referrals – Deleted (Yes/No): is No  
        • Referrals – Ever on Queue: is equal to Yes  
        • 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})) AND ${assessing_program.enrollment_id}=${enrollments.id} AND (is_null(${referral_settings_community_queues.ref_coc_text})) 
      • Custom Fields 
        • Custom Measures 
          • Average of Assessment Score 
            • Field to Measure: Client Assessments – Assessment Score 
            • Measure Type: Average 
          • Min of Assessment Score 
            • Field to Measure: Client Assessments – Assessment Score 
            • Measure Type: Min 
          • Max of Assessment Score 
            • Field to Measure: Client Assessments – Assessment Score 
            • Measure Type: Max 
      • Measures 
        • Client Assessments – Name 
        • Client Assessments – Count  
      • “Explore from Here” 
        • Drill down functionality is not available for custom measures in this Look. 
        • Client Assessments – Count does have drill down functionality. 
          • Select “Explore from Here”, then click on the Client Assessments - Count in the data section for a drill down. The drill down contains Personal ID, Unique Identifier, Assessing Agency Name, Assessing Program, Assessment ID, and Assessment Score. 

      On a CQ: Assessments 

      This Look contains a grouped bar visualization with the unduplicated count of clients and the count of completed CE assessments for those on a Community Queue within the Analysis Period by Assessment Name.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, Gender, and Community Queue Name 

      • Filters 
        • Client Assessments – Deleted (Yes/No): is No 
        • Client Assessments – Is Coordinated Entry: is equal to Yes 
        • Clients – Deleted (Yes/No): is No  
        • Enrollments – Deleted (Yes/No): is No 
        • Programs – Project Type Code: is Coordinated Entry 
        • Referrals – Deleted (Yes/No): is No  
        • Referrals – Ever on Queue: is equal to Yes  
        • 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})) AND ${assessing_program.enrollment_id}=${enrollments.id} AND (is_null(${referral_settings_community_queues.ref_coc_text})) 
      • Custom Fields 
        • Custom Measure  
          • CE Assessments Ever on the Queue  
          • Field to Measure: Client Assessments – Count 
          • Filters:  
            • Ever on Queue: is Yes 
            • Is Coordinated Entry: is Yes 
      • 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 client count in the data section for a drill down. The 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 client count on the dashboard tile. 

      Demographics/Special Populations  

      Household Type 

      This Look contains a column visualization with an enrollment household overview containing the count of clients and percent of total active within the Analysis Period.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Programs – Project Type Code: is Coordinated Entry 
      • Custom Fields 
        • Table Calculations 
          • Percent of Total 
            • Custom Expression:  
              • ${clients.count}/${clients.count:total}
      • Dimensions 
        • Entry Screen – Enrollment Household Type 
      • 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 client count in the data section for a drill down. The 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 client count on the dashboard tile. 

      Household Size 

      This Look contains a table visualization with the count of households by household size enrolled within the Analysis Period.  Household Size is determined by the latest CE enrollment within the Analysis Period. 

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Enrollments – Is Last enrollment per Client (Filter Dependent): is equal to Yes 
        • Programs – Project Type Code: is equal to Coordinated Entry  
      • Custom Fields 
        • Custom Dimensions 
          • HH Size Sort 
            • Expression:   
              • case(when(${household_size}="1",1), 

                when(${household_size}="2",2), 

                when(${household_size}="3",3), 

                when(${household_size}="4",4), 

                when(${household_size}="5+",5),null) 
          • Household Size 
            • Expression:   
              • case(when(${household_makeup.count_adults}+${household_makeup.count_children}=1,"1"), 
                when(${household_makeup.count_adults}+${household_makeup.count_children}=2,"2"),
                when(${household_makeup.count_adults}+${household_makeup.count_children}=3,"3"),
                when(${household_makeup.count_adults}+${household_makeup.count_children}=4,"4"),
                when(${household_makeup.count_adults}+${household_makeup.count_children}>=5,"5+"),
                null)
      • Measures 
        • 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 household count in the data section for a drill down. The 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 household count on the dashboard tile. 

      Age Tiers 

      This Look contains a column visualization with an age tiers overview containing the count of clients and percent of total active within the Analysis Period. Age Tiers are determined by the latest CE enrollment 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 
        • Enrollments – Is Last enrollment per Client (Filter Dependent): is equal to Yes 
        • Entry Screen – Age Tier: is not Below 0  
        • Programs – Project Type Code: is equal to Coordinated Entry  
      • Custom Fields 
        • Table Calculations 
          • Percent of Total 
            • Custom Expression:  
              • ${clients.count}/${clients.count:total} 
      • Dimensions 
        • Entry Screen – Age Tiers 
      • 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 client count in the data section for a drill down. The 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 client count on the dashboard tile. 

      Gender 

      This Look contains a column visualization with a gender overview containing the count of clients and percent of total active 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 
        • Programs – Project Type Code: is equal to Coordinated Entry  
      • Custom Fields 
        • Table Calculations 
          • Percent of Total 
            • Custom Expression:  
              • ${clients.count}/${clients.count:total} 
      • Dimensions 
        • Clients – Gender  
      • 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 client count in the data section for a drill down. The 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 client count on the dashboard tile. 

      Race & Ethnicity

      This Look contains a column visualization with a race and ethnicity overview containing the count of clients and percent of total active 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 
        • Programs – Project Type Code: is equal to Coordinated Entry  
      • Custom Fields 
        • Table Calculations 
          • Percent of Total 
            • Custom Expression:  
              • ${clients.count}/${clients.count:total} 
      • Dimensions 
        • Clients – Race & Ethnicity
      • 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 client count in the data section for a drill down. The 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 client count on the dashboard tile. 

      Chronically Homeless at Project Start  

      This Look contains a pie visualization with the count of clients and percent of clients enrolled within the Analysis Period by Chronically Homeless at Project Start (Yes/No).  

      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 
        • Programs – Project Type Code: is equal to Coordinated Entry 
      • Dimensions 
        • Entry Screen – Chronically Homeless at Project Start – Individual  
      • 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 Personal ID, Unique Identifier, Client Full Name, and Current Age. 
          • The drill down Look can also be achieved by selecting any radial slice on the dashboard tile. 

      Veteran Status 

      This Look contains a pie visualization with the count of clients and percent of clients enrolled within the Analysis Period by Veteran Status.  

      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 
        • Programs – Project Type Code: is equal to Coordinated Entry 
      • Dimensions 
        • Clients – Veteran Status 
      • 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 Personal ID, Unique Identifier, Client Full Name, and Current Age. 
          • The drill down Look can also be achieved by selecting any radial slice on the dashboard tile. 

      Disabling Condition at Project Start 

      This Look contains a pie visualization with the count of clients and percent of clients enrolled within the Analysis Period by Entry Screen – Disabling Condition (Yes/No).  

      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 
        • Programs – Project Type Code: is equal to Coordinated Entry 
      • Dimensions 
        • Entry Screen – Disabling Condition 
      • 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 Personal ID, Unique Identifier, Client Full Name, and Current Age. 
          • The drill down Look can also be achieved by selecting any radial slice on the dashboard tile. 

      Coordinated Entry Elements  

      4.19 Coordinated Entry Assessment Level 

      This Look contains a table visualization with the count of completed assessments within the Analysis Period by Assessment Level and Location.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Programs – Project Type Code: is Coordinated Entry 
        • Custom Filter:  
          • ${enrollments.id}=${assessing_program.enrollment_id} AND ${client_assessments.assessment_date}<${enrollments.reporting_period_end_date} AND ${client_assessments.assessment_date}>=${enrollments.reporting_period_start_date} 
      • Dimensions 
        • Client Assessments – Coordinated Entry – Assessment Level 
        • Client Assessments – Coordinated Entry – Assessment Location 
      • Measures 
        • Client Assessments - 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 Assessment Count drill downs contain Personal ID, Unique Identifier, Assessing Agency Name, Assessing Program, Assessment ID, and Assessment Score. 
          • The drill down Looks can also be achieved by selecting any count on the dashboard tile. 

      4.19 Coordinated Entry Assessment Type 

      This Look contains a pie visualization with the count of completed assessments within the Analysis Period by Assessment Type. 

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Deleted (Yes/No): is No  
        • Clients – Deleted (Yes/No): is No  
        • Enrollments – Deleted (Yes/No): is No  
        • Programs – Project Type Code: is Coordinated Entry 
        • Custom Filter:  
          • ${enrollments.id}=${assessing_program.enrollment_id} AND ${client_assessments.assessment_date}<${enrollments.reporting_period_end_date} AND ${client_assessments.assessment_date}>=${enrollments.reporting_period_start_date} 
      • Dimensions 
        • Client Assessments – Coordinated Entry – Assessment Type 
      • Measures 
        • Client Assessments - 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 Assessment Count drill downs contain Personal ID, Unique Identifier, Assessing Agency Name, Assessing Program, Assessment ID, and Assessment Score. 
          • The drill down Look can also be achieved by selecting any radial slice on the dashboard tile. 

      4.20 Coordinated Entry Events - Count 

      This Look contains a bar visualization with the count of Coordinated Entry Events for clients assessed within the Analysis Period.  

      Applicable Filters: CoC Code, Analysis Period, Agency Name, Program Name, Active in Project, Assessment Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Client Assessments – Deleted (Yes/No): is No  
        • Clients – Deleted (Yes/No): is No  
        • Enrollments – Deleted (Yes/No): is No  
        • Programs – Project Type Code: is Coordinated Entry 
        • Custom Filter:  
          • ${enrollments.id}=${assessing_program.enrollment_id} AND ${client_assessments.assessment_date}<${enrollments.reporting_period_end_date} AND ${client_assessments.assessment_date}>=${enrollments.reporting_period_start_date}  
      • Dimensions 
        • Coordinated Entry Event – Event  
        • Coordinated Entry Event – Event Group 
      • Measures 
        • Coordinated Entry Event – 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 Coordinated Entry Event Count drill downs contain Personal ID, Coordinated Entry Event, and Event Date. 
          • The drill down Looks can also be achieved by selecting any count on the dashboard tile. 

      Enrollment Comparisons 

      Current Year - YTD CE Client/Enrollment Counts 

      This Look contains a single value visualization with the count of clients and enrollments for the current year (year to date).  

      Applicable Filters: CoC Code, Agency Name, Program Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Enrollments – Reporting Period Filter: is in the past 1 years  
      • Measures 
        • Clients – Number of Clients 
        • 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.  
          • 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. 

      1 Year Prior – CE Client/Enrollment Counts 

      This Look contains a multiple value visualization with the count of clients and enrollments for last year. The count of clients and enrollments are broken down into two groups – total clients/enrollments for the year prior and count of clients/enrollments until the current date the dashboard is ran for the year prior. 

      Applicable Filters: CoC Code, Agency Name, Program Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Enrollments – Reporting Period Filter: is in the past 1 complete years  
        • Programs – Project Type Code: is Coordinated Entry  
      • Custom Fields 
        • Custom Measures 
          • Clients Served by Today's Date Last Year 
            • Field to Measure: Clients – Number of Clients 
            • Custom Filter: 
              • (${enrollments.end_date}>=add_years(-1,trunc_years(now())) OR is_null(${enrollments.end_date})) AND ${enrollments.start_date}<=add_years(-1,now()) 
          • Enrollments by Today's Date Last Year 
            • Field to Measure: Enrollments - Count 
            • Custom Filter: 
              • (${enrollments.end_date}>=add_years(-1,trunc_years(now())) OR is_null(${enrollments.end_date})) AND ${enrollments.start_date}<=add_years(-1,now()) 
      • Measures 
        • Clients – Number of Clients 
        • Enrollments – Count  
      • “Explore from Here” 
        • There are two ways to explore this Look to obtain more information. 
          • Select “Explore from Here”, then click on enrollment or client 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.  
            • 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 enrollment or client count on the dashboard tile. 
        • Drill down functionality is not supported for the custom measures in this Look (Clients Served by Today's Date Last Year, Enrollments by Today's Date Last Year).  

      2 Years Prior – CE Client/Enrollment Counts 

      This Look contains a multiple value visualization with the count of clients and enrollments for last year. The count of clients and enrollments are broken down into two groups – total clients/enrollments for two years prior and count of clients/enrollments until the current date the dashboard is ran for two years prior. 

      Applicable Filters: CoC Code, Agency Name, Program Name, Household Type, Veteran Status, Chronically Homeless, Race & Ethnicity, and Gender 

      • Filters 
        • Enrollments – Reporting Period Filter: matches (advanced) “2 years ago” 
        • Programs – Project Type Code: is Coordinated Entry  
      • Custom Fields 
        • Custom Measures 
          • Clients Served by Today's Date Last Year 
            • Field to Measure: Clients – Number of Clients 
            • Custom Filter: 
              • (${enrollments.end_date}>=add_years(-2,trunc_years(now())) OR is_null(${enrollments.end_date})) AND ${enrollments.start_date}<=add_years(-2,now()) 
          • Enrollments by Today's Date Last Year 
            • Field to Measure: Enrollments - Count 
            • Custom Filter: 
              • (${enrollments.end_date}>=add_years(-2,trunc_years(now())) OR is_null(${enrollments.end_date})) AND ${enrollments.start_date}<=add_years(-2,now()) 
      • Measures 
        • Clients – Number of Clients 
        • Enrollments – Count  
      • “Explore from Here” 
        • There are two ways to explore this Look to obtain more information. 
          • Select “Explore from Here”, then click on enrollment or client 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.  
            • 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 enrollment or client count on the dashboard tile. 
        • Drill down functionality is not supported for the custom measures in this Look (Clients Served by Today's Date Last Year, Enrollments by Today's Date Last Year). 

       

      Updated: 11/06/2023