Hello,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

At this time, we don't have any built-in solution to achieve this, but you can suggest it to our developers - they will do their best to make a solution in the future.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

If you have coding skills and wish to try to make a custom solution now,

you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

Please be advised that custom solutions with hooks are not included in our support.

You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)

Hi Matt,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Can you write the Purchase Code you tried on the ticket, and we can check if there is any issue from our end for the licence?

Just make sure to write this as a PRIVATE reply, for safety reasons, of course.

-

The use-case you described, to ignore blank values from a Table / not show them in the connected Chart.

This can only be achieved with a Custom Chart Callback.

Please note that this workaround only works for HighCharts Engine.

For other Chart Engines we don't currently have a workaround to skip NULL and/or zero values.

If you wish to try it, please go to the functions.php file of your theme or child theme, and add this:

function filterNullValues ($value, $origHeader ,$chartID, $tableID){
     // You can add conditions for specific org header, chart id or table id
    // Here we only check if value is null and provide same value to the chart object
    if (is_null($value) || $value == 0 || intval($value) == 0){
        $value = null;
    }
    return $value;
}
add_filter( 'wpdatatables_filter_int_cell_data_in_charts', 'filterNullValues', 10, 4 );
add_filter( 'wpdatatables_filter_float_cell_data_in_charts', 'filterNullValues', 10, 4 );

This works for integer and float columns that have NULL values and "0" values.

If you want to apply it just for NULL values, you can use this code:

function filterNullValues ($value, $origHeader ,$chartID, $tableID){
     // You can add conditions for specific org header, chart id or table id
    // Here we only check if value is null and provide same value to the chart object
    if (is_null($value)){
        $value = null;
    }
    return $value;
}
add_filter( 'wpdatatables_filter_int_cell_data_in_charts', 'filterNullValues', 10, 4 );
add_filter( 'wpdatatables_filter_float_cell_data_in_charts', 'filterNullValues', 10, 4 );

And if you want to apply it just for "0" values, you can use this code:

function filterNullValues ($value, $origHeader ,$chartID, $tableID){
     // You can add conditions for specific org header, chart id or table id
    // Here we only check if value is null and provide same value to the chart object
    if ($value == 0){
        $value = null;
    }
    return $value;
}
add_filter( 'wpdatatables_filter_int_cell_data_in_charts', 'filterNullValues', 10, 4 );
add_filter( 'wpdatatables_filter_float_cell_data_in_charts', 'filterNullValues', 10, 4 );

You don't need to change the code after the plugin updates, but you will need to keep this code in functions.php.

If you want to connect data with NULLs skipped, you can use this callback: https://jsfiddle.net/gh/get/library/pure/highcharts/highcharts/tree/master/samples/highcharts/plotoptions/series-connectnulls-true/

<script type="text/javascript">
jQuery(window).on('load',function(){
    if( typeof wpDataChartsCallbacks == 'undefined' ){ wpDataChartsCallbacks = {}; }
    wpDataChartsCallbacks[16] = function(obj){
        obj.options.plotOptions = {
            series: {
                connectNulls: true
            }
        }
    };
});
</script>

Just make sure to replace [16] with the ID of your chart.

And as mentioned earlier, this only works for the HighCharts Engine, 

I hope it helps.