# Make aggregate query builder with algebra functions

Good idea, but can you guide how to get total of patient who registered program in aggregate query builder.

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

···

Shurajit Dutta shurajitdutta@gmail.com wrote:

On Mar 9, 2015 4:03 PM, “channara rin” rin.channara@gmail.com 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

Are you willing to use a compulsory tracker data element as a proxy for registrations?

···

On Mar 9, 2015 6:23 PM, “rin.channara@gmail.comrin.channara@gmail.com wrote:

Good idea, but can you guide how to get total of patient who registered program in aggregate query builder.

Shurajit Dutta shurajitdutta@gmail.com 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@gmail.com 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

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@gmail.com 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@gmail.comrin.channara@gmail.com wrote:

Good idea, but can you guide how to get total of patient who registered program in aggregate query builder.

Shurajit Dutta shurajitdutta@gmail.com 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@gmail.com 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

Any idea why some of the event reports on the demo site do not run? Is there a chance to rectify them?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 11295 (20150310) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Hi Simon,

the demo database does not have events after Feb 2015, we will fix this.

Lars

···

On Tue, Mar 10, 2015 at 6:47 AM, Simon Muyambo smmuyambo@gmail.com wrote:

Any idea why some of the event reports on the demo site do not run? Is there a chance to rectify them?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 11295 (20150310) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Lars thanks for fixing the reports. I still have problems running the Top Ten diseases reports from events reports favourates

Regards

Simon Muyambo

···

From: Lars Helge Øverland [mailto:larshelge@gmail.com]
Sent: 10 March 2015 10:27
To: Simon Muyambo
Cc: DHIS 2 Developers list; dhis1-users
Subject: Re: [Dhis2-devs] Event reports on DEMO site

Hi Simon,

the demo database does not have events after Feb 2015, we will fix this.

Lars

On Tue, Mar 10, 2015 at 6:47 AM, Simon Muyambo smmuyambo@gmail.com wrote:

Any idea why some of the event reports on the demo site do not run? Is there a chance to rectify them?

Regards

Simon Muyambo

__________ Information from ESET NOD32 Antivirus, version of virus signature database 11295 (20150310) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com