Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-24 Thread Bob Jolliffe
For what its worth the following is the sql I used to extract the latest value of a population dataelement. I am sure it could be generalized and maybe implemented as a getLastValue method on a dataelement. --- -- function returns m

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-24 Thread Rodolfo Melia
Hi Lars - I had a quick look in trunk. When editing a Data Element, I still only see one Aggregation Operator. I was expecting to find two: one for controlling the operator of aggregations across time, a second selector for the aggregator across Org Units... In terms of priorities, below my list:

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-24 Thread Lars Helge Øverland
Hi there, we have implemented support for a "true" average aggregation operator in trunk now, which will average across both time and org unit dimensions. The existing average operator has been renamed to "Average (sum in organisation unit hierarchy)" in the UI. This will be part of 2.17. regar

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-08 Thread Robin Martens
] Sent: 07 September 2014 16:24 To: Rodolfo Melia Cc: Robin Martens; dhis2-users; dhis2-devs@lists.launchpad.net Subject: Re: [Dhis2-devs] DHIS2 - Averaging over orgunits Hi there, we will try to get it in for 2.17. One question around the design: We currently have 7 aggregation operators: sum

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-07 Thread Lars Helge Øverland
Hi there, we will try to get it in for 2.17. One question around the design: We currently have 7 aggregation operators: sum | average | count | std dev | variance | min | max Re individual aggregation operators for the time and org unit dimension, from a technical perspective we are not first a

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-06 Thread Rodolfo Melia
Hi - i just want to add support to the importance of splitting the aggregator operator across time and org units. I'm planning around its availability for 2.17 Rodolfo Meliá > On 5 Sep 2014, at 17:26, Robin Martens wrote: > > Hi Lars, > > Thank you. I thought so but couldn't find the refer

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-05 Thread Robin Martens
Hi Lars, Thank you. I thought so but couldn't find the reference. In the blueprint it is assigned to release 2.17, is this still being maintained? Regards, Robin From: Lars Helge Øverland [mailto:larshe...@gmail.com] Sent: 05 September 2014 18:24 To: Robin Martens Cc: dhis2-users; dhis2-devs@l

Re: [Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-05 Thread Lars Helge Øverland
Hi Robin, I get your point. This has actually been raised before and we plan to support individual aggregation operators for the org unit and time dimensions. Blueprint here: https://blueprints.launchpad.net/dhis2/+spec/orgunit-hierarchy-aggregation-operator regards, Lars On Thu, Sep 4, 2

[Dhis2-devs] DHIS2 - Averaging over orgunits

2014-09-04 Thread Robin Martens
Hi there, As per the manual, the "average" option when defining data elements aggregates by average over periods but sum over orgunits. This limits severely the reporting possibilities, for instance when calculating the average person age over multiple districts but I can think of many other ex