Hi Knut,
Although I can see that program indicators can be helpful it has limited use in the context of interoperability between DHIS2 instances. In South Africa we feel that Survey type instances should be kept separate from Routine Health data collection and as such collect event or tracker data for surveys and would want to set up aggregated data elements in the system which populates with a stored aggregated data value which we export/synchronise with the routine HMIS system e.g. Patient satisfaction survey rate = No of surveys conducted/No of facilities Patient satisfaction rate = No of satisfied responses/All responses It is true that these aggregated elements can be populated with a function called via a sql view or cron job but not the most ideal. Up to now I have not figured out how to set up an indicator which counts if there was any surveys done in a specific period by adding a program indicator due to the limited amount of mathematical calculation formulae allowed in the Program Indicator engine. This said I must say that we don’t have much confidence in the accuracy of the Aggregation Query Builder as it is at the moment because there seems to be a ceiling limit on how many values can actually be inserted by running a scheduled or manual aggregation process and the simultaneous initiation of scheduled Aggregation Query builder and Analytics are problematic. For this reason we are checking the output of the Aggregation Query builder at this stage and when not entirely confident that it produces reliable results we are using functions instead. Regards, Elmarie Claasen Hisp logo Project Manager Health Information Systems Program Tel: 041-367 1027 Cell: 082 374 2209 E-mail: <mailto:elma...@hisp.org> elma...@hisp.org Skype: elmarie.claasen52 This message and any attachments are subject to a disclaimer published at <http://www.hisp.org/policies.html#comms_disclaimer> http://www.hisp.org/policies.html#comms_disclaimer . Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to <mailto:disclai...@hisp.org> disclai...@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer. From: Dhis2-users [mailto:dhis2-users-bounces+elmarie=hisp....@lists.launchpad.net] On Behalf Of Dipali Sahu Sent: 26 November 2015 12:49 PM To: Knut Staring Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] Aggregation query builder details Hi Knut We actually use Aggregation query builder to a large extent to get aggregated data. Exclusively, all our data is captured through Event capture, and we aggregate it through Aggregation query builder, so that the aggregated values can be shown in datasets as well as Pivot tables. Also, using Pivot tables with data elements is easier for the end users since they there is flexibility to can slice and dice the data with categories under Pivot tables. Don't you think aggregation with only program indicators will limit the use of categories and therefore easy visualization under pivot tables. Thank you Deepali International Medical Corps On Wed, Nov 25, 2015 at 11:34 AM, Knut Staring <knu...@gmail.com> wrote: Hi Nami, Which version of DHIS2 are you working on? We are phasing out the aggregation query builder in favor of program indicators. Knut On Tue, Nov 24, 2015 at 5:45 PM, Nami Ghadri <nami_gha...@hotmail.com> wrote: Hello, I want to create an Aggregation query builder details as sum of data element value I put everything but it comes to Data element for sum/average/min/max * and try to select I can’t find anything and this field is mandatory and the data aggregator data element and tracker data element both has sum aggregator Any idea about this Thanks in advance _______________________________________________ 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 -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 <tel:%2B4791880522> Skype: knutstar http://dhis2.org _______________________________________________ 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 -- *This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer <http://www.hisp.org/policies.html#comms_disclaimer>. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclai...@hisp.org <disclai...@hisp.org> and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.*
_______________________________________________ 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