← Back to team overview

dhis2-users team mailing list archive

Re: 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>
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>
> 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
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>

Follow ups

References