← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Make aggregate query builder with algebra functions

 

we want to make proof number or exact number from DHIS2 system for
reporting. so it is easy for evaluation and audit staff understand what we
did in DHIS2 system.

On Tue, Mar 10, 2015 at 10:44 AM, Shurajit Dutta <shurajitdutta@xxxxxxxxx>
wrote:

> Are you willing to use a compulsory tracker data element as a proxy for
> registrations?
> On Mar 9, 2015 6:23 PM, "rin.channara@xxxxxxxxx" <rin.channara@xxxxxxxxx>
> wrote:
>
>> Good idea, but can you guide how to get total of patient who registered
>> program in aggregate query builder.
>>
>> Shurajit Dutta <shurajitdutta@xxxxxxxxx> wrote:
>>
>> Hi Channara
>>
>> I think you can make two aggregate data elements, one for total and one
>> for those who died, and link them using the builder then make an indicator
>> out of the aggregate DEs you have created.
>>
>> Nick
>> On Mar 9, 2015 4:03 PM, "channara rin" <rin.channara@xxxxxxxxx> wrote:
>>
>>> Hi All DHIS2,
>>> Do you know how can i do aggregate query builder with algebra functions?
>>> Example: i would to know total number of patient in registration program
>>> and minus the patient who dead.
>>> SO i want to use aggregate query builder to aggregate and put the number
>>> into Data element that i created already is the "number patient who are
>>> still alive in this period"
>>>
>>>
>>> Can any one help me, how the DHIS2 can do like this?
>>>
>>> Thank you
>>> CHANNARA
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>

Follow ups

References