Re: [Tiki-devel] Tracker Calculation - culomn sum - calculate across items

Hello Torsten,

> is there a way (method, best practice, feature) existing or planned to calculate across tracker  items?

It is definitely possible to use values from different tracker in a mathematical tracker field and apply a formula.
Each time I can (find something new) I add samples about it at : https://doc.tiki.org/Calculations

From what I understand from your use case;
Use an itemList to grab all the value from the other tracker (all items or a filtered subset of items) and in a mathematical field use a foreach to apply a formula:
https://doc.tiki.org/Calculations#for-each

It may take sometime and tries but it should do it.

Bernard


> On 20 Sep 2021, at 14:07, Torsten Fabricius via TikiWiki-devel <[email protected]> wrote:
> 
> Hello there,
> 
> is there a way (method, best practice, feature) existing or planned to calculate across tracker  items?
> 
> We can calculate inside one tracker item, which would represent a calculation in a row of a spreadsheet or a row in a database.
> 
> There are use cases, where it would be helpful to calculate (automatically or semiautomatically) in a way that the results of a specied field are added together as a sum or arithmetically averaged for all items (all rows) or a filtered subset of items (rows).
> This would represent a calculation (sum or average) in a culomn of a spreadsheet or a row in a database.
> 
> I have heard, that there might be a way to do this with some JS magic and I hope that a Tiki legacy way to do it is existing or in development.
> 
> Who could (and would) help to either document this or make it working and documented afterwords?
> 
> Best regards,
> Torsten
> 
> 
> 
> 
> _______________________________________________
> TikiWiki-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel