We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Is there a way to have Charts ignore empty values? For instance I have a column that may have some blank rows depending on the values of other fields.
I need to ignore those empty fields so that they are not used when creating a chart. (a column with 10 rows, 8 are empty, 2 are populated should only include 2 results in the chart)
Is this possible?
Hi Matt
Thank you for reaching out to us.
By default, integer and float columns need to have numerical data in them, meaning NULL is not a valid cell value, so it will be replaced by a 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.
I hope this helps.