Pivot Table Computation Error on 2.24

Dear All,
After upgrading from 2.21 to 2.24 we noticed the following, when we
were pulling pivot table reports:
For Example if our:

Data Sets is HF1(Morbidity)
Periods is Monthly (the whole of 2015)
Organizations: Facility and then Chiefdom for Malema

and we are getting 100% which is not possible but when i revert to
2.21 the result is different. Please find the attached results from
2.24

Please i need help to solve this issue.

data.xls (13.5 KB)

data(1).xls (13.5 KB)

···

--
Regards,

Gerald

Dear Gerald,

You may need to share more information especially on the rates using 2.21. To see the margin difference.

Could it be that in 2.21 there are alot of new facilities what were being created moving forward that caused change in reporting rates for the previous periods when the facilities were not expected to report?

With 2.24, reporting rates are based on when the facility was created i.e the opening date of the facility

Expected reports based on org unit opening and closed date: For reporting rates in analytics, the number of expected reports is now calculated based on whether the organisation units assigned to the data set were open or not for the aggregation period. As an example, if you ask for reporting rates for a district for June, and one of the facilities within the district was not open until August, that facility will not be included in the number of expected reports.

Screenshot

···

On Fri, Jul 15, 2016 at 6:01 PM, gerald thomas gerald17006@gmail.com wrote:

Dear All,

After upgrading from 2.21 to 2.24 we noticed the following, when we

were pulling pivot table reports:

For Example if our:

Data Sets is HF1(Morbidity)

Periods is Monthly (the whole of 2015)

Organizations: Facility and then Chiefdom for Malema

and we are getting 100% which is not possible but when i revert to

2.21 the result is different. Please find the attached results from

2.24

Please i need help to solve this issue.

Regards,

Gerald


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
Global DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139

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