A ChainModifier executes multiple modifiers in order.
new ChainModifier({ /* Whether to revert the order before execution. */ reverse: false true });
Sort table rows according to values of a column.
activate
new SortModifier({ /* Direction of sorting. (Default: desc) */ direction: asc desc /* Column with values to order. (Default: y) */ orderByColumn: name x y /* Column to update with order index instead of change order of rows. */ orderInColumn: [unset] name x y });
Limits the number of rows in a DataTable.
new RangeModifier({ /* Value ranges to include in the result. */ ranges: [ /* Options to configure a range. */ { /* Column containing the values to filter. */ column: name x y /* Maximum including value (`<=` operator). */ maxValue: /* Minimum including value (`>=` operator). */ minValue: } ], /* If set to true, it will also compare the value type. */ strict: false true });
Replaces formula in a DataTable with calculated values.
new MathModifier({ /* Column formulas that add or replace column values. */ columnFormulas: [ /* Options to configure a formula for column values. */ { /* Column in the DataTable to calculate values in. */ column: /* Formula to use to replace column values. */ formula: } ] });
Inverts columns and rows in a table.
new InvertModifier({ /* InvertModifier works without additional options. */ });