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@dhis2.org>:

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@informa.pro> 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@pih.org>:

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@dhis2.org]
*Sent:* Tuesday, March 28, 2017 3:57 AM
*To:* Aaron White <awhite@pih.org>
*Cc:* dhis2-users@lists.launchpad.net; Erin Gathers <egathers@pih.org>;
Eugene Wickett <ewickett@pih.org>
*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|01|awhite%40pih.org|c30acecd36594b710dd008d475aff99c|5254789f6860437585bc302509fad508|1|0|636262846063136595&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@pih.org> 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|01|awhite%40pih.org|c30acecd36594b710dd008d475aff99c|5254789f6860437585bc302509fad508|1|0|636262846063136595&sdata=OME2wnQkJeGa5NODYnn%2ByLCU3%2BXis6CruXBz6JfVtqc%3D&reserved=0>
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
<https://na01.safelinks.protection.outlook.com/?url=https:%2F%2Flaunchpad.net%2F~dhis2-users&data=02|01|awhite%40pih.org|c30acecd36594b710dd008d475aff99c|5254789f6860437585bc302509fad508|1|0|636262846063136595&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|01|awhite%40pih.org|c30acecd36594b710dd008d475aff99c|5254789f6860437585bc302509fad508|1|0|636262846063136595&sdata=qvKhjSq1Xl0%2FJmszZdo6wBP9NurctZSJJXP1s6ed%2Fu0%3D&reserved=0>

--

Edoardo Sabadelli

DHIS 2

University of Oslo

edoardo@dhis2.org

http://www.dhis2.org
<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dhis2.org&data=02|01|awhite%40pih.org|c30acecd36594b710dd008d475aff99c|5254789f6860437585bc302509fad508|1|0|636262846063136595&sdata=2IxrjTfLDwsxhtEHHVku%2FZE9EToTrN%2FSaL4mQj2qhwc%3D&reserved=0>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
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/>