Average the values in a data set.
- Author: Allan Jardine
- Requires: DataTables 1.10+
It can sometimes be useful to get the average of data in an API result set, be it from a column, or a collection of cells. This method provides exactly that ability.
This plug-in can be obtained and used in multiple different ways.
This plug-in is available on the DataTables CDN:
The plug-in will then automatically register itself against a global DataTables instance. This file can also be used if you are using an AMD loader such as Require.js.
Note that if you are using multiple plug-ins, it can be beneficial in terms of performance to combine the plug-ins into a single file and host it on your own server, rather than making multiple requests to the DataTables CDN.
datatables.net-plugins package. To use this plug-in, first install the plug-ins package:
npm install datatables.net-plugins
Then, if you are using ES modules, import
datatables.net, any other DataTables extensions you need, and the plug-in:
import DataTable from 'datatables.net'; import 'datatables.net-plugins/api/average().mjs';
If you are using a CommonJS loader for Node (e.g. with older versions of Webpack, or non-module Node code) use the following method to
require the plug-in:
var $ = require('jquery'); var DataTable = require('datatables.net'); require('datatables.net-plugins/api/average().js');
// Average a column var table = $('#example').DataTable(); table.column( 3 ).data().average();
// Average two cells var table = $('#example').DataTable(); table.cells( 0, [3,4] ).data().average();
If you have any ideas for how this plug-in can be improved, or spot anything that is in error, it is available on GitHub and pull requests are very welcome!