dhis2-devs team mailing list archive

[bharath kumar <chbharathk@xxxxxxxxx>]

---------- Forwarded message ----------
From: Chau Thu Tran <tran.hispvietnam@xxxxxxxxx>
Date: Wed, Feb 23, 2011 at 7:34 AM
Subject: Re: [Dhis2-devs] Beneficiary aggregation issues
To: danieljbridges@xxxxxxxxx
Cc: Lars Helge Øverland <larshelge@xxxxxxxxx>, John lewis <
johnlewis.hisp@xxxxxxxxx>, bharath kumar <chbharathk@xxxxxxxxx>



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: tran.hispvietnam@xxxxxxxxx


2011/2/23 Lars Helge Øverland <larshelge@xxxxxxxxx>


> 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 <danieljbridges@xxxxxxxxx>
> Date: Tue, Feb 22, 2011 at 11:30 AM
> Subject: [Dhis2-devs] Beneficiary aggregation issues
> To: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>
>
> 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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>



-- 

Regards,
Bharath Kumar. Ch