dhis2-users team mailing list archive

[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/>