dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

I think you could just take the yearly data for 2013. This should add up
what is available so far this year.

Sent from my mobile
On 12 Dec 2013 01:55, "Jason Pickering" <jason.p.pickering@xxxxxxxxx> wrote:

> Hi Eddie,
>
> You certainly could, but there is no way to do this directly with DHIS2 I
> think . You could use windowing functions of Postgresql [0] to calculate
> the cumulative sum, or create your own function with a custom function with
> PL/R which has been described in the documentation outlined here [1]. There
> are various ways to do this in R, either with the base "cumsum" function or
> with more advanced methods in the "timeSeries" package depending on your
> exact needs.
>
> The simplest method however might be to use Excel [2] .
>
> However at the moment, there is no way to do this directly with DHIS2 as
> far as I know. But if others know more direct methods, it would be good to
> know!
>
> Regards,
> Jason
>
>
> [0]
> http://www.postgresonline.com/journal/archives/47-How-to-calculate-Running-Totals-and-Sums-in-SQL.html
> [1] http://www.dhis2.org/doc/snapshot/en/user/html/apcs06.html
> [2]http://support.microsoft.com/kb/214149
>
>
> On Wed, Dec 11, 2013 at 1:50 PM, Edwin Mulwa <eddiemu@xxxxxxxxx> wrote:
>
>> Hi,
>>
>> I would like to create a report that has a field(s) which is a cumulative
>> total calculation involving multiple data elements. For example, I have
>> data elements A and B and I am doing monthly cumulative reporting such that
>> the value for element A in Feb will be the value of A in Jan + the new
>> value for B in Feb, the value for A in March will be the value of A in Feb
>> + the new value for B in March, etc.
>>
>> Can we create such a report in DHIS?
>>
>> Edwin
>>
>> _______________________________________________
>> 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
>>
>>
>
> _______________________________________________
> 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
>
>