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:[email protected]] Sent: Tuesday, March 28, 2017 3:57 AM To: Aaron White <[email protected]> Cc: [email protected]; Erin Gathers <[email protected]>; Eugene Wickett <[email protected]> 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 <[email protected]<mailto:[email protected]>> 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 : [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
