I updated the data model for CaseReportsPerRegionLast4Weeks to make it easier to update and aggregate data correctly.
Currently both of the tables in analytics are not aggregated because the event processor is not updating an existing entry in the database. That means that each day/week in the table is consisting of a single report only.
I have made scripts to clean the data already in the database to relaunch analytics from scratch and make it work with correct data.
I updated the data model for CaseReportsPerRegionLast4Weeks to make it easier to update and aggregate data correctly.
Currently both of the tables in analytics are not aggregated because the event processor is not updating an existing entry in the database. That means that each day/week in the table is consisting of a single report only.
I have made scripts to clean the data already in the database to relaunch analytics from scratch and make it work with correct data.
Fixes #1214