Hi, just wanted to add my voice in support for improving (e.g. making it faster and more reliable, supporting cohort analysis etc), rather than removing the aggregation query builder. While I think the program indicators are great, I think there are many cases where you would rather want to store the aggregate data.
One case I think is highly relevant (in the sense that countries are doing it now) is where you have some facilities reporting via tracker and other on paper/aggregate, and you would want the data to end up in the same data elements/data sets. Olav > 26. nov. 2015 kl. 23.01 skrev Knut Staring <knu...@gmail.com>: > > Thanks for the clarifications, Elmarie and Dipali > > I think these are good inputs to our dev team, and hope some of them will > also chip into this conversation. > > Cheers, > Knut > >> On Fri, Nov 27, 2015 at 4:11 AM, Elmarie Claasen <elma...@hisp.org> wrote: >> 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 >> >> <image001.png> >> >> Project Manager >> >> Health Information Systems Program >> >> Tel: 041-367 1027 >> >> Cell: 082 374 2209 >> >> E-mail: 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 . 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 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 >> >> 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. 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 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. >> > > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 > 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
_______________________________________________ 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