Updates to the HMIS Population Over Time model
We would like to see updates to the HMIS Population Over Time model
It would be useful to have more data elements including:
a. Household Type
b. Relationship to Head of Household
c. Project Start/Exit Month/Year just like setup in HMIS Performance and Client Model.
d. Reporting Period Start/End Date
- It is currently difficult to perform population-based measure without additional data elements in this model. Using a Merge Query doesn't work for visualizations requiring pivot. For example
a. How to get Households served by different project types over time pivoted by Household Type?
b. In a quarter – how to create a table of client counts with first, second, and third month of quarter as column?