Hi, Management Council

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.

-

If i understood, you wish the chart to "skip null values" and ignore/not load them?

If that is the case, we have a workaround :

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){
        $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.

Let us know if that is what you needed.

If not, please correct me if i misunderstood the goal. Thank you

Hi, Mike

In that case, i won't apologise again for the delay, but i will just point out that we don't work weekends,

it added the two extra days to the hold up

-

I will have to double-check that,

as far as i am aware, this code should work for all table types ( besides Simple tables),

but we will check to make sure.  If you solve it in the meantime, let us know,

and i will report back as quickly as possible to confirm if this should work with charts that are made from Excel linked tables.

Thank you

Hi, Mike

Thank you for all the patience once again, i got advised by our 2nd level Team.

This workaround to skip NULL for charts would definitely be working for all table types,

so we can take a look and try to see if there is any kind of a small modification that needs to be done for this to work on your site.

Could you please grant us access to the WP-Admin of the site, as well as FTP access,   so that we can check how you applied the workaround?

-

Please provide me a temporary WP-admin (administrator) user for your site where this happens, as well as credentials for FTP,

so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

-

And please point me to any chart ID as an example that we can check while we do this.

Thank you