DHIS2 don't showing annualized Indicator based on Population data as expected monthly

Support - Assistance technique
1

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

2

Maybe you could set this up on https://play.dhis2.org/dev and post the corresponding Excel sheet so people can inspect it?

Knut

···

On Fri, Jul 21, 2017 at 1:19 PM, vunda limbe vundalon@gmail.com wrote:

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

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

–

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

3

Hi Vunda

Also is the aggregation operator for the population data element set to average (sum in org unit hierarchy)?

···

On Jul 21, 2017 7:20 PM, “vunda limbe” vundalon@gmail.com wrote:

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

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

4

Yes It is,

···

On Fri, Jul 21, 2017 at 1:16 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi Vunda

Also is the aggregation operator for the population data element set to average (sum in org unit hierarchy)?

On Jul 21, 2017 7:20 PM, “vunda limbe” vundalon@gmail.com wrote:

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

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

Hi

I had this question some time ago myself. DHIS2 actually calculates the indicator more mathematically correct than just dividing the denominator by 12 but consider a daily proportion based on 355/no of days per month

So Jan-Mar the numerator is multiplied by 365/(31+28+30)

Hope this helps.

Elmarie

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.

···

On 21 Jul 2017 3:21 PM, “vunda limbe” vundalon@gmail.com wrote:

Yes It is,

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

On Fri, Jul 21, 2017 at 1:16 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi Vunda

Also is the aggregation operator for the population data element set to average (sum in org unit hierarchy)?

On Jul 21, 2017 7:20 PM, “vunda limbe” vundalon@gmail.com wrote:

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

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

6

Hi Elmarie,

Thank you, but in practice It doesn’t suit my need by giving me the unexpected value. How In practice may I set up population?

Thanks.

···

On Fri, Jul 21, 2017 at 3:18 PM, Elmarie Claasen elmarie@hisp.org wrote:

Hi

I had this question some time ago myself. DHIS2 actually calculates the indicator more mathematically correct than just dividing the denominator by 12 but consider a daily proportion based on 355/no of days per month

So Jan-Mar the numerator is multiplied by 365/(31+28+30)

Hope this helps.

Elmarie

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.

On 21 Jul 2017 3:21 PM, “vunda limbe” vundalon@gmail.com wrote:

Yes It is,

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

On Fri, Jul 21, 2017 at 1:16 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi Vunda

Also is the aggregation operator for the population data element set to average (sum in org unit hierarchy)?

On Jul 21, 2017 7:20 PM, “vunda limbe” vundalon@gmail.com wrote:

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

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

7

Hi Vunda,

You probably need to provide a concrete example of exactly what you want and how what you get from DHIS2 is different.

Knut

···

On Mon, Jul 24, 2017 at 11:20 AM, vunda limbe vundalon@gmail.com wrote:

Hi Elmarie,

Thank you, but in practice It doesn’t suit my need by giving me the unexpected value. How In practice may I set up population?

Thanks.

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

–

On Fri, Jul 21, 2017 at 3:18 PM, Elmarie Claasen elmarie@hisp.org wrote:

Hi

I had this question some time ago myself. DHIS2 actually calculates the indicator more mathematically correct than just dividing the denominator by 12 but consider a daily proportion based on 355/no of days per month

So Jan-Mar the numerator is multiplied by 365/(31+28+30)

Hope this helps.

Elmarie

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.

On 21 Jul 2017 3:21 PM, “vunda limbe” vundalon@gmail.com wrote:

Yes It is,

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

On Fri, Jul 21, 2017 at 1:16 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi Vunda

Also is the aggregation operator for the population data element set to average (sum in org unit hierarchy)?

On Jul 21, 2017 7:20 PM, “vunda limbe” vundalon@gmail.com wrote:

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

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

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

8

Dear Vunda,

Dont also forget to check if the population data element is not assigned to multiple datasets with different reporting frequencies. Use the data integrality check under Data Administration.

Regards

···

On Mon, Jul 24, 2017 at 12:36 PM, Knut Staring knutst@gmail.com wrote:

Hi Vunda,

You probably need to provide a concrete example of exactly what you want and how what you get from DHIS2 is different.

Knut

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| HISP Uganda

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

On Mon, Jul 24, 2017 at 11:20 AM, vunda limbe vundalon@gmail.com wrote:

Hi Elmarie,

Thank you, but in practice It doesn’t suit my need by giving me the unexpected value. How In practice may I set up population?

Thanks.

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

–
Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

On Fri, Jul 21, 2017 at 3:18 PM, Elmarie Claasen elmarie@hisp.org wrote:

Hi

I had this question some time ago myself. DHIS2 actually calculates the indicator more mathematically correct than just dividing the denominator by 12 but consider a daily proportion based on 355/no of days per month

So Jan-Mar the numerator is multiplied by 365/(31+28+30)

Hope this helps.

Elmarie

This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.

On 21 Jul 2017 3:21 PM, “vunda limbe” vundalon@gmail.com wrote:

Yes It is,

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

On Fri, Jul 21, 2017 at 1:16 PM, Shurajit Dutta shurajitdutta@gmail.com wrote:

Hi Vunda

Also is the aggregation operator for the population data element set to average (sum in org unit hierarchy)?

On Jul 21, 2017 7:20 PM, “vunda limbe” vundalon@gmail.com wrote:

Hi Community and Developer,

I have a population DE that helps to capture population Annually and I have some indicators that use its and those are set to be annualized. I’ve made a constatation that the result is different compared to excel sheet, and DHIS2 doesn’t dividing annual population by 12 for monthly report.

This is a bug or am I walking wrong side?

Your help is welcome.

Thanks.

Vunda Limbe

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

1 Like