how to Dynamically update footer with total, min and Average of datatable columns

Samk

Link to test case: https://live.datatables.net/zalitado/3/edit
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem: unable to dynamically update totals in footer as the input text changes in the columns. and looking for a function to generate average and min of columns.

kthorngren

You need to keep up with the input value by updating it when changed by updating the document. And you need to have Datatables updates its data cache to know about the change using cell().invalidate(). Last you will need to use draw(), with the page parameter to stay on the same page, to have footerCallback to run. See updated example:
https://live.datatables.net/zalitado/5/edit

Kevin

Samk

thanks very much Kevin, oddly the column 3 doesn't update, although the data type is converted to numeric. is the column somehow being set to string after the redraw, seem unlikely though

allan

You can use the v2 multi-row header / footer API to be able to pick out and update the other rows in the footer: https://live.datatables.net/zalitado/10/edit .

I've used plug-in API methods for average and min there as well.

The data type issue doesn't appear to effect funcationlity?

Allan

Samk

thanks allan, giant leap!!
. ive made some changes to compensate for zero values when calc'ing average and min values. im now stuck with a search or vlookup type behaviour that that i need to populate the cpty with the min, max, and average values that have been calc'd. testcase -> https://live.datatables.net/zalitado/13/edit

allan

I've added a reply to your other thread on that topic.

Allan