The following changes will be implemented in the data analysis tool, effective 11/14/2022. There may be changes to this article until the release date.
General Changes
We will be upgrading Looker to version 22.18 on 11/15/2022. Review Looker’s changelog for details.
LookML Dashboard Updates:
Customer Configuration LookML Dashboard: Updated to ensure accurate counts. A bug was identified and Look configured filters were updated to ensure the dashboard runs as expected.
CE Enrollments Overview: Filter Updates (Added Project Type Code and linked to Program Name)
CE Referrals and Outcomes: Notes and Filter Updates (Updated Notes to be more concise and filter order)
CE Referrals - Denied and Expired: Look and Filter Updates (Updated linked article, Referral Status default, and added Look filters for Referral Status for the first 2 and last 3 Looks)
CE Referrals - Accepted and Completed: Updated Article Link
Looker Explore Updates:
The date dimension groups have been reviewed throughout Looker. Any dimension groups simply named "date" have been updated with a label to provide a more descriptive name. The fields’ object names have not changed.
Required Action: Analysis conducted outside Looker involving downloaded data may need to be updated to accommodate the updated labels. Fields and models affected are listed below.
Multiple time and date fields were changed so that the timeframes available were either "[date, week, month, quarter, year]" or "[time, date, week, month, quarter, year]". This change will allow a greater selection of date options when creating Looks or Dashboards. This will impact all models and multiple fields. “Time” was removed as a timeframe from some dimension groups.
Required Action: Update any looks or dashboards using the fields:
- Client Alerts:Expiration Time
- Client Assessments:Assessment Time
- Client Assessments:Education - Child Time.
Added fields for "First Current Living Situation Per Client (System)" and "Last Current Living Situation Per Client (System)" to the Client, Coordinated Entry, and HMIS Performance models. These fields denote the First and Last Current Living Situation Assessment Record for the client across the system regardless of the filters applied to the explore.
Added “Alias” field to the Programs view in the HMIS Performance model.
Updated Buildings: Last Updated field in the Inventory and Project Descriptor Models to use the correct field.
Required Action: None
HMIS Performance Model
In the Client Addresses view, the field previously labeled “Address Date Date” is now labeled “Address Date.”
In the Client Contacts view, the field “Client Contact Date Date” is now labeled “Client Contact Date”
In the Client Alerts view, “Expiration Time” has been removed.
In the Client Assessments View, “Assessment Time” and “Education - Child Time” have been removed.
Added “Alias” field to the Programs view.
System Performance Measures - A "Measure 1" breakout has been added to the HMIS Performance model under the "System Performance Measures" section. "Measure 1" group can still be used to address the 4 measure 1 types at once, but this is recommended only for small and medium-sized instances. Larger instances should consider reporting each type separately on different queries. These queries can be stacked on a dashboard if the user wants to see all them at once. The groups "Measure 1a1", "Measure 1a2", "Measure 1b1" and "Measure 1b2" have the same dimensions/measures as "Measure 1" but just for their respective Measure 1 type.
More information will be available in this article.
Multiple field descriptions in the outbound recidivism view have been updated. "Next Entry Date", "Next Entry Program", "Next Entry Program ID", "Next Entry Without Stable Housing Date", "Next Entry Without Stable Housing Program", and "Next Entry Without Stable Housing Program ID" now have updated descriptions that describe the fields more clearly.
Added a description to the “Enrollments Deleted” field.
Action Required:
- Update field labels in content external to looker using the following fields:
- Client Addresses:Address Date
- Client Contacts:Client Contact Date.
- Update any looks or dashboards using the fields:
- Client Alerts:Expiration Time
- Client Assessments:Assessment Time
- Client Assessments:Education - Child Time.
Client Model
In the Client Referral Status view, the “Referral ID” field has been hidden and will be removed in a future release. Existing content using this field will continue to work but it will no longer be selectable in the user interface.
In the Client Alerts view, “Expiration Time” has been removed.
In the Client Assessments View, “Assessment Time” and “Education - Child Time” have been removed.
In the Referral History view, the field previously labeled “Date” is now labeled “Referral History Date”.
In the Service Attendance Dates view, The field previously labeled “Date” is now labeled “Service Attendance Date”.
In the Service Expenses view, The field previously labeled “Date” is now labeled “Service Expense Date”.
In the Client Addresses view, the field previously labeled “Address Date Date” is now labeled “Address Date.”
In the Client Contacts view, the field “Client Contact Date Date” is now labeled “Client Contact Date”
Added a description to the “Enrollments Deleted” field.
Action Required:
- Update any looks or dashboards using the fields:
- Client Alerts:Expiration Time,
- Client Assessments:Assessment Time, and
- Client Assessments:Education - Child Time.
- Update field labels in content external to looker using the following fields:
- Referral History:Referral History Date,
- Service Attendance Dates:Service Attendance Date
- Service Expenses:Service Expense Date
- Client Addresses:Address Date
- Client Contacts:Client Contact Date.
- Prepare to remove from looks or dashboards:
- Client Referral Status: Referral ID
Project Descriptor Model
Added the Location field to the “Agency Sites” view.
Action Required: None
Coordinated Entry Model
In the Client Alerts view, “Expiration Time” has been removed.
In the Client Assessments View, “Assessment Time” and “Education - Child Time” have been removed.
In the Service Attendance Dates view, The field previously labeled “Date” is now labeled “Service Attendance Date”.
In the Program Openings view, the field previously labeled “Date” is now labeled “Program Opening Date”.
In the Referral History view, the field previously labeled “Date” is now labeled “Referral History Date”.
Added a description to the “Enrollments Deleted” field.
Action Required:
- Update any looks or dashboards using the fields:
- Client Alerts:Expiration Time
- Client Assessments:Assessment Time
- Client Assessments:Education - Child Time
- Update field labels in content external to looker using the following fields:
- Program Openings:Date
- Referral History:Referral History Date
- Service Attendance Dates:Service Attendance Date
- Service Expenses:Service Expense Date
- Client Addresses:Address Date
- Client Contacts:Client Contact Date.
Services Model
In the Service Expenses view, The field previously labeled “Date” is now labeled “Service Expense Date”.
In the Service Attendance Dates view, The field previously labeled “Date” is now labeled “Service Attendance Date”.
In the Client Assessments View, “Assessment Time” and “Education - Child Time” have been removed.
Action Required:
- Update any looks or dashboards using the fields:
- Client Assessments:Assessment Time
- Client Assessments:Education - Child Time
- Update field labels in content external to looker using the following fields:
- Service Expenses:Service Expense Date,
- Service Attendance Dates:Service Attendance Date
Updated: 11/04/2022