The following changes will be implemented in the data analysis tool, effective 1/8/2021.
- ID, Service Attendance Date - Added dimension
- Aftercare Project (Y/N), Services - Added dimension
- Version, Release of Information - Added dimension
- Days from Project Start to Move-in - Description has been updated to provide a simpler and more accurate description
- Average Days from Project Start to Move-In - Description has been updated to provide a simpler and more accurate description
- Move-in Dates - The performance of these measures has been improved
- Looker content will continue to run and is not affected by the code updates, except for a speed improvement
- Income from Any Source - Updated label
- Any saved Looks filtering for "Unknown" will need to be updated to "NULL"
- User Created and Updated - Performance improvements were made to User Created and User Updated fields
Client Model
- Agency ID, Client Last Interaction - Added dimension
- Agency Name, Client Last Interaction - Added dimension
- Agency CoC, Client Last Interaction - Added dimension
- Client Last Interaction - Dimension was fixed to no longer show invalid row data
- Client Last Interaction now shows data with the Client's last interaction
- Is Latest Service Based on Enrollment Filter - Fixed an issue that was not letting the user filter out by the latest service linked to the enrollment
- User Name - the performance of this dimension has been improved to increase speed
Data Quality Model
- Updated the following with the current list of Funding Sources from the HMIS Data Dictionary:
- Grant Start Date Error
- Grant End Date Error
- Funding Source Error
- Overlapping Residential Enrollments Count, DQ Sys Admin - Corrected measure so it now aggregates the count correctly
- Overlapping Agency, DQ Sys Admin - Added dimension
- Overlapping Move-In Date, DQ Sys Admin - Added dimension
- Overlapping Tracking Method, DQ Sys Admin - Added dimension
HMIS Performance Model
- Is Latest Enrollment by Date/Project Type - Dimension has been modified to use latest start date and date comparisons have been reworked to look for active enrollments during the enrollment reporting period filter date range
- Agencies ROI - Join relationship updated to "many to one"
Population Over Time
- ID, Enrollments - Enrollment ID variable issue fixed by adding it to the necessary field array
Project Descriptor Model
- CoC ROI Settings - New section added to show the ROI information created from the site settings for a CoC
- Agency ROI Setting - New section added to show the ROI information created for some specific agencies
- Program CoC ROI Settings - New section added which is similar to CoC ROI Settings, but allows showing the CoC ROI together with program details in the same row
- Status, Screens - Dimension has been updated to reflect "Active" and "Inactive" rather than True/False
- Action Needed - Filters on existing saved Looks should be updated with new label
- Services - Agency Services and Project Services are now combined under a Services group
- Program Usage dimension will be needed to differentiate between Agency, Project or Agency & Project Services