Discrepancy in weekly vs monthly reporting period

Hi all,

I get different monthly consultation numbers when I create same pivot table using weekly and monthly reporting period for same period (let’s say Jan-2018). Therefore, I was wondering if anyone ever encounter same issue with DHIS2 implementation and how I can resolve this problem because I can’t rely on monthly, quarterly, annual reporting period numbers as they are not accurate as weekly.

Many thanks,

Raheel

···

Dear Raheel,

This is caused by the overlap in weeks over different months, it will not perfectly match unless you are collecting data daily.

Regards

···

On Thu, Feb 1, 2018 at 10:02 PM, Raheel Ayaz raheelayaz@gmail.com wrote:

Hi all,

I get different monthly consultation numbers when I create same pivot table using weekly and monthly reporting period for same period (let’s say Jan-2018). Therefore, I was wondering if anyone ever encounter same issue with DHIS2 implementation and how I can resolve this problem because I can’t rely on monthly, quarterly, annual reporting period numbers as they are not accurate as weekly.

Many thanks,

Raheel


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda

prosper@hispuganda.org | prosper@dhis2.org | Skype: prospertb

Dear Prosper,

Thanks for your kind reply. Entering data on daily basis for our context is not feasible therefore we have to enter/import data into DHIS2 on weekly basis.

Since weekly, monthly, quarterly, etc. as period have been provided by DHIS2 database, don’t you think they all should be align with each other while extracting the data? In addition, I was wondering if DHIS2 developers are aware of this issue?

Many thanks,

Raheel

···

On Tue, Feb 6, 2018 at 6:55 AM, Prosper BT ptb3000@gmail.com wrote:

Dear Raheel,

This is caused by the overlap in weeks over different months, it will not perfectly match unless you are collecting data daily.

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda

prosper@hispuganda.org | prosper@dhis2.org | Skype: prospertb

On Thu, Feb 1, 2018 at 10:02 PM, Raheel Ayaz raheelayaz@gmail.com wrote:

Hi all,

I get different monthly consultation numbers when I create same pivot table using weekly and monthly reporting period for same period (let’s say Jan-2018). Therefore, I was wondering if anyone ever encounter same issue with DHIS2 implementation and how I can resolve this problem because I can’t rely on monthly, quarterly, annual reporting period numbers as they are not accurate as weekly.

Many thanks,

Raheel


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Dear Rachel,

Unfortunately , working over the overlap issues may not be an easy one. The big question is which month do you consider the data for if the week starts within the previous month or the one that ends in another month,

Probably the month with many days takes up the data BUT remember like Prosper said, it will be an approximation and not an exact match of data.

A More realistic data would be accurate as you go higher in the period hierarchy e…g. quarterly, …

Regards

Regards.

···

On Sun, Feb 11, 2018 at 4:12 PM, Raheel Ayaz raheelayaz@gmail.com wrote:

Dear Prosper,

Thanks for your kind reply. Entering data on daily basis for our context is not feasible therefore we have to enter/import data into DHIS2 on weekly basis.

Since weekly, monthly, quarterly, etc. as period have been provided by DHIS2 database, don’t you think they all should be align with each other while extracting the data? In addition, I was wondering if DHIS2 developers are aware of this issue?

Many thanks,

Raheel


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Feb 6, 2018 at 6:55 AM, Prosper BT ptb3000@gmail.com wrote:

Dear Raheel,

This is caused by the overlap in weeks over different months, it will not perfectly match unless you are collecting data daily.

Regards

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda

prosper@hispuganda.org | prosper@dhis2.org | Skype: prospertb

On Thu, Feb 1, 2018 at 10:02 PM, Raheel Ayaz raheelayaz@gmail.com wrote:

Hi all,

I get different monthly consultation numbers when I create same pivot table using weekly and monthly reporting period for same period (let’s say Jan-2018). Therefore, I was wondering if anyone ever encounter same issue with DHIS2 implementation and how I can resolve this problem because I can’t rely on monthly, quarterly, annual reporting period numbers as they are not accurate as weekly.

Many thanks,

Raheel


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

You can do anything, but not everything.