dhis2-devs team mailing list archive

[Prosper BT <ptb3000@xxxxxxxxx>]

Your assumption is right,

For all data elements in the stage, its based on Report date while for
attributes queries uses the registration date.

Regards

On Thu, Aug 4, 2016 at 3:02 PM, Stephen Macauley <
Stephen.Macauley@xxxxxxxxxxxxxxxxxxx> wrote:

> Thank you Prosper for your insights.
>
>
>
> One follow-up question, what date variable is used (my assumption is
> Report Date) to allocate the Tracker Capture instance (i.e., the patient)
> to the correct month used in your example?
>
>
>
> -Stephen
>
>
>
> *From:* Prosper BT [mailto:ptb3000@xxxxxxxxx]
> *Sent:* Thursday, August 4, 2016 1:13 AM
> *To:* Stephen Macauley <Stephen.Macauley@xxxxxxxxxxxxxxxxxxx>
> *Cc:* Morten Olav Hansen <morten@xxxxxxxxx>; dhis2-users@lists.launchpad.
> net; dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] [Dhis2-devs] 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@
> inductivehealth.com> 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@
> inductivehealth.com> 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
>



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