dhis2-users team mailing list archive

[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<mailto: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<tel:(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<mailto: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<mailto: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>