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 <geo...@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 | geo...@logicaloutcomes.net | +1-647-478-5634 x 104 > <+1%20647-478-5634> | 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 * > *i...@logicaloutcomes.net* <i...@logicaloutcomes.net> > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@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 l...@dhis2.org http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
