Update denominator for subgroup share in housing stability data and backfill data for 2014-2015 and 2015-2016

[ridhi96]

Metric Update

This issue updates the housing stability metric. Please read through the instructions below carefully. The check at the bottom of this issue should all be completed and marked off prior to creating a final PR for the metric update.

Update goals -

1. Discuss altering denominator for subgroup share (race/ethnicity) from total homeless, back to enrolled students of that race
   group from 2019-present.
   2. Update SY 2022-2023 for cities, counties, and subgroup (Refer Issue 435)
2. Backfill SY 2014-2015 & SY 2015-2016 for cities (crosswalks are available for this now)

Please review the instructions on the wiki before starting work on a metric update.

Crosswalks

Crosswalks were updated prior to the 2024-25 metric update process. If you are editing an existing program please check that the crosswalk being used is the latest version. For more information on crosswalks, see the crosswalk page on the Wiki.

Checklist

The checklist below outlines key steps that should be taken during the process of this metric update. These steps should all be checked off prior to finalizing the metric update.

Setup

• Metric lead has checked out a new branch from the Version2025 repo that is named after the number associated with this issue, i.e. iss###
• Metric lead has filled out the final data expectations from located in the functions folder of the repo and saved this form in the metrics data folder for all relevant final output files
• Metric lead has read through the existing version of the program and has located and examined the existing output files

Program Documentation

• The update program includes a description at the start with the date, the latest changes made and the author of the metric lead that made them
• If the program reads in raw data that is not available through an API, then the code includes a note on where this data is in Box (including the title of relevant files)
• Each step taken in the calculation is clearly documented in the code using comments
• The program is broken out into manageable steps and the code avoids using extensively long lines connected via pipes or pipe equivalents if not using R

Quality Control

• The program includes visuals of the distribution of key analysis variables throughout the calculation steps
• The program includes visualizations of the final data as well as summary statistic and a selection of assumptions tests (including count of rows by year, missing values and calculation of outliers (min & max) plus any additional checks deemed necessary)
• Assumption tests are applied to all years being created in the program. If a year in the historical version of the metric data is not being recreated in this program, that historical data is read in and differences with new years are visualized.
• The program includes the creation of a quality variable for the metric and documents the method for assigning quality grades

Reproducibility

• The program runs from start to finish without stopping due to errors or incompleteness
• The program avoids hardcoding local file paths and instead uses global paths that will work regardless of where the program is being ran (i.e. here::here() for R users)
• The program includes a “House Keeping” section which loads all necessary packages at the top of the program

Final Data

• The program reads out a final file in the form of a CSV document or multiple CSVs into a data folder in the relevant metric folder
• Final files include the relevant years in title if the metric has multiple files separated by year
• All final files being read out by the update program are put through the evaluate final data function

Review

• When ready for review the metric lead has submitted a PR to Version2025 using the PR template

[cdsolari]

@ekgutierrez1 For the denominator of the racial/ethnic subgroups, last round, we switched the denominator from all students in that racial/ethnic group to all homeless students. You left a specific note about this in your code. When we went to show the data, the dashboard had a glitch and that table note about this switch in the denominator never made it, and it created a lot of confusion. For that reason, and because we are now working on a solution to the scale of the data display, we decided to switch back to having the denominator as all students in that racial/ethnic group. Please retain all decimal points in your calculation and do not round (I believe you already do this). Also tagging @MaureenSarver for awareness.