Hi, Chris

Thanks for reaching out to us

I am not 100 % sure if this is possible, to be fully honest with you,

but i will certainly make sure to check with our senior 2nd level Team, if there is a workaround to achieve this.

For example, we can easily hide rows on the table itself with Conditional rules, that if a cell is empty, to hide the entire row with CSS > but this is only affecting the table; the chart is still pulling all the values...

but on the chart they still show:

so, i will check if we got any workaround, and i will come back to you.  Sorry for the waiting time. Thanks.

Hi, Chris

Seems that we have a workaround for you.  Please try this:

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 me know if that helps. Thank you