---------- Forwarded message ---------- From: Chau Thu Tran <[email protected]> Date: Wed, Feb 23, 2011 at 7:34 AM Subject: Re: [Dhis2-devs] Beneficiary aggregation issues To: [email protected] Cc: Lars Helge Øverland <[email protected]>, John lewis < [email protected]>, bharath kumar <[email protected]>
Hi Daniel, Sorry about replying late. I created a database according your idea to test. *Into Data Element menu :* 1. Create 3 dataelement: - *Blood Test *with Domain as "*Patient*" - *Total number *and *Total positive* with Domain as "*Aggregate*" 2. Create a DataElement group for Aggregate DE with name as "Blood Test DE group" I*nto Datasets menu:* 3. Create a dataset with name as "*Blood Test Dataset*" *Into Beneficiary and Program menu :* 4. Create a program with name "*Blood Test Program*" 5. Create one stage for this program with name "*Blood Test Stage*" and add* *"*Blood Test*" dataelement for this stage. *Into Beneficiary menu:* 5. Create 3 Beneficiaries, include :* Beneficiary First, Beneficiary Second, Beneficiary Third* for orgunit *Ho Chi Minh City *and enroll them into Blood Test Program. *Into Beneficiary Aggregation QueryBuilder menu :* 6. Create a condition to count the total number of tests performed with name "*Total number **QueryBuilder*" into "Total number" aggregate data elements. 7. Create a condition to count the number of positives (yes only) with name "*Total positive QueryBuilder*" into *"Total positive"* aggregate data elements. *Into Name-Based Data Records,* 8. Enter PatientDataValue for DE "Blood Test" of Beneficiary First is "*Yes* " 9. Enter PatientDataValue for DE "Blood Test" of Beneficiary Second is "*No* " 10. Enter PatientDataValue for DE "Blood Test" of Beneficiary Third is "*Yes *" Note:* Choose the **Report - Date** for all is "**2011-02-23**"* 11. Click Case Aggregation menu, 11.1. Select *Blood Test Dataset* into Dataset List 11.2. Select Period from *January 2011 to February 2011* 11.3. Select Orgunit "*Ho Chi Minh City*" 11.4. Click "Aggregate" button --> The result as follows: # Name Value Status 1 Total positive2.0 Updated in February 20112 Total number3.0Updated in February 2011 ------ I sent the database which I create to test. Please enclose the attachment file :) ------ Into the step 6, to create a condition, we have to create dataelement-groups includes aggregate dataelements before. However, when run the conditions to get datavalues, we have to use datasets, not dataelement-groups. Best regards, ------------------------------------------------ Châu Thu Trân HISP Viet Nam Email: [email protected] 2011/2/23 Lars Helge Øverland <[email protected]> > Hi peoples, > > whats the status of the aggregation of patient data to routine data? Can > someone reply to this man? > > Lars > > > ---------- Forwarded message ---------- > From: Daniel Bridges <[email protected]> > Date: Tue, Feb 22, 2011 at 11:30 AM > Subject: [Dhis2-devs] Beneficiary aggregation issues > To: DHIS 2 developers <[email protected]> > > > Hi there, > > Am new to DHIS2 and need some help with understanding how beneficiary > aggregation works / how to set it up. At the moment I am using a very > simple database with 3 people who have been enrolled in a program with a > single program stage that consists of a blood test. The patient data > element for this test is a simple 'yes / no' correlating to whether the > test was positive or not. I now want to count the total number of tests > performed (either yes or no) and the number of positives (yes only) into > two aggregate data elements ('Total number' and 'Total positive'). I > therefore created two separate aggregation query builders with the > following condition (where [DE:36.35.13] is the blood test program > stage data element): > > [DE:36.35.13] > [DE:36.35.13] = yes > > I thought that I could then click on a button and the data would be > aggregated and populate the correct data elements. However I see I need > to set-up a dataset to even try and aggregate. I therefore set-up a > dataset with the yes/no blood test patient data element. Selecting all > the weeks available and clicking on aggregate gave the message 'No > values added or updated' > > I know that I am doing something majorly wrong, but can't for the life > of me work it out. Any general advice would be very gratefully received. > Am happy to supply more info if I haven't been clear on anything.... > > I am using DHIS2.1-snapshot on linux. > > Thanks in advance > Dan > -- > This message was sent from Launchpad by > Daniel Bridges (https://launchpad.net/~danieljbridges) > to each member of the DHIS 2 Users team using the "Contact this team" link > on the DHIS 2 Users team page (https://launchpad.net/~dhis2-users). > For more information see > https://help.launchpad.net/YourAccount/ContactingPeople > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Regards, Bharath Kumar. Ch
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
