← 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

 

Thanks a lot Marta for the update. The PR is merged in 2.28, but not
backported to 2.27. It would be great if we can have the fix in 2.27 as
well.

On Fri, Mar 2, 2018 at 1:56 PM, Marta Vila <martavila@xxxxxxxxx> wrote:

> Hello all,
>
> this was reported in Jira by Victor  https://jira.dhis2.
> org/browse/DHIS2-2769
>
> I see the issue is open but the pull request is merged (for 2.28 at least,
> not sure is was backported)... So I would suggest to check the most recent
> built.
>
> Cheers,
> Marta
>
> On 2 March 2018 at 08:18, Bernard Sadaka (IM Advisor) <lib.ima@xxxxxxxxxx>
> wrote:
>
>> 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
>>
>>
>>
>> [image: cid:image002.png@01D36F50.572585A0]
>>
>> *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:* lib.ima@xxxxxxxxxx
>>
>> *Cell:* +961 71 004 881 (208)
>>
>> *Skype:* imapuami
>>
>> *Website:* 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> 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
>>
>> [image: Inline image 1]
>>
>>
>>
>> Weekly
>>
>> [image: Inline image 3]
>>
>>
>>
>> *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
>>
>> [image: Inline image 1]
>>
>>
>>
>>
>>
>> Weekly
>>
>> [image: Inline image 4]
>>
>>
>>
>> *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
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> Virus-free.
>> www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>> <#m_327517825036961655_m_-7961233993995190025_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>


-- 
Thanks
Preeti Ajgaonkar

PNG image

PNG image

PNG image

PNG image

PNG image


Follow ups

References