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 Model2. Fields
Add the following fields to the Look:
-
- Custom Measures
-
-
- Active in an Encampment Today
- Field to Measure: Number of Clients
- Custom Filter:
- Active in an Encampment Today
-
${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:
- Active in an Encampment 6 Months Ago
-
${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:
- Active in an Encampment 9 Months Ago
-
${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
- Active in an Encampment 9 Months Ago
-
-
-
-
- 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