← Back to team overview

dhis2-users team mailing list archive

Re: Indicator - Maximum number of data elements in the expression

 

Hi Jason,
Thanks, your hint solved a problem for us too where we had a large number of data elements needing to be included in denominators of indicators – now we can make indicators to insert into other indicators. We are working in 2.26 and hoping this will not break in the newer versions when we update.
Regards
Jane

From: Dhis2-users <dhis2-users-bounces+jane.greig=london.msf.org@xxxxxxxxxxxxxxxxxxx> On Behalf Of Peter D Lubambi
Sent: 26 July 2018 18:31
To: jason.p.pickering@xxxxxxxxx
Cc: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Indicator - Maximum number of data elements in the expression

Hi Jason,
My indicator expression consist a total of 220 data elements (1 Positive*11 age bands *2 Sex*10 Testing points ), Alternative is, since I have created POS Male and POS Female so adding these two indicators would serve the purpose.
Regards,

Peter Dotto Lubambi,
Skype: plubambi
Mobile: +255 786 087 087


On Tue, Jul 17, 2018 at 1:57 PM Jason Pickering <jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>> wrote:
Hi Peter,

I believe the limit to the number of expressions which are included in an indicator is that of the underlying database field which stores the expression, which should be very large. I think in practice, you may reach a limit where the indicator may be too complex to calculate quickly enough. We have created indicators with many hundreds of data elements, and while they do work, it can be a bit slow.

You may also encounter a limit in the user interface when defining the indicators, but if you are creating one with many dozens or hundreds of expression elements, you are probably not going to want to use the UI anyway, and would script the creation of the indicator.

While not supported through the user interface, adding together indicators will work it seems.

Would be interested to hear what your experience is if you create a "large" indicator, or one which consists of multiple indicator components.

Best regards,
Jason


On Tue, Jul 17, 2018 at 11:11 AM Peter D Lubambi <plubambi@xxxxxxxxx<mailto:plubambi@xxxxxxxxx>> wrote:
Dear All,
Is there a maximum number of data elements to be included in the Numerator/Denominator expression?
If so, is it possible to include another indicator in the indicator calculation expression?

Regards,
Peter Dotto Lubambi,
Skype: plubambi
Mobile: +255 786 087 087
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>
tel:+46764147049

Follow ups

References