dhis2-devs team mailing list archive

[Tran Chau <tran.hispvietnam@xxxxxxxxx>]

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@xxxxxxxxx


On Tue, Aug 26, 2014 at 9:27 AM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

Attachment: Agg formula.jpg
Description: JPEG image