Sample Looks
      Back to home
      1. Clarity Human Services Help Center
      2. Data Analysis
      3. Sample Looks

      Outreach Model: Encampment Utilization Review Over Time

      Reviewing how encampment utilization changes over time is an important part of systemwide planning for outreach and housing initiatives. The Look below is designed to review clients in encampments (systemwide or with filters to review specific encampments) and utilization by reviewing active clients in encampments today, 3 months ago, 6 months ago, 9 months ago, and 1 year ago.  

      Encampment Review over time

      The steps below outline how to create this Look.  

      1. Explore - Outreach Model 
      2. Fields 
           Add the following fields to the Look:  
        • Custom Measures 
          • Active in an Encampment Today 
            • Field to Measure: Number of Clients 
            • Custom Filter: 

      ${encampment_occurrences.start_date}<=now()

      AND is_null(${encampment_occurrences.end_date}) 

          • Active in an Encampment 3 Months Ago  
            • Field to Measure: Number of Clients 
            • Custom Filter:

      ${encampment_occurrences.start_date}<=add_months(-3,(now())) AND (${encampment_occurrences.end_date}>add_months(-3,(now())) OR is_null(${encampment_occurrences.end_date})) 

          • Active in an Encampment 6 Months Ago 
            • Field to Measure: Number of Clients 
            • Custom Filter: 

      ${encampment_occurrences.start_date}<=add_months(-6,(now())) AND (${encampment_occurrences.end_date}>add_months(-6,(now())) OR is_null(${encampment_occurrences.end_date})

          • Active in an Encampment 9 Months Ago 
            • Field to Measure: Number of Clients 
            • Custom Filter: 

      ${encampment_occurrences.start_date}<=add_months(-9,(now())) AND (${encampment_occurrences.end_date}>add_months(-9,(now())) OR is_null(${encampment_occurrences.end_date}))  

          • Active in an Encampment 9 Months Ago 
            • Field to Measure: Number of Clients 
            • Custom Filter: 

      ${encampment_occurrences.start_date}<=add_months(-12,(now()))  AND (${encampment_occurrences.end_date}>add_months(-12,(now())) OR is_null(${encampment_occurrences.end_date})) 

      3. Filters

           Add the following fields as filters to the Look as needed:  

        • Encampments – Name of Encampment: Set filter to specific Encampment Name 

      4. Visualization – Multiple Values  

       

      Updated: 09/08/2022