Manual aggregation -In accurate aggregation

Dear All,

I have customized DHIS2 for mental health information system and started pilot. I used both tracker module(for clinic register) and aggregate part (for monthly return). After one month i try to fill the monthly return by manual aggregation using created aggregate query builders.

Clinic X has 180 total patient July 2014 and up to today(26/8/2014) 264 total new patients.

But in manual aggregation, run on 26/8/2014 shows 264 patients for the July instead of 180. Also New patient -male <12 should be 18 but it shows 28 , System does not give any error massage.

(“Total new patient” is dataelement created with age and gender category combination)

I will attach screen shot of my Aggregate query builder (for new male patient <12).

  • Is this error is due mistake done at query builder designing ? or
  • Error in the system ?
    My system detail as follows
  • DHIS version 2.15 revision - 15201
  • Database MySQL Server 5.1
  • Java jdk1.7.0_04
  • server apache-tomcat-7.0.50
    Regards

Sumudu

image

image

image

Hi Sumudu,

In your aggregate query formula, the formula does not have the type of date information. The type of period information are ‘registered’/‘enrolled’/‘visited’.

When we run the ‘Manual Aggregation’, it asks you the date range.

The formula needs to use that date range to check against the patient’s ‘registered’/‘enrolled’/‘visited’ date.

Currently, you didn’t specify any of those date type of patients, so it is getting all the patients from the clinic.

If ‘enrollment’ date is what you want (for July and August), try below.

[CA:9] is not null and [CA:3]=‘FEMALE’ and [CA:7] <= 12 and [PG:x]

  • In which x is the health program id. ‘[PG:x]’ means within the program enrollment date range. You can see the snapshot in attachment file.

image

···

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 26, 2014 at 9:27 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:

Dear All,

I have customized DHIS2 for mental health information system and started pilot. I used both tracker module(for clinic register) and aggregate part (for monthly return). After one month i try to fill the monthly return by manual aggregation using created aggregate query builders.

Clinic X has 180 total patient July 2014 and up to today(26/8/2014) 264 total new patients.

But in manual aggregation, run on 26/8/2014 shows 264 patients for the July instead of 180. Also New patient -male <12 should be 18 but it shows 28 , System does not give any error massage.

(“Total new patient” is dataelement created with age and gender category combination)

I will attach screen shot of my Aggregate query builder (for new male patient <12).

  • Is this error is due mistake done at query builder designing ? or
  • Error in the system ?
    My system detail as follows
  • DHIS version 2.15 revision - 15201
  • Database MySQL Server 5.1
  • Java jdk1.7.0_04
  • server apache-tomcat-7.0.50
    Regards

Sumudu


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

Thanks Tran .
Yes it was a problem in my query , it is now working after adding program id , now it aggregate according to time period.

Sumudu

···

On Wed, Aug 27, 2014 at 7:21 PM, Tran Chau tran.hispvietnam@gmail.com wrote:

Hi Sumudu,

In your aggregate query formula, the formula does not have the type of date information. The type of period information are ‘registered’/‘enrolled’/‘visited’.

When we run the ‘Manual Aggregation’, it asks you the date range.

The formula needs to use that date range to check against the patient’s ‘registered’/‘enrolled’/‘visited’ date.

Currently, you didn’t specify any of those date type of patients, so it is getting all the patients from the clinic.

If ‘enrollment’ date is what you want (for July and August), try below.

[CA:9] is not null and [CA:3]=‘FEMALE’ and [CA:7] <= 12 and [PG:x]

  • In which x is the health program id. ‘[PG:x]’ means within the program enrollment date range. You can see the snapshot in attachment file.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 26, 2014 at 9:27 AM, sumudu weerasinghe sumuduw00@gmail.com wrote:

Dear All,

I have customized DHIS2 for mental health information system and started pilot. I used both tracker module(for clinic register) and aggregate part (for monthly return). After one month i try to fill the monthly return by manual aggregation using created aggregate query builders.

Clinic X has 180 total patient July 2014 and up to today(26/8/2014) 264 total new patients.

But in manual aggregation, run on 26/8/2014 shows 264 patients for the July instead of 180. Also New patient -male <12 should be 18 but it shows 28 , System does not give any error massage.

(“Total new patient” is dataelement created with age and gender category combination)

I will attach screen shot of my Aggregate query builder (for new male patient <12).

  • Is this error is due mistake done at query builder designing ? or
  • Error in the system ?
    My system detail as follows
  • DHIS version 2.15 revision - 15201
  • Database MySQL Server 5.1
  • Java jdk1.7.0_04
  • server apache-tomcat-7.0.50
    Regards

Sumudu


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