← Back to team overview

dhis2-devs team mailing list archive

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

 

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
>

Follow ups

References