← Back to team overview

dhis2-users team mailing list archive

Re: Cumulative Sum for Indicator in 2.26?

 

Hi Jan and Edoardo, 
this is great. Are there also plans to enable the «months this year» relative period in the UI? I think cumulative + months this year is a common use case.

Olav



> 28. mar. 2017 kl. 17.34 skrev 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 <mailto: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/ <https://play.dhis2.org/dev/dhis-web-event-visualizer/>
> 
> Thanks
> Antonia
> 
> 
> 
> 2017-03-28 15:54 GMT+02:00 Aaron White <awhite@xxxxxxx <mailto: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 <mailto:edoardo@xxxxxxxxx>] 
> Sent: Tuesday, March 28, 2017 3:57 AM
> To: Aaron White <awhite@xxxxxxx <mailto:awhite@xxxxxxx>>
> Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>; Erin Gathers <egathers@xxxxxxx <mailto:egathers@xxxxxxx>>; Eugene Wickett <ewickett@xxxxxxx <mailto: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>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
> Unsubscribe : https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
> 
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
> Unsubscribe : https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
> 
> 
> 
> 
> -- 
> Jan Henrik Øverland
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org <https://www.dhis2.org/>_______________________________________________
> 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


References