dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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 <elmarie@xxxxxxxx> 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: elmarie@xxxxxxxx
>
> 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 disclaimer@xxxxxxxx
> 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.org@xxxxxxxxxxxxxxxxxxx] *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 <knutst@xxxxxxxxx> 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_ghadri@xxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxx
> 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 disclaimer@xxxxxxxx
> <disclaimer@xxxxxxxx> 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