← Back to team overview

dhis2-devs team mailing list archive

Re: Aggregate indicators

 

Hi Jason
Good to hear form you, I hope you are well.

I agree, that is a good solution and it works very well when you implement it as a function you can call form a SQL View, then you can use the API to setup a cron job or use other means to take care of the frequency. There is a lot you can do with this approach.
I was also able to setup the indicator using the API, but we want to allow the user to create these indicators. Both SQL and the API are a little beyond what they can or want to do. I think the indicator editor is due for an face lift ;-) there are other things to consider, for example having 20K constants to choose from or formulas that requires a data element with an option combination that is not part of the category combination assigned to the data element.

Best regards,
JM





> El 29/04/2016, a las 8:30 a.m., Jason Pickering <jason.p.pickering@xxxxxxxxx> escribió:
> 
> Hi JM,
> 
> Sounds like a bug, but quite crazy to attempt as well!
> 
> Another way to do this, though perhaps not ideal, would be to perform this calculation through SQL and inject it back into the system as a data element. We have followed this approach for indicators which cannot be calculated with relatively simple formulas provided by indicators, such as those requiring "IF...THEN" types of calculations. 
> 
> Not ideal, but it might be an approach you wish to consider. 
> 
> Regards,
> Jason
> 
> 
> On Fri, Apr 29, 2016 at 3:24 PM, Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx <mailto:jmalcantara1@xxxxxxxxx>> wrote:
> Hi Lars
> Thank you, I looked at the database and the interface and I didn’t see a limit imposed by either one. I have a formula that sums 410 data elements, I know that sounds impractical but that’s just the way it’s required.
> When I build the formula, with ~300 data elements I get error #1, with the 400 I get error #2
> 
> Best regards,
> JM
> 
> 
> Error #1
> jquery.min.js?_rev=20997:2 GET https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm…cZiZ%7D%0A%2B%23%7BAV0dSekxPXl%7D%0A%2B%23%7BINM6uMXWoeK%7D%0A%0A%0A%0A%0A <https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm%E2%80%A6cZiZ%7D%0A%2B%23%7BAV0dSekxPXl%7D%0A%2B%23%7BINM6uMXWoeK%7D%0A%0A%0A%0A%0A> net::ERR_SPDY_PROTOCOL_ERRORsend @ jquery.min.js?_rev=20997:2p.extend.ajax @ jquery.min.js?_rev=20997:2getExpressionText @ expressionBuilder.js?_rev=20997:82cleanExpression @ expressionBuilder.js?_rev=20997:111onchange @ showUpdateIndicatorForm.action?id=65566:584
> 
> 
> Error #2
> jquery.min.js?_rev=20997:2 GET https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm…eFqW%7D%0A%2B%23%7BePqg2GN87Ng%7D%0A%2B%23%7BFTrvVVBrdry%7D%0A%0A%0A%0A%0A <https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm%E2%80%A6eFqW%7D%0A%2B%23%7BePqg2GN87Ng%7D%0A%2B%23%7BFTrvVVBrdry%7D%0A%0A%0A%0A%0A> 400 ()send @ jquery.min.js?_rev=20997:2p.extend.ajax @ jquery.min.js?_rev=20997:2getExpressionText @ expressionBuilder.js?_rev=20997:82cleanExpression @ expressionBuilder.js?_rev=20997:111onchange @ showUpdateIndicatorForm.action?id=65566:584
> 
> 
> 
>> El 28/04/2016, a las 1:40 a.m., Lars Helge Øverland <lars@xxxxxxxxx <mailto:lars@xxxxxxxxx>> escribió:
>> 
>> Hi JM,
>> 
>> there is no hard limit (beyond 2gb expression length;).
>> 
>> However data analytics performance (and entry forms if you have indicators there) will of course suffer with extremely large indicators.
>> 
>> regards,
>> 
>> Lars
>> 
>> 
>> On Wed, Apr 27, 2016 at 11:44 PM, Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx <mailto:jmalcantara1@xxxxxxxxx>> wrote:
>> Hi Devs
>> Is there a limit on the number of data elements that can be added in an indicator formula?
>> Regards,
>> JM
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs <https://launchpad.net/~dhis2-devs>
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
>> Unsubscribe : https://launchpad.net/~dhis2-devs <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
>> 
>> 
>> 
>> -- 
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> http://www.dhis2.org <https://www.dhis2.org/>
>> 
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs <https://launchpad.net/~dhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Unsubscribe : https://launchpad.net/~dhis2-devs <https://launchpad.net/~dhis2-devs>
> More help   : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
> 
> 
> 
> 
> -- 
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx <mailto:jason.p.pickering@xxxxxxxxx>
> tel:+46764147049


Follow ups

References