Beneficiary aggregation issues

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

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

  1. Create a DataElement group for Aggregate DE with name as “Blood Test DE group”

I***nto Datasets menu:***

  1. Create a dataset with name as “Blood Test Dataset

Into Beneficiary and Program menu :

  1. Create a program with name “Blood Test Program

  2. Create one stage for this program with name “Blood Test Stage” and add****“Blood Test” dataelement for this stage.

Into Beneficiary menu:

  1. 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 :

  1. Create a condition to count the total number of tests performed with name “***Total number ***QueryBuilder” into “Total number” aggregate data elements.

  2. 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,

  1. Enter PatientDataValue for DE “Blood Test” of Beneficiary First is “Yes

  2. Enter PatientDataValue for DE “Blood Test” of Beneficiary Second is “No

  3. Enter PatientDataValue for DE “Blood Test” of Beneficiary Third is “Yes

Note: Choose the Report - Date for all is “2011-02-23

  1. 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:

···

---------- Forwarded message ----------
From: Chau Thu Tran tran.hispvietnam@gmail.com

Date: Wed, Feb 23, 2011 at 7:34 AM
Subject: Re: [Dhis2-devs] Beneficiary aggregation issues
To: danieljbridges@gmail.com
Cc: Lars Helge Øverland larshelge@gmail.com, John lewis johnlewis.hisp@gmail.com, bharath kumar chbharathk@gmail.com

Name
Value
Status

1
Total positive
2.0
Updated in February 2011
2
Total number
3.0
Updated in February 2011


I sent the database which I create to test. Please enclose the attachment file :slight_smile:


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@gmail.com

2011/2/23 Lars Helge Øverland larshelge@gmail.com

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@gmail.com
Date: Tue, Feb 22, 2011 at 11:30 AM
Subject: [Dhis2-devs] Beneficiary aggregation issues

To: DHIS 2 developers dhis2-devs@lists.launchpad.net

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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Regards,
Bharath Kumar. Ch