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@logicaloutcomes.net | +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@logicaloutcomes.net

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@logicaloutcomes.net | +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@logicaloutcomes.net

set the aggregation type for the “Number of beds” data element to “Average (sum in org unit hierarchy”.

In indicators, when aggregating for a month, the analytics engine will use the “standing” value for each month based on the yearly value for the denominator.

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@logicaloutcomes.net | +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@logicaloutcomes.net

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@abv.bg 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@gmail.com

Относно: Re: [Dhis2-users] Tie an indicator denominator to a fixed period
До: Georgi Chakarov georgi@logicaloutcomes.net
Изпратено на: 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@logicaloutcomes.net > 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@logicaloutcomes.net | +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@logicaloutcomes.net

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@abv.bg > 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@gmail.com

Относно: Re: [Dhis2-users] Tie an indicator denominator to a fixed period
До: Georgi Chakarov < georgi@logicaloutcomes.net >
Изпратено на: 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@logicaloutcomes.net > 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@logicaloutcomes.net | +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@logicaloutcomes.net