add report_over_time querries for Kristen's request