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 <[email protected]> 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* > > [image: Hisp logo] > > Project Manager > > Health Information Systems Program > > Tel: 041-367 1027 > > Cell: 082 374 2209 > > E-mail: [email protected] > > 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 > [email protected] > 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= > [email protected]] *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 <[email protected]> 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 <[email protected]> > 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 : [email protected] > 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 : [email protected] > 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 [email protected] > <[email protected]> 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
