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 1 year 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  


Outreach v2 Model: Encampment Utilization Review Over Time

 

The following steps outline how to create this look in the Outreach v2 Model

1. Explore - Outreach v2 Model 
2. Fields 
     Add the following fields to the Look:  

  • Custom Measures 
    • Active in an Encampment Today 
      • Field to Measure: Count Client IDs
      • Custom Filter: 

${geolocation_encampment_history.start_date}<=now() AND ${geolocation_encampment_history.end_date}>=now()

    • Active in an Encampment 3 Months Ago  
      • Field to Measure: Count Client IDs
      • Custom Filter:

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

    • Active in an Encampment 6 Months Ago 
      • Field to Measure: Count Client IDs
      • Custom Filter: 

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

    • Active in an Encampment 9 Months Ago 
      • Field to Measure: Count Client IDs
      • Custom Filter: 

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

    • Active in an Encampment 1 year Ago 
      • Field to Measure: Count Client IDs
      • Custom Filter: 

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

3. Filters

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

  • Enrollments Link Filter is Encampment Programs (Required)
  • Encampments – Name of Encampment: Set filter to specific Encampment Name 

4. Visualization – Multiple Values  

 

Updated: 04/17/2024