← Back to team overview

dhis2-devs team mailing list archive

Re: Org Unit count

 

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@xxxxxxxxx> 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@xxxxxxxxx]
> *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@xxxxxxxxx> 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@xxxxxxxxx]
> *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@xxxxxxxxx> 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@xxxxxxxxx]
> *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@xxxxxxxxx> 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@xxxxxxxxx]
> *Sent:* Tuesday, November 10, 2015 11:41 AM
> *To:* Mugeni Harold
> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx; 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxx
> 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 <https://www.dhis2.org>
>
>
>
>
>
>
>
> --
>
> Lars Helge Øverland
>
> Lead developer, DHIS 2
>
> University of Oslo
>
> Skype: larshelgeoverland
>
> http://www.dhis2.org <https://www.dhis2.org>
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

References