← 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

 

pfa

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

> 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 <+961%2071%20004%20881> (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_4928622876564979213_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
>
> _______________________________________________
> 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
>
>


-- 

Navod Neranjan
B.Sc. (Honours) in Management and Information Technology
Department of Industrial management
University of Kelaniya
m: +94717661555 <+94%2071%20766%201555> skype : neranjan1992@xxxxxxxxxxx
<neranjanthi@xxxxxxxxxxx>
a: No 188/1,Abeyaraja Mawatha,Matugama
e: neranjanthi@xxxxxxxxx

<https://www.facebook.com/Navod.neranjan.Thi>
<https://www.linkedin.com/in/navod-neranjan-6266a5112/>
<https://www.instagram.com/navodneranjan/?hl=en>

PNG image

PNG image

PNG image

PNG image

PNG image


References