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.hispviet...@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.hispviet...@gmail.com > > > On Tue, Aug 26, 2014 at 9:27 AM, sumudu weerasinghe <sumudu...@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 >> >> >
_______________________________________________ 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