Odd Reporting rates summary

Support - Assistance technique
1

Hi

I need to make a report where a I could see the Actual and Expected Reports for a defined number of DataSets and OrgUnits.

In the Beginning I was using the Reporting Rate in Reports functionality, but then I used Pivot Tables to get the same values.

What I found out is that the pivot tables and Reporting Rate in Reports functionality are showing different values for most of the DataSets and OtgUnits

​My questions are:

  • Why are the two (2) methods giving me different results?
  • Which one of them​ is correct?

Best regards

···

–
João X. Machiana
Systems Analyst and Programmer

1 Like
2

Dear Joao,

Does this happen after the analytics have run?

Reporting rates pick real-time data while pivot tables use data after analytics have run.

Regards

···

On Fri, Jan 12, 2018 at 10:28 AM, Joao Machiana joaomachiana@gmail.com wrote:

Hi

I need to make a report where a I could see the Actual and Expected Reports for a defined number of DataSets and OrgUnits.

In the Beginning I was using the Reporting Rate in Reports functionality, but then I used Pivot Tables to get the same values.

What I found out is that the pivot tables and Reporting Rate in Reports functionality are showing different values for most of the DataSets and OtgUnits

​My questions are:

  • Why are the two (2) methods giving me different results?
  • Which one of them​ is correct?

Best regards

João X. Machiana
Systems Analyst and Programmer

–

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

3

Hi Prosper

The analytics are scheduled to run everyday at 12AM.

Based on your answer, is safe to say that forms are still being “submitted”?

Best regards

···

On Fri, Jan 12, 2018 at 9:34 AM, Prosper BT ptb3000@gmail.com wrote:

Dear Joao,

Does this happen after the analytics have run?

Reporting rates pick real-time data while pivot tables use data after analytics have run.

Regards

–

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda

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

On Fri, Jan 12, 2018 at 10:28 AM, Joao Machiana joaomachiana@gmail.com wrote:

Hi

I need to make a report where a I could see the Actual and Expected Reports for a defined number of DataSets and OrgUnits.

In the Beginning I was using the Reporting Rate in Reports functionality, but then I used Pivot Tables to get the same values.

What I found out is that the pivot tables and Reporting Rate in Reports functionality are showing different values for most of the DataSets and OtgUnits

​My questions are:

  • Why are the two (2) methods giving me different results?
  • Which one of them​ is correct?

Best regards

João X. Machiana
Systems Analyst and Programmer

–

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

João X. Machiana
Systems Analyst and Programmer

4

When analytics run reporting rates will be updated and pivot tables will reflect the actual results.

But you are right I also tested with previous reporting rates, there is a slight difference that need to be investigated.

Regards

···

On Fri, Jan 12, 2018 at 10:46 AM, Joao Machiana joaomachiana@gmail.com wrote:

Hi Prosper

The analytics are scheduled to run everyday at 12AM.

Based on your answer, is safe to say that forms are still being “submitted”?

Best regards

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda

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

On Fri, Jan 12, 2018 at 9:34 AM, Prosper BT ptb3000@gmail.com wrote:

Dear Joao,

Does this happen after the analytics have run?

Reporting rates pick real-time data while pivot tables use data after analytics have run.

Regards

–
João X. Machiana
Systems Analyst and Programmer

Prosper Behumbiize, MPH
DHIS2 Implementation Adviser| HISP Uganda

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

On Fri, Jan 12, 2018 at 10:28 AM, Joao Machiana joaomachiana@gmail.com wrote:

Hi

I need to make a report where a I could see the Actual and Expected Reports for a defined number of DataSets and OrgUnits.

In the Beginning I was using the Reporting Rate in Reports functionality, but then I used Pivot Tables to get the same values.

What I found out is that the pivot tables and Reporting Rate in Reports functionality are showing different values for most of the DataSets and OtgUnits

​My questions are:

  • Why are the two (2) methods giving me different results?
  • Which one of them​ is correct?

Best regards

João X. Machiana
Systems Analyst and Programmer

–

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

5

Hello Colleagues,

I have related issues.

  1. In DHIS2, i closed (not deleted) some facilities. When i generate reporting rate summary (i.e. the percentage of facilities that reported), it does not deduct the closed facilities in the denominator. Is there way to adjust the denominator for reporting summary rate?
  2. Is it possible to see a list of facilities with a completed data set using the report application without looking at the data entry forms and/or pivot table?

Thanks.

1 Like