Hello Joshua

That is an issue we've been dealing with, because integer and float columns cannot have anything other than numbers in them, the plugin is treating an empty cell as "0"

I can try and help you out, but you have to make some changes in code in file :

/wp-content/plugins/wpdatatables/source/class.wpdatachart.php around line 1631:

case 'int':
   $return_data_row[] = (float)$row[$columnKey];
 break;
   case 'float':
     if ($decimalPlaces != -1){
       $return_data_row[] = (float)number_format(
         (float)($row[$columnKey]),
         $decimalPlaces,
         '.',
         $thousandsSeparator ? '' : '.');
       }else {
           $return_data_row[] = (float)$row[$columnKey];
       }
break;

and replace it with this

case 'int':
                                if (is_null($row[$columnKey])){
                                    $return_data_row[]= null;
                                }else{
                                    $return_data_row[] = (float)$row[$columnKey];
                                }
                                break;
                            case 'float':
                               if ($decimalPlaces != -1) {
                                   if (is_null($row[$columnKey])) {
                                       $return_data_row[] = null;
                                   }else {
                                       $return_data_row[] = (float)number_format(
                                           (float)($row[$columnKey]),
                                           $decimalPlaces,
                                           '.',
                                           $thousandsSeparator ? '' : '.');
                                   }
                               } else {
                                   if (is_null($row[$columnKey])) {
                                       $return_data_row[] = null;
                                   }else {
                                       $return_data_row[] = (float)$row[$columnKey];
                                   }
                               }
                                break;

With these changes you will get charts like on the first screenshot below.

If you want to make charts like on screenshot #2 you have to use wpdatachart callbacks and insert that on page where your chart is.

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

One more thing you have to change in this callback number 39 in (wpDataChartsCallbacks[39]) to id of the chart that you use on the page.

This will be overwritten on next update so you have to come back here and do it again.

Also, you should disable "Use minified wpDataTables Javascript" slider in main settings of wpDataTables/Custom JS and CSS:

And also clear your cookies.

Hi again Joshua

Did you disable "Use minified wpDataTables Javascript" slider in main settings of wpDataTables/Custom JS and CSS? This is the most common mistake.

If you did, and it's still not working fine, please provide me a temporary WP-admin login for your site where this happens, 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 party. Also, make sure to tell me what's the table and chart ID, so I know where to look.

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

Hey Joshua.

Sorry to hear that didn't work.

I don't know what you tried with the query, but take a look at this thread. It looks simple enough.

I just tried it, and it works for me:

So, in wpDataTables, if I use SELECT * FROM null_integer, it comes out like this:

But if I use this query:

SELECT Name, 
        IFNULL(Numbero,0) AS Numbero, 
        IFNULL(floato,0) AS Floato
FROM null_integer

It comes out like this:

If you see some columns missing after applying the query above (with IFNULL), disable server-side processing; save the table, and then enable server-side processing again (if you don't need it, you can leave server-side processing off). Please let me know if that helps.

You're welcome, Joshua

Glad I could be of service!