Hello Ian

At the moment it cannot be done, but I have forwarded your question to one of our developers, and as soon as he responds I'll let you know.

Hi again Ian

You can use the filter wpdatatables_filter_float_cell

It will, however, be used on the whole table, not only on that shortcode.

Also, you can change it directly in the template file: wp-content/plugins/wpdatatables/templates/frontend/aggregate_functions.inc.php on line 7 you will find this:

<span class='wdt-column-<?php echo $function ?>-value'><?php echo $funcResult ?></span>

So, just replace it with this:

<span class='wdt-column-<?php echo $function ?>-value'><?php echo (int)$funcResult ?></span>

Hi again Ian

That's right, it will not show the decimals.

If you go for the filter option, you will need to create a function in your functions.php file, yes. Unfortunately, I can't help you with that, as it is custom code, and is not included in the provided support for the plugin.

I can show some examples of usage of other filters:

function filterColumnObject( $columnDescriptionObject, $columnTitle )
    {
        
       if ($columnDescriptionObject->origHeader == 'name_of_the_column_from_origin_header'){
           $columnDescriptionObject->searchable = false;
       }
       return $columnDescriptionObject;
    }
add_filter( 'wpdatatables_filter_column_js_definition', 'filterColumnObject', 2, 10);

Or:

function updateValuesBeforeSave($formData,$tableID){
    //Helper method that load columns config data from DB
    $columnsData = \WDTConfigController::loadColumnsFromDB($tableID);
    foreach ($columnsData as $column){
        if ($column->orig_header == 'name_of_the_orig_header_for_your_column') {
            $formData[$column->orig_header] = 1;//we set 1 but you will replace here what ever you need
        }
    }
    return $formData;
}
add_filter('wpdatatables_filter_formdata_before_save','updateValuesBeforeSave', 2, 10);

I hope that helps.

There's always the other way, changing the line of code in wp-content/plugins/wpdatatables/templates/frontend/aggregate_functions.inc.php on line 7 

Alright, Ian

I forwarded the ticket to one of our developers, and I'll get back to you as soon as he responds.

Hi again Ian

For the table, you should change this for serverside tables:

In file wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js on line 615 you'll find this:

$('#' + tableDescription.tableId + ' tfoot tr.wdt-avg-row td.wdt-avg-cell[data-column_header="' + columnName + '"]').html(avgLabel + ' ' + api.ajax.json().avgColumnsValues[columnName]);

Replace it with this:

$('#' + tableDescription.tableId + ' tfoot tr.wdt-avg-row td.wdt-avg-cell[data-column_header="' + columnName + '"]').html(avgLabel + ' ' + parseInt(api.ajax.json().avgColumnsValues[columnName]));

For non-server-side tables, in the same file:

wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js on line 683 you'll see this:

var avgStr = wdtFormatNumberByColumnType(avg, 'float', tableDescription.columnsDecimalPlaces[tableDescription.sumAvgColumns[i]],

And replace it with this: 

var avgStr = wdtFormatNumberByColumnType(parseInt(avg), 'int', tableDescription.columnsDecimalPlaces[tableDescription.sumAvgColumns[i]],

After that, go to wpDataTables settings/Custom JS and CSS and disable "Use minified wpDataTables Javascript", and it should work.

Hi again Ian

I'm glad to hear this option works for you.

It's even better maybe, because the changes I advised would revert after updates, so you would need to do it again.