[x] New Requirement: Identify the "level" of engagement for each family during the given timeframe. This is basically counting the # of assignments that the family has, as opposed to just seeing if they have any assignments in the given timeframe or not.
[ ] New Requirement: Identify the most recent engagement for each family. For each family, identify the most recent end date of all of the arrangements that they were assigned to during the given timeframe. If an arrangement is still open, treat that as TODAY(), i.e., the family is currently assigned.
You can submit a draft PR with multiple commits to track your progress here, but there should probably be one PR that addresses both requirements.
2 is a prerequisite.
Tasks for this issue:
TODAY(), i.e., the family is currently assigned.You can submit a draft PR with multiple commits to track your progress here, but there should probably be one PR that addresses both requirements.