Tie an indicator denominator to a fixed period

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

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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Georgi,

try this:

  • collect “Number of beds” as a yearly data value.

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

regards,

Lars

···

On Fri, Jun 2, 2017 at 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

I think that could make for a good JIRA issue - please go ahead.

···

On Jun 2, 2017 8:55 PM, “Dimitar Popov” calpi@abv.bg wrote:

Hi Knut,

OK, thanks for the time and efforts.

In general it would be nice if we can use in the indicators data that is entered as attributes under each Org Unit.

Since we can add attributes to each Org Units, we could then use the Org Units specific data for calculations in the indicators.

Just an idea for the future features :).

Best wishes,

Dimitar

-------- Оригинално писмо --------
От: Knut Staring knutst@gmail.com

Относно: Re: [Dhis2-users] Tie an indicator denominator to a fixed period

До: Dimitar Popov calpi@abv.bg
Изпратено на: 02.06.2017 21:48

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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp