dhis2-users team mailing list archive

["Friedman, Roger (CDC/CGH/DGHA) (CTR)" <rdf4@xxxxxxx>]

It would be useful if we could have a “hidden” hierarchy for census-type data (population, area, income) so that we could build catchment areas from smaller census units without them appearing in selection trees and tables unless specifically requested.

 

From: dhis2-users-bounces+rdf4=cdc.gov@xxxxxxxxxxxxxxxxxxx [mailto:dhis2-users-bounces+rdf4=cdc.gov@xxxxxxxxxxxxxxxxxxx] On Behalf Of Ola Hodne Titlestad
Sent: Thursday, May 12, 2011 3:16 AM
To: Jason Pickering
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] Advice on Population denominators

 

On 11 May 2011 21:18, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:

Hi Randy,

We have a similar situation in Zambia. We pre-projected the population
figures for 2000-2010 (from the 2000 census) using growth figures, and
then inserted these as normal data elements in the DHIS 2 database.
AFAIK, DHIS 2 has no ability to "project" data in the manner which you
describe. We used external statistical programs, followed by data
transformation and import to accomplish this task.

I have filed a blueprint on this topic...

https://blueprints.launchpad.net/dhis2/+spec/data-projection

In regards to the use of percentages for different populations, this
should be possible through the use of indicators. If you have a base
population and a factor for pregnant women, you would need to enter
both the population and factor as data elements. The combination of
the two could then be used as a denominator for instance in ANC
calculations.


Hi Randy,
 

I would just enter the factor as a static number into the formula itself. No need to create a data element and enter values for it.
E.g. "Total Population" * 0.041 in the denominatior expression for Population <1 y will give the desired 4.1% of total population.

Also note that when using a data element (and data values) to put the factor it will be aggregated like any other data element, which you don't want.
 

	
	I think the best way would be to pre-project the population figures
	for each year and the factors (pregnant women, WPA, etc) and import
	these for each organisational unit by year into DHIS 2. Then, you can
	use this as the basis for calculations for indicators. This is the
	procedure we use in Zambia, and it works fine.

Agree with this. Projection inside DHIS is not supported and for now you will have to enter values for each year.
 
Ola
-----

	
	Regards,
	Jason

	
	
	
	On Wed, May 11, 2011 at 8:56 PM, Wilson,Randy <rwilson@xxxxxxx> wrote:

	> We’ve been setting up DHIS-2 as a health data warehouse and dashboard for
	> Rwanda.  So far it has gone well, but I have found no useful documentation
	> about how to manage admin unit target populations … crucial for any coverage
	> indicator calculations.
	>
	>
	>
	> Ideally we’d like to store the populations once per org unit – for example
	> at the year of the national census – and then have a table of parameters
	> such as population growth rate, and breakdowns of % population in each of
	> the major programmatic target groups (e.g. 4.1% expected pregnancies &
	> children <1, 23.6% women of reproductive age, etc..) that can be pulled into
	> indicator calculations.  I’ve tried to create these parameters as data
	> elements, but I can’t seem to use them successfully in the indicator
	> definition screens, nor do I have any idea where the population data should
	> be stored.
	>
	>
	>
	> Has anyone done this before?
	>
	>
	>
	> Randy Wilson
	>

	> _______________________________________________
	> Mailing list: https://launchpad.net/~dhis2-users <https://launchpad.net/%7Edhis2-users> 
	> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
	> Unsubscribe : https://launchpad.net/~dhis2-users <https://launchpad.net/%7Edhis2-users> 
	> More help   : https://help.launchpad.net/ListHelp
	>
	>
	
	
	
	--

	Jason P. Pickering
	email: jason.p.pickering@xxxxxxxxx
	tel:+260974901293

	
	_______________________________________________
	Mailing list: https://launchpad.net/~dhis2-users <https://launchpad.net/%7Edhis2-users> 
	Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
	Unsubscribe : https://launchpad.net/~dhis2-users <https://launchpad.net/%7Edhis2-users> 
	More help   : https://help.launchpad.net/ListHelp