← Back to team overview

dhis2-users team mailing list archive

Re: Tie an indicator denominator to a fixed period

 

No, you will have to copy the 2016 values for 2017. Can be done in sql or
with a script, but since you only have 5, you might as well do it manually.

On Jun 2, 2017 8:37 PM, "Dimitar Popov" <calpi@xxxxxx> wrote:

> Hi Knut,
>
>
> Thanks for the reply. That would work for 2016 for sure.
>
> If I want to calculate the same indicator for February or March 2017, will
> it work with the annual denominator for 2016 (and the numerator being for
> February or March 2017)?
>
> Thank you very much for your time and cooperation.
>
>
> Best wishes,
>
> Dimitar
>
>
>
>
>
>
> >-------- Оригинално писмо --------
> >От: Knut Staring knutst@xxxxxxxxx
> >Относно: Re: [Dhis2-users] Tie an indicator denominator to a fixed period
> >До: Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx>
> >Изпратено на: 02.06.2017 21:26
>
> You can join a monthly numerator with an annual denominator.
>
> On Jun 2, 2017 7:06 PM, "Georgi Chakarov" < georgi@xxxxxxxxxxxxxxxxxxx>
> wrote:
>
> Hi guys,
>
> Can someone help on this case:
>
> I need to have the Beds’ utilization rate (%) calculated for my 5 Org
> Units.
>
> I collect the "Number of occupied beds" as a separate data element on a
> monthly basis. The number of beds per Org Unit is fixed and I have
> collected the information for them only once in September 2016 in a data
> element called “Number of Beds”. The number of beds does not change.
>
> How can I set up the denominator of the indicator (“Number of occupied
> beds”/Number of Beds) so that the value of the indicator is calculated
> based on the value of the “Number of Beds” data element for September 2016
> and not the value of the current month (apparently there is no values for
> the months after September 2016)?
>
> I cannot use constants, because the number of beds is different for each
> Org Units and I do not want to create 5 separate Indicators for the 5
> separate Org Units.
>
> At the same time I do not want to record the number of beds to be the same
> every month, since it is confusing and it will look like we add up the same
> number of debs every month, which is not the case.
>
> Is there a solution to this issue?
>
> Thanks,
>
>
>
>
> Georgi Chakarov, CIA | georgi@xxxxxxxxxxxxxxxxxxx | +1-647-478-5634 x 104 | LogicalOutcomes
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S
> 2R4 | *You may unsubscribe from receiving commercial electronic messages
> from LogicalOutcomes by emailing **info@xxxxxxxxxxxxxxxxxxx*
>
>
>
> _______________________________________________
> 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