dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Lars,
Thanks for looking into this. I have created a blueprint here for further
discussion.

https://blueprints.launchpad.net/dhis2/+spec/aggregation-operators

Regards,
Jason



On Wed, Sep 25, 2013 at 6:40 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:

> Agree, we could rename the current aggregation operator to "time dimension
> aggregation operator" and introduce a new one "org unit hierarchy
> aggregation operator".
>
> Lars
>
>
> On Tue, Sep 24, 2013 at 11:43 AM, Ola Hodne Titlestad <olati@xxxxxxxxxx>wrote:
>
>> When it comes to e.g. population or staffing numbers it makes sense to
>> sum on orgunit and average on time, so don't think we are planning to
>> change the default behaviour here.
>>
>> That said, from the use case Jason described it probably makes sense to
>> also support average on orgunit dimension, but then it would have to be
>> implemented as an additional aggregation operator, and not replacing the
>> current one.
>>
>> Also note that the analytics web api opens up for any kind of aggregation
>> if you want to develop  a custom report or data visualisation that needs
>> aggregation logic not directly supported by DHIS 2.
>>
>> Ola
>> -------
>>
>>
>> ----------------------------------
>> Ola Hodne Titlestad (Mr)
>> HISP
>> Department of Informatics
>> University of Oslo
>>
>> Mobile: +47 48069736
>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>
>>
>>
>> On 24 September 2013 08:52, Troy Borja <tborja@xxxxxxxxxxxxxxx> wrote:
>>
>>> I think the current behavior needs to be changed since summing averages
>>> does not mean anything while taking the average across org units would be
>>> useful.
>>> On Sep 24, 2013 12:50 PM, "jason.p.pickering" <
>>> 1229494@xxxxxxxxxxxxxxxxxx>
>>> wrote:
>>>
>>> > This is supposed to be the intended behaviour I think, but I have also
>>> > been having issues with this. Check the manual on this, and it is
>>> > clearly stated that values are average in the time dimension. What it
>>> is
>>> > not really clear on but is implied, is that  values are summed along
>>> the
>>> > orgunit dimension.
>>> >
>>> >
>>> > I do not really see this as a bug, but rather intended behavior which
>>> > works as the developers have implemented it.
>>> >
>>> > But, what we do need ( i.e blueprint) is another operator to average
>>> > both the values both in time as well as in the orgunit dimension. We
>>> > have an data element "Number of days vaccine fridge was functional".
>>> > This value should be averaged both in terms of time as well as across
>>> > orgunits, to arrive at a national average. Instead, we get (as you have
>>> > observed) a sum of the values.
>>> >
>>> > ** Changed in: dhis2
>>> >        Status: New => Invalid
>>> >
>>> > --
>>> > You received this bug notification because you are subscribed to the
>>> bug
>>> > report.
>>> > https://bugs.launchpad.net/bugs/1229494
>>> >
>>> > Title:
>>> >   Aggregate of Avg type field is summed across Org Units
>>> >
>>> > Status in DHIS 2:
>>> >   Invalid
>>> >
>>> > Bug description:
>>> >   I am using v2.12. On a Dataset I created a numeric field with Average
>>> >   aggregation. When reported across Org Units, the averages are summed
>>> >   instead of taking the average data across the Org Units. Is this how
>>> >   Average aggregation should work?
>>> >
>>> > To manage notifications about this bug go to:
>>> > https://bugs.launchpad.net/dhis2/+bug/1229494/+subscriptions
>>> >
>>>
>>> --
>>> You received this bug notification because you are a member of DHIS 2
>>> developers, which is subscribed to DHIS.
>>> https://bugs.launchpad.net/bugs/1229494
>>>
>>> Title:
>>>   Aggregate of Avg type field is summed across Org Units
>>>
>>> Status in DHIS 2:
>>>   Invalid
>>>
>>> Bug description:
>>>   I am using v2.12. On a Dataset I created a numeric field with Average
>>>   aggregation. When reported across Org Units, the averages are summed
>>>   instead of taking the average data across the Org Units. Is this how
>>>   Average aggregation should work?
>>>
>>> To manage notifications about this bug go to:
>>> https://bugs.launchpad.net/dhis2/+bug/1229494/+subscriptions
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>