handling for querying progressAssessments and normalization of data