← Back to team overview

dhis2-users team mailing list archive

Re: Cumulative Sum for Indicator in 2.26?

 

Thanks Jan!
I'll wait for the new version.

antonia

2017-03-28 17:34 GMT+02:00 Jan Henrik Øverland <jan@xxxxxxxxx>:

> Hi Antonia,
>
> Event visualizer will get this in a week or two.
>
> For pivot tables it is not that straight forward, so we need to think more
> about a possible implementation.
>
> Jan
>
> On 28 March 2017 at 10:35, Antonia - Pro <antonia@xxxxxxxxxxx> wrote:
>
>> Edoardo,
>> very nice! Is it possible to add the "Use cumulative values" also in the
>> Event visualizer/report
>> https://play.dhis2.org/dev/dhis-web-event-visualizer/
>>
>> Thanks
>> Antonia
>>
>>
>>
>> 2017-03-28 15:54 GMT+02:00 Aaron White <awhite@xxxxxxx>:
>>
>>> Edoardo,
>>>
>>>
>>>
>>> This is great.  Are there plans to also add this functionality to the
>>> Pivot Tables application?
>>>
>>>
>>>
>>> Ideally, being able to define an indicator as a cumulative calculation
>>> in the indicator definition would be the best solution since it would be
>>> defined in one place instead of many.  The specific context we’re looking
>>> at is a cumulative TB cure rate which we’d like calculated on a monthly
>>> basis over time.
>>>
>>>
>>>
>>> Thanks!
>>>
>>> Aaron
>>>
>>>
>>>
>>> *From:* Edoardo Sabadelli [mailto:edoardo@xxxxxxxxx]
>>> *Sent:* Tuesday, March 28, 2017 3:57 AM
>>> *To:* Aaron White <awhite@xxxxxxx>
>>> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx; Erin Gathers <egathers@xxxxxxx>;
>>> Eugene Wickett <ewickett@xxxxxxx>
>>> *Subject:* Re: [Dhis2-users] Cumulative Sum for Indicator in 2.26?
>>>
>>>
>>>
>>> Hi Aaron,
>>>
>>>
>>>
>>> I've recently added a "Use cumulative values" option in Data Visualizer
>>> for 2.27.
>>>
>>> You can try it out on https://play.dhis2.org/dev/dhis-web-visualizer/
>>> <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fplay.dhis2.org%2Fdev%2F&data=02%7C01%7Cawhite%40pih.org%7Cc30acecd36594b710dd008d475aff99c%7C5254789f6860437585bc302509fad508%7C1%7C0%7C636262846063136595&sdata=YR95xfoBasHNZM4GGKb8TOX2Ognm40qYOPxwItHwJjY%3D&reserved=0>
>>> .
>>>
>>>
>>>
>>> If I understand correctly that should give you what you need.
>>>
>>>
>>>
>>> Let me know.
>>>
>>>
>>>
>>> Cheers,
>>>
>>>
>>>
>>> On Fri, Mar 24, 2017 at 7:01 PM, Aaron White <awhite@xxxxxxx> wrote:
>>>
>>> Greetings DHIS2 users,
>>>
>>>
>>>
>>> We’re setting up a new program in DHIS2 2.26 and are in need of a
>>> running or cumulative sum of all values entered for a specific data
>>> element.  For a given month, we’d like to know the total that has ever been
>>> entered for that data element (all previous months + current month value
>>> entered).  We’ve tried using the “This Year” view in the Pivot
>>> Tables/Visualizer applications but we would want data from 2016 to continue
>>> into 2017 and so on.  We’ve run into a similar challenge when trying to
>>> calculate a moving average over a specified time window.
>>>
>>>
>>>
>>> Has anyone encountered this and how did you solve the problem?  We would
>>> like to do this entirely within DHIS2 if possible and avoid any manual
>>> manipulation of the data outside of the program.
>>>
>>>
>>>
>>> Thanks,
>>>
>>> Aaron
>>>
>>>
>>>
>>> *Aaron White, MPA, MIS*
>>>
>>> Strategic Information Systems Manager
>>>
>>> *Monitoring, Evaluation, and Quality Improvement*
>>>
>>> Partners in Health
>>>
>>> S: awhite.pih  |  C: 857.540.5580 <(857)%20540-5580>
>>>
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> <https://na01.safelinks.protection.outlook.com/?url=https:%2F%2Flaunchpad.net%2F~dhis2-users&data=02%7C01%7Cawhite%40pih.org%7Cc30acecd36594b710dd008d475aff99c%7C5254789f6860437585bc302509fad508%7C1%7C0%7C636262846063136595&sdata=OME2wnQkJeGa5NODYnn%2ByLCU3%2BXis6CruXBz6JfVtqc%3D&reserved=0>
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> <https://na01.safelinks.protection.outlook.com/?url=https:%2F%2Flaunchpad.net%2F~dhis2-users&data=02%7C01%7Cawhite%40pih.org%7Cc30acecd36594b710dd008d475aff99c%7C5254789f6860437585bc302509fad508%7C1%7C0%7C636262846063136595&sdata=OME2wnQkJeGa5NODYnn%2ByLCU3%2BXis6CruXBz6JfVtqc%3D&reserved=0>
>>> More help   : https://help.launchpad.net/ListHelp
>>> <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fhelp.launchpad.net%2FListHelp&data=02%7C01%7Cawhite%40pih.org%7Cc30acecd36594b710dd008d475aff99c%7C5254789f6860437585bc302509fad508%7C1%7C0%7C636262846063136595&sdata=qvKhjSq1Xl0%2FJmszZdo6wBP9NurctZSJJXP1s6ed%2Fu0%3D&reserved=0>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Edoardo Sabadelli
>>>
>>> DHIS 2
>>>
>>> University of Oslo
>>>
>>> edoardo@xxxxxxxxx
>>>
>>> http://www.dhis2.org
>>> <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dhis2.org&data=02%7C01%7Cawhite%40pih.org%7Cc30acecd36594b710dd008d475aff99c%7C5254789f6860437585bc302509fad508%7C1%7C0%7C636262846063136595&sdata=2IxrjTfLDwsxhtEHHVku%2FZE9EToTrN%2FSaL4mQj2qhwc%3D&reserved=0>
>>>
>>> _______________________________________________
>>> 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
>>
>>
>
>
> --
> Jan Henrik Øverland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.org/>
>