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.

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: 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: 06/18/2024