← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Confirming Data Variable Used to Calculate Period using Aggregation Query Builder

 

Dear Stephen,

The aggregate query builder aggregates data on a daily basis so you have
daily totals and depending on which period you choose to populate the in
the dataset, it will add up all the daily totals to the period of the
dataset. Say if you have monthly dataset being populated, it will add up
all the days in that month and produce your monthly report.

Then later in pivot tables all the data elements will have totals according
to the period and you can aggregate further upwards monthly to quarterly
etc..

But as Morten shared, the aggregate query builder has been dropped and
replaced with program indicators, so you may need to start thinking of
converting you queries to program indicators.

Regards

On Wed, Aug 3, 2016 at 9:04 PM, Stephen Macauley <
Stephen.Macauley@xxxxxxxxxxxxxxxxxxx> wrote:

> Version 2.22 Build 21809
>
>
>
> -Stephen
>
>
>
> *From:* Morten Olav Hansen [mailto:morten@xxxxxxxxx]
> *Sent:* Wednesday, August 3, 2016 2:02 PM
> *To:* Stephen Macauley <Stephen.Macauley@xxxxxxxxxxxxxxxxxxx>
> *Cc:* dhis2-devs@xxxxxxxxxxxxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-devs] Confirming Data Variable Used to Calculate
> Period using Aggregation Query Builder
>
>
>
> Hi,
>
>
>
> What version of DHIS2 are you on? aggregate query builder has been removed
> for a few releases, and replaced with event (aggregate) analytics
>
>
> --
>
> Morten Olav Hansen
>
> Senior Engineer, DHIS 2
>
> University of Oslo
>
> http://www.dhis2.org
>
>
>
> On Wed, Aug 3, 2016 at 7:51 PM, Stephen Macauley <
> Stephen.Macauley@xxxxxxxxxxxxxxxxxxx> wrote:
>
> Resubmitting the below question to solicit thoughts from the community.
>
>
>
> Thanks in advance,
>
> -Stephen
>
>
>
> *From:* Stephen Macauley
> *Sent:* Tuesday, August 2, 2016 8:20 AM
> *To:* 'dhis2-devs@xxxxxxxxxxxxxxxxxxx' <dhis2-devs@xxxxxxxxxxxxxxxxxxx>;
> dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Cc:* Daniel Wages (daniel.wages@xxxxxxxxxxxxxxxxxxx) <
> daniel.wages@xxxxxxxxxxxxxxxxxxx>
> *Subject:* Confirming Data Variable Used to Calculate Period using
> Aggregation Query Builder
>
>
>
> All,
>
>
>
> Wanted to confirm that when Aggregation Query Builder runs against Tracker
> Capture data, that the Report Date variable is used to determine the Period
> for populating the corresponding Data Entry form.
>
>
>
> For purposes of this question, assume that the Tracker Capture Program
> only has 1 Program Stage.
>
>
>
> Thanks in advance,
>
> -Stephen
>
>
>
> --
>
> *Stephen Macauley*
>
> e: stephen@xxxxxxxxxxxxxxxxxxx <stephen.macauley@xxxxxxxxxxxxxxxxxxx>
>
>
>
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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
>
>


-- 
Prosper Behumbiize, MPH
Global DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139
prosper@xxxxxxxxxxxxxx <ptb3000@xxxxxxxxx> | prosper@xxxxxxxxx | Skype:
prospertb

Follow ups

References