Data Models
      Back to home
      1. Clarity Human Services Help Center
      2. Data Analysis
      3. Data Models

      Population Over Time Model

      Purpose

      The Population Over Time Model is designed to analyze long term trends in your data and complete longitudinal analysis. This model includes data for clients with an enrollment history in a project to analyze effectiveness, growth, and other system insights. Longitudinal analysis utilizing this model can be broken down into weekly, monthly, quarterly or yearly intervals on any given day for the identified reporting range to review trends and evaluate programs for a two year lookback period (730 days prior to the date the query is run).

      The Population Over Time model was not designed to be a client-based model. This model is focused to analyze your community’s effectiveness.

      The data within this model is calculated week by week (Monday - Monday). Keep this in mind while using this model which can affect weekly, monthly, quarterly, and yearly analysis when the time range does not begin on a Monday.


      At the end of this article, there are instructions for creating sample looks with the Population Over Time model.

      Overview

      The Population Over Time model includes the following views:

      • Agencies
        • Includes basic information about the Agency
        • Compares with Organization table in HUD CSV/XML
        • Information comes from the Manage > Agencies > Agencies Overview screen
      • Bed Utilization
        • Information from the Manage > Programs > Bed & Unit Inventory
        • Note: Bed Utilization will be undergoing improvements in the near future to account for variable bed inventory over time.
      • Clients
        • Static demographic fields such as Name, Date of Birth, Social Security Number, Veteran Information, etc.
        • Information found on the Client Profile screen
      • Entry Screen
        • Information collected at the point of project enrollment
      • Last Screen
        • Information collected from the exit screen
          • If there is no data in the exit screen, the data is from the most recent update screen
      • Population
        • This view is unique to the Population Over Time model
        • Includes:
          • Report Range filter
            • Defaults to “is in the past 6 months”
          • Observation Date interval dimension
            • Most granular interval is week
        • Note: The Report Range filter and Observation Date dimension are required for Looks utilizing the Population Over Time model.

      In addition, the model includes the following which are also found on most other client-centered models:

      • Clients
        • Fields are from the Profile screen
        • Custom Profile fields are included in this section
      • Enrollments
        • This section includes dimensions related to the enrollment:
          • Project Start & End Dates
          • Household Configuration
          • Average Days in Project
          • Latest Move-in Date
          • Days from Project Start to Move-in
      • Program Sites
        • Information from Manage > Programs > Sites
      • Programs
        • Information from Manage > Programs > Sites

      Note: For more information on specific dimensions or measures, refer to the (information bubble) available next to some of the field names.
      Float your cursor over the field and select the information bubble for a brief description.

      Sample Looks

      Total Persons Served

      Utilize the prompts below to create a Look and visualization to view persons served by week with a trend line visualization.

      Filters

      • Population - Report Range
      • Agencies - CoC Code

      Dimensions

      • Population - Observation Date - Weekly

      Measures

      • Clients - Number of Clients

      Visualization

      Select the “Line” visualization and your preferred color for the chart to review potential trends in persons served.

      The Look below utilizes a “Column” visualization and a quarterly Observation Date.

      Further Analysis

      To build off of this Look for additional analysis, pivot by various demographics like the Veteran Status, Gender or Race dimensions.

      Further Analysis Sample Look featuring total persons served with weekly intervals by Veteran Status.


      Further Analysis Sample Look featuring total persons served with weekly intervals by Gender.

      Project Type Evaluation

      This Look will highlight a monthly, project specific trend line for the number of clients enrolled. This example will be filtered to Emergency Shelter projects. The prompts listed below to create the Look and visualization.

      Filters

      • Population - Report Range
      • Agencies - CoC Code
      • Programs - Project Type Code
        • This sample uses an emergency shelter filter

      Dimensions

      • Population - Observation Date - Month

      Measures

      • Clients - Number of Clients

      Visualization

      Select the “Line” visualization and your preferred color for the chart to review potential trends for the emergency shelters within this community.