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.
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.
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.
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.
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.
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.
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.