dhis2-devs team mailing list archive

[Olivier Cheminat <Olivier.CHEMINAT@xxxxxxxxxxxxx>]

Dear all,

MSF-OCP is using two types of data entry:

  *   Aggregate data entry on a weekly basis
  *   Event data based on the date of event

We are currently using the 2.22 version. In that version, we are using aggregation queries that aggregate event data into data sets that have a weekly time period.

We want to upgrade DHIS2 to 2.23 soon. As aggregation queries are not supported anymore in the 2.23 version, we will replace them with program indicators. We started to create several program indicators, but we are facing a problem.
When we create monthly reports the monthly totals don't match with the sum of the aggregated weekly totals belonging to that month. For example:

  *   Aggregate data for 2016W39 will be aggregated into 2016 September when displayed per month.
  *   Events with the date 2016-10-01 will be aggregated into 2016W39 when displayed by week but aggregated into 2016 October when displayed by month.
  *   This makes it confusing for end users because for aggregate data September 2016 is the sum of the weeks 2016W36-2016W39 (28 days), whereas for event data September 2016 is the sum of events between 2016-09-01 and 2016-09-30 (30 days).

Has anybody else experienced this problem, and is there a way to have these program indicators aggregated by month using ISO weeks?

Thank you.
Olivier.

Olivier Cheminat
eHealth Referent & Knowledge Coordinator
Médecins Sans Frontières - OCP