dhis2-devs team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

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