Re: [Dhis2-users] Advice on Population denominators

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 describ

Re: [Dhis2-users] Advice on Population denominators

Thanks Wilson for sharing. I hope kenya approarch can assist to address your need. In addressing population as denominator you require to consider the aggregation level either you want health facilities to input their catchment population and aggreated upwards to get national aggregate. Note:- thi

[Dhis2-users] Advice on Population denominators

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

Re: [Dhis2-users] Days per period

SQL views in DHIS2 only allow SELECT statements, but one can define a custom Procedural SQL function (Called through a SELECT statement), which could perform an update statement. Otherwise, you can completely go outside of DHIS2, and use something like PGAgent to perform these custom tasks on a sch

Re: [Dhis2-users] Days per period

On 11 May 2011 11:19, Friedman, Roger (CDC/CGH/DGHA) (CTR) wrote: > What I hear you saying is that we can get this in a report table but not in > an indicator calculation or validation expression. > > I think it will be a lot easier for you to use the normal approach of defining indicators and rep

Re: [Dhis2-users] Days per period

PEPELA WANJALAMINISTRY OF HEALTH HEADQUARTERSHEALTH INFORMATION SYSTEMAFYA HOUSE, HIS LG 37P.O BOX 30016, NAIROBI, KENYATEL: +254 (020) 2717077 EXT 45097CELL: +254 (0) 722375633 or 0202033363EMAIL: wanjal...@yahoo.com    h...@health.go.ke  --- On Wed, 5/11/11, Friedman, Roger (CDC/CGH

Re: [Dhis2-users] Days per period

Dear Roger, What is required is to make the Bed Occupancy as an indicator and a table can be made to work behind. see the attched table PEPELA WANJALAMINISTRY OF HEALTH HEADQUARTERSHEALTH INFORMATION SYSTEMAFYA HOUSE, HIS LG 37P.O BOX 30016, NAIROBI, KENYATEL: +254 (020) 2717077 EXT 45097CELL:

Re: [Dhis2-users] Days per period

What I hear you saying is that we can get this in a report table but not in an indicator calculation or validation expression. Also, my recollection is that custom SQL view only allows select statements, so we can't use it to update a hidden data element, right? And we could muck with the Hibe

Re: [Dhis2-users] Days per period

Already on the roadmap for next release for June 10: https://blueprints.launchpad.net/dhis2/+spec/extended-indicator-engine On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR) < r...@cdc.gov> wrote: > Listers -- >We need to calculate bed occupancy rates. We have the num

Re: [Dhis2-users] Days per period

Hi Roger, This functionality is on the roadmap for the next release: https://blueprints.launchpad.net/dhis2/+spec/extended-indicator-engine We definitely need to support this as part of the indicator functionality and cannot

Re: [Dhis2-users] Days per period

It would be available through a pretty trivial SQL statement if you are calculating this on an external report. SELECT periodid, enddate-startdate as nbr_days FROM period in Postgresql will give you the number of days in a given period along with the periodid. you could then join this to the aggre

[Dhis2-users] Days per period

Listers -- We need to calculate bed occupancy rates. We have the number of beds per ward and the number of person-days of bed use per month, but we need the number of days per month. Is that available in some way from the system or are we going to have to key it? Thanks, Roger __