← Back to team overview

dhis2-users team mailing list archive

Re: Indicator based on previous year's output

 

Thanks Jim, I’ll look into predictors and see if they’re able to meet my specific need.  I suspect they might be ideal for setting the targets, though we will likely set an annual target once a year and average that for quarterly targets – maybe once a year create quarterly target indicators based on the annual target elements / 4.  I’ll put something more comprehensive together for a Jira ticket to explain exactly what we’re doing – I suspect it will be very useful for the whole community.
Regards
Ed

From: Jim Grace <jim@xxxxxxxxx>
Sent: Wednesday, 28 March 2018 10:23 PM
To: Tlohang <moeketsetf@xxxxxxxxx>
Cc: Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx>; DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Indicator based on previous year's output

Hi Edward,

1. You might consider using predictors. Define additional data elements (with disaggregations if you like) for your targets. Use predictors to populate those data elements in the new period based on values from the old period(s). You can use a predictor formula to sum past data, and even add 5% if you like. Then you will have predicted (target) data in the same period to compare with your results in that period. For details see https://docs.dhis2.org/master/en/user/html/manage_predictor.html

2. We are considering possible future enhancements to analytics expressions including things like pulling data from past periods into an indicator. If this would be more useful to you than using predictors, please write up a DHIS2 Jira ticket that describes your use case (the kinds of things you've said in this email thread would be just fine), and reference the Epic at https://jira.dhis2.org/browse/DHIS2-3187 (or let me know and I will reference it -- I'm not sure what privilege is required for this.)

Cheers,
Jim


On Wed, Mar 28, 2018 at 4:05 PM, Tlohang <moeketsetf@xxxxxxxxx<mailto:moeketsetf@xxxxxxxxx>> wrote:
Hi Edward

I see that I was on a different page altogether.
Well, I think your situation can still be addressed within DHIS 2 but you may have to do some java scripts to manage the data that has to be retrieved from the previous periods. We've done something close to this with one of our programmes.

Regards,

Tlohang

On 28 Mar 2018 19:53, Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx<mailto:erobinson@xxxxxxxxxxxxxxxxxx>> wrote:

Thanks Tlohang, yes, I’m aware that we can produce a cumulative number of x over a period, but I need to then use those numbers to compare data from another period as covered in my last mail, hence I assumed I may be able to achieve it using an indicator.  Sorry that I was a bit brief in my initial mail,

Regards

Ed



From: Tlohang <moeketsetf@xxxxxxxxx<mailto:moeketsetf@xxxxxxxxx>>
Sent: Wednesday, 28 March 2018 7:18 PM
To: Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx<mailto:erobinson@xxxxxxxxxxxxxxxxxx>>
Cc: DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>>
Subject: Re: [Dhis2-users] Indicator based on previous year's output



Hi Edward



You probably don't need an indicator for that. The knows how to analyse that data element in that cumulative manner once you choose that period during analysis.



I hope this helps.



Regards,

Tlohang



On 28 Mar 2018 17:34, Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx<mailto:erobinson@xxxxxxxxxxxxxxxxxx>> wrote:

What’s the best approach to creating an indicator that’s based on a cumulative total of a data element captured monthly, for a set timeframe?



E.g. I have an indicator called “Number of patients” captured monthly.

I need an indicator that will give me the total number of patients for the set period October 2016 – September 2017.



Thanks in advance!




_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org<https://www.dhis2.org/>

References