← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 1229494] Re: Aggregate of Avg type field is summed across Org Units

 

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
>
>

Follow ups

References