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:ptb3...@gmail.com] Sent: Thursday, August 4, 2016 1:13 AM To: Stephen Macauley <stephen.macau...@inductivehealth.com> Cc: Morten Olav Hansen <mor...@dhis2.org>; dhis2-users@lists.launchpad.net; dhis2-d...@lists.launchpad.net 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.macau...@inductivehealth.com<mailto:stephen.macau...@inductivehealth.com>> wrote: Version 2.22 Build 21809 -Stephen From: Morten Olav Hansen [mailto:mor...@dhis2.org<mailto:mor...@dhis2.org>] Sent: Wednesday, August 3, 2016 2:02 PM To: Stephen Macauley <stephen.macau...@inductivehealth.com<mailto:stephen.macau...@inductivehealth.com>> Cc: dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>; dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> 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.macau...@inductivehealth.com<mailto:stephen.macau...@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-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>' <dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net>>; dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Cc: Daniel Wages (daniel.wa...@inductivehealth.com<mailto:daniel.wa...@inductivehealth.com>) <daniel.wa...@inductivehealth.com<mailto:daniel.wa...@inductivehealth.com>> 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: step...@inductivehealth.com<mailto:stephen.macau...@inductivehealth.com> _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net<mailto:dhis2-d...@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> 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 pros...@hispuganda.org<mailto:ptb3...@gmail.com> | pros...@dhis2.org<mailto:pros...@dhis2.org> | Skype: prospertb
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
