← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] [Dhis-devs][DHIS 2.27]Discrepancy in distribution of data in monthly reports as per EPI weeks

 

Hello Preeti,

We are facing the same thing in 2.28 where Week 48 (the week that intersects between Nov and dec) is actually aggregated/added in both Nov and Dec.

Maybe the dev team has some insight on this?

>From our side, when the period of collection of data is weekly, we never compare monthly to weekly and only report either monthly or weekly but never the two at the same time; even though solving this could be extremely helpful into not repeating the intersecting week’s data in 2 months which would cause errors. This is not the case when the data is collected on a daily basis.

Looking forward to a possible answer/solution.



All the best,

Bernard






Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail:  <mailto:lib.ima@xxxxxxxxxx> lib.ima@xxxxxxxxxx

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org





From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of Preeti Ajgaonkar
Sent: Friday, March 2, 2018 8:43 AM
To: DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>; DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Cc: Evgenia ZELIKOVA <evgenia.zelikova@xxxxxxxxxxxxx>; twmsf <twmsf@xxxxxxxxxxxxxxxx>; Anceline DUPOUY <Anceline.DUPOUY@xxxxxxxxxxxxx>; Sonia Diverres <sonia.diverres@xxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] [Dhis-devs][DHIS 2.27]Discrepancy in distribution of data in monthly reports as per EPI weeks



Apologies, the figures for expected and actual values for the months of Nov and Dec 2017 should be as follows



Expected

November 2017 - 495

December 2017 - 361



Actual

November 2017 - 398

December 2017 - 458



Thanks

Preeti A





On Fri, Mar 2, 2018 at 12:08 PM, Preeti Ajgaonkar <apreeti@xxxxxxxxxxxxxxxx <mailto:apreeti@xxxxxxxxxxxxxxxx> > wrote:

Hi team,



Ever since we have upgraded to DHIS 2.27 and started using EPI weeks for distribution of data in any reports, we have noticed a discrepancy in the data for the months starting on a Friday.



For e.g. data for W44 to W48 should be attributed to Nov 2017 as per the EPI week rule, but W48 data it is attributed to Dec 2017 (which starts on a Friday). See screenshots below



Monthly





Weekly





Expected

November 2017 - 398

December 2017 - 458



Actual

November 2017 - 495

December 2017 - 361



Similar issue is observed from W31 - W35 where the data should for W35 should be counted as part of Aug 2017 but it appears in Sep 2017(which also starts on a Friday).


Monthly







Weekly





Expected

August 2017 - 614

September 2017 - 452



Actual

August 2017 - 499

September 2017 - 567



I am expecting the same thing to happen in Apr-May 2018.



Any leads on this would be appreciated.


--

Thanks

Preeti Ajgaonkar







--

Thanks

Preeti Ajgaonkar



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

PNG image

PNG image

PNG image

PNG image

PNG image


Follow ups

References