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 am beginning to think what I’m trying to achieve is not possible within DHIS2 without using the API and creating custom reports, please correct me if I’m wrong.
···
I want a cumulative quarterly target for certain data elements. I want to base the target on the previous year’s performance (per OU). In the example below, the values there are based on the previous year’s actual values (possibly + 5% or another suitable figure):
I want to compare the cumulative target values for the above period with the cumulative actual values for the same period…
…to produce the final output showing the percentage of target achieved for the cumulative number of visits:
I am thinking that for 1) we may need to create a new data element and record the cumulative values manually (or import). For the final result, I’m not sure, given that we’re expecting a comparison of cumulative figures, how doable it is without a custom report and the API. Any insight would be appreciated.
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
···
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 had the same need a week ago but chose to create a simple dataElement so they can fill it manually, I am not convinced that is the best way for data quality.
Please can you explain your idea how to do it with API and custom form? It should be perfect for me.
For your problem, hope you will find the best solution.
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,
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.
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.
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,
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.
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
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.)
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.
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,
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.
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
···
Hi Edward,
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
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.)
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.
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,
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.