← Back to team overview

dhis2-users team mailing list archive

Re: Tie an indicator denominator to a fixed period


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

On Jun 2, 2017 8:55 PM, "Dimitar Popov" <calpi@xxxxxx> 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,


>-------- Оригинално писмо --------
>От: Knut Staring knutst@xxxxxxxxx
>Относно: Re: [Dhis2-users] Tie an indicator denominator to a fixed period
>До: Dimitar Popov <calpi@xxxxxx>
>Изпратено на: 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@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,


>-------- Оригинално писмо --------
>От: 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>

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?


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