Org Unit count (indicator)

Mugeni_Harold · 10 November 2015 09:31

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

Alex_Tumwesigye · 10 November 2015 09:41

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

···

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Mugeni_Harold · 10 November 2015 09:46

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

···

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Lars · 10 November 2015 10:31

Hi Mugeni,

here is a guess: You need to use a group for your indicator which contains facilities only, not facilities and districts. I suspect you are using an org unit group which contains the districts as well.

regards,

Lars

···

On Tue, Nov 10, 2015 at 10:46 AM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Mugeni_Harold · 10 November 2015 11:37

Hi Lars,

I am not using an org unit group. The hierarchy of my instance is as follows:- MoH, Zone, District, Health Facility. Now for this particular indicator which is supposed to calculate the percentage of health facilities that have a functional water supply or a functional communication system or electricity (each of these is its own indicator), there are data elements reporting the number of health facilities with either water or communication or electricity. These data elements would serve as the numerators. For the denominator, I need to be able to retrieve the number of health facilities in that particular district. So what I am doing is actually selecting the district, but the result I am getting is always with an extra 1 added to it.

Harold

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 12:32 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Hi Mugeni,

here is a guess: You need to use a group for your indicator which contains facilities only, not facilities and districts. I suspect you are using an org unit group which contains the districts as well.

regards,

Lars

On Tue, Nov 10, 2015 at 10:46 AM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Lars · 10 November 2015 11:51

Okay, but what does your indicator denominator look like? Can you post the exact formula?

There is no such thing as a general org unit count - you can insert the count of org units within a group into the formula.

regards,

Lars

···

On Tue, Nov 10, 2015 at 12:37 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Lars,

I am not using an org unit group. The hierarchy of my instance is as follows:- MoH, Zone, District, Health Facility. Now for this particular indicator which is supposed to calculate the percentage of health facilities that have a functional water supply or a functional communication system or electricity (each of these is its own indicator), there are data elements reporting the number of health facilities with either water or communication or electricity. These data elements would serve as the numerators. For the denominator, I need to be able to retrieve the number of health facilities in that particular district. So what I am doing is actually selecting the district, but the result I am getting is always with an extra 1 added to it.

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 12:32 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers

Subject: Re: [Dhis2-devs] Org Unit count

Hi Mugeni,

here is a guess: You need to use a group for your indicator which contains facilities only, not facilities and districts. I suspect you are using an org unit group which contains the districts as well.

regards,

Lars

On Tue, Nov 10, 2015 at 10:46 AM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Mugeni_Harold · 10 November 2015 12:37

The formula (using functional water) is;-

(Number of health facilities with functioning water at the facility / Number of health facilities in the catchment area) * 100

Harold

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 1:51 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Okay, but what does your indicator denominator look like? Can you post the exact formula?

There is no such thing as a general org unit count - you can insert the count of org units within a group into the formula.

regards,

Lars

On Tue, Nov 10, 2015 at 12:37 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Lars,

I am not using an org unit group. The hierarchy of my instance is as follows:- MoH, Zone, District, Health Facility. Now for this particular indicator which is supposed to calculate the percentage of health facilities that have a functional water supply or a functional communication system or electricity (each of these is its own indicator), there are data elements reporting the number of health facilities with either water or communication or electricity. These data elements would serve as the numerators. For the denominator, I need to be able to retrieve the number of health facilities in that particular district. So what I am doing is actually selecting the district, but the result I am getting is always with an extra 1 added to it.

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 12:32 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers

Subject: Re: [Dhis2-devs] Org Unit count

Hi Mugeni,

here is a guess: You need to use a group for your indicator which contains facilities only, not facilities and districts. I suspect you are using an org unit group which contains the districts as well.

regards,

Lars

On Tue, Nov 10, 2015 at 10:46 AM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

jason · 10 November 2015 12:56

So how is “Number of health facilities in the catchment area” populated? Do people enter this data or is it populated with some script? As Lars says, DHIS2 will not calculate this somehow automatically, so it must be coming from somewhere,either by data entry or population by an external script.

Regards,

Jason

···

On Nov 10, 2015 13:37, “Mugeni Harold” hmugeni@gmail.com wrote:

The formula (using functional water) is;-

(Number of health facilities with functioning water at the facility / Number of health facilities in the catchment area) * 100

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 1:51 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Okay, but what does your indicator denominator look like? Can you post the exact formula?

There is no such thing as a general org unit count - you can insert the count of org units within a group into the formula.

regards,

Lars

On Tue, Nov 10, 2015 at 12:37 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Lars,

I am not using an org unit group. The hierarchy of my instance is as follows:- MoH, Zone, District, Health Facility. Now for this particular indicator which is supposed to calculate the percentage of health facilities that have a functional water supply or a functional communication system or electricity (each of these is its own indicator), there are data elements reporting the number of health facilities with either water or communication or electricity. These data elements would serve as the numerators. For the denominator, I need to be able to retrieve the number of health facilities in that particular district. So what I am doing is actually selecting the district, but the result I am getting is always with an extra 1 added to it.

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 12:32 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers

Subject: Re: [Dhis2-devs] Org Unit count

Hi Mugeni,

here is a guess: You need to use a group for your indicator which contains facilities only, not facilities and districts. I suspect you are using an org unit group which contains the districts as well.

regards,

Lars

On Tue, Nov 10, 2015 at 10:46 AM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

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

Mugeni_Harold · 10 November 2015 13:04

For ‘Number of health facilities in the catchment area’, I was thinking of using the Organisation Unit Counts functionality found in the Indicator numerator and denominator windows. But the problem is when I sue that, the count always returns a value higher by 1, than expected.

Harold

···

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Tuesday, November 10, 2015 2:57 PM
To: Mugeni Harold
Cc: dhis2-devs; Lars Helge Øverland; DHIS 2 Users list
Subject: Re: [Dhis2-devs] Org Unit count

So how is “Number of health facilities in the catchment area” populated? Do people enter this data or is it populated with some script? As Lars says, DHIS2 will not calculate this somehow automatically, so it must be coming from somewhere,either by data entry or population by an external script.

Regards,

Jason

On Nov 10, 2015 13:37, “Mugeni Harold” hmugeni@gmail.com wrote:

The formula (using functional water) is;-

(Number of health facilities with functioning water at the facility / Number of health facilities in the catchment area) * 100

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 1:51 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Okay, but what does your indicator denominator look like? Can you post the exact formula?

There is no such thing as a general org unit count - you can insert the count of org units within a group into the formula.

regards,

Lars

On Tue, Nov 10, 2015 at 12:37 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Lars,

I am not using an org unit group. The hierarchy of my instance is as follows:- MoH, Zone, District, Health Facility. Now for this particular indicator which is supposed to calculate the percentage of health facilities that have a functional water supply or a functional communication system or electricity (each of these is its own indicator), there are data elements reporting the number of health facilities with either water or communication or electricity. These data elements would serve as the numerators. For the denominator, I need to be able to retrieve the number of health facilities in that particular district. So what I am doing is actually selecting the district, but the result I am getting is always with an extra 1 added to it.

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 12:32 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers

Subject: Re: [Dhis2-devs] Org Unit count

Hi Mugeni,

here is a guess: You need to use a group for your indicator which contains facilities only, not facilities and districts. I suspect you are using an org unit group which contains the districts as well.

regards,

Lars

On Tue, Nov 10, 2015 at 10:46 AM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

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

jason · 10 November 2015 14:08

Right, so as Lars indicates, the likely cause of this is because your district and facilities are part of the same organization unit group. Can you confirm this is not the case? This is a very common mistake, and has been brought up

Also, you should probably not calculate the percentage directly in the indicator formula, but rather use an indicator type of “Percentage” and let DHIS2 perform the calculation to percentage for you.

Regards,

Jason

···

On Tue, Nov 10, 2015, 14:04 Mugeni Harold hmugeni@gmail.com wrote:

For ‘Number of health facilities in the catchment area’, I was thinking of using the Organisation Unit Counts functionality found in the Indicator numerator and denominator windows. But the problem is when I sue that, the count always returns a value higher by 1, than expected.

Harold

From: Jason Pickering [mailto:jason.p.pickering@gmail.com]
Sent: Tuesday, November 10, 2015 2:57 PM
To: Mugeni Harold
Cc: dhis2-devs; Lars Helge Øverland; DHIS 2 Users list

Subject: Re: [Dhis2-devs] Org Unit count

So how is “Number of health facilities in the catchment area” populated? Do people enter this data or is it populated with some script? As Lars says, DHIS2 will not calculate this somehow automatically, so it must be coming from somewhere,either by data entry or population by an external script.

Regards,

Jason

On Nov 10, 2015 13:37, “Mugeni Harold” hmugeni@gmail.com wrote:

The formula (using functional water) is;-

(Number of health facilities with functioning water at the facility / Number of health facilities in the catchment area) * 100

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 1:51 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Okay, but what does your indicator denominator look like? Can you post the exact formula?

There is no such thing as a general org unit count - you can insert the count of org units within a group into the formula.

regards,

Lars

On Tue, Nov 10, 2015 at 12:37 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Lars,

I am not using an org unit group. The hierarchy of my instance is as follows:- MoH, Zone, District, Health Facility. Now for this particular indicator which is supposed to calculate the percentage of health facilities that have a functional water supply or a functional communication system or electricity (each of these is its own indicator), there are data elements reporting the number of health facilities with either water or communication or electricity. These data elements would serve as the numerators. For the denominator, I need to be able to retrieve the number of health facilities in that particular district. So what I am doing is actually selecting the district, but the result I am getting is always with an extra 1 added to it.

Harold

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: Tuesday, November 10, 2015 12:32 PM
To: Mugeni Harold
Cc: Alex Tumwesigye; DHIS 2 Users list; DHIS 2 developers

Subject: Re: [Dhis2-devs] Org Unit count

Hi Mugeni,

here is a guess: You need to use a group for your indicator which contains facilities only, not facilities and districts. I suspect you are using an org unit group which contains the districts as well.

regards,

Lars

On Tue, Nov 10, 2015 at 10:46 AM, Mugeni Harold hmugeni@gmail.com wrote:

Hi Alex,

Yes, it seems to be doing that. Is that by design or is it a bug?

Harold

From: Alex Tumwesigye [mailto:atumwesigye@gmail.com]
Sent: Tuesday, November 10, 2015 11:41 AM
To: Mugeni Harold
Cc: dhis2-users@lists.launchpad.net; DHIS 2 developers
Subject: Re: [Dhis2-devs] Org Unit count

Dear Harold,

Sounds like it counts the root/parent organisation unit.

Alex

On Tue, Nov 10, 2015 at 12:31 PM, Mugeni Harold hmugeni@gmail.com wrote:

Hallo everyone,

I am working on some indicators that require number of org units under a given org unit e.g. number of health facilities under a district. I am using the org unit count under the indicator numerator or denominator section, but I have noticed that the count returned is always with an extra one i.e. where I expect 22 facilities, it is giving me 23. Is this a bug or something to do with the hierarchy?

Thank you,

Harold

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

–

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

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

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

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

JIMENEZ_POMARETA_Ram · 10 May 2019 08:40

Hello, for me the orgUnit count is not working, why is counting differnet ou for each year?

<indicator xmlns="http://dhis2.org/schema/dxf/2.0" code="OU_COUNT" lastUpdated="2019-05-    10T08:19:28.465" id="wetzIeKHzk9" href="https://play.dhis2.org/2.30/api/indicators/wetzIeKHzk9" created="2019-05-10T08:19:28.465" name="OU_COUNT" shortName="OU_COUNT">
<displayName>OU_COUNT</displayName>
<publicAccess>rw------</publicAccess>
<displayShortName>OU_COUNT</displayShortName>
<externalAccess>false</externalAccess>
<denominatorDescription>1</denominatorDescription>
<numeratorDescription>ou count</numeratorDescription>
<dimensionItem>wetzIeKHzk9</dimensionItem>
<numerator>OUG{CXw2yu5fodb}</numerator>
<denominator>1</denominator>
<annualized>false</annualized>
<favorite>false</favorite>
<dimensionItemType>INDICATOR</dimensionItemType>
<access>
<read>true</read>
<update>true</update>
<externalize>false</externalize>
<delete>true</delete>
<write>true</write>
<manage>true</manage>
</access>
<indicatorType id="JkWynlWMjJR"/>
<lastUpdatedBy id="xE7jOejl9FI"/>
<user id="xE7jOejl9FI"/>
</indicator>

jamiecarter7 · 12 February 2024 12:42

I am having a similar issue with differences in the number of facilities created and the org_unit_count figure

After doing some digging it seems like an org unit is only counted if it has at least 1 assigned patient. I am unsure if this is truly the reason but might help someone.