search

TEAMSchools / mssql-warehouse

SQL repository for the KIPP Team & Family Schools data warehouse
https://www.kippnj.org/data
GNU General Public License v3.0
7 stars 1 forks source link

tableau.pm_teacher_goals #505

Open kevinverhoff opened 1 year ago

kevinverhoff commented 1 year ago

Rows 197 to 215 should use data from pm.teacher_goals_lockbox_wide rather than pm.teacher_goals_lockbox. The averaging of the data from the pm.teacher_goals_lockbox leads to misleading scores if there are multiple entries in the lockbox.. Lockbox_wide solves for the problem.

kevinverhoff commented 1 year ago

I think we should wait until this PM round is completely over before we mess with anything, fwiw