Hello sahinozyurek.

This is a row ID column, I believe. If you wish the chart to see each row as "1", you need to add a new integer column, which would have a predefined value set to "1". Then, you can hide that column from front end but still be able to use it in the chart.

It will be used just the way you wish.

Best regards.

Hi again sahinozyurek.

Glad to hear that helped.

As for the zero - yeah 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 1629:

case 'int':
    $return_data_row[] = (float)$row[$columnKey];
    break;
case 'float':
    $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 (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).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 page.

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

I hope this helps.

Best regards.

Hello again sahinozyurek.

The callback I showed you is just an example, and it is for Highcharts (I believe). Different engines have different approach to chart settings, so callbacks are a bit different as well.

I can try and help you out, but please note that using hooks or wpdatatable and wpDataChart callbacks requires certain level of programming skills and included support refers only to advice.

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. You can write credentials here just check Private Reply so nobody can see them except us.

Also, make sure to tell me what are the table and chart IDs so I know where to look.

Best regards.

Hello again sahinozyurek.

When I look at the pie chart 6 I see that the value that is not displayed is actually a string, not the integer (value) column.

I'm not sure the callback I shared with you could be used for that - it was intended to use to skip the values (in your case "1"), so it doesn't need to be skipped.

Also, The other chart has only two values:

If you were to hide the blue - it would show Koridor at 100%.

Can you create these two charts in Excel or something similar, and show me what they're supposed to look like.

Best regards.

Alright sahinozyurek

I believe we understand each other now.

This would actually be a lot easier to do.

For example, I'll take the same chart mentioned before: Zeka Oyunları Yarışması - İlkokul 3-4 - Toplam Başvuru Sayıları

When you get to select the columns, enable the range picker:

When you click on Range Picker, you can select the columns and rows you wish to plot in the chart:

So, after I picked those, that chart was generated like this:

I didn't apply those changes, though. Please go in your charts, and when you get to the Data range, select the Range Picker and choose the columns and rows you wish to plot on the chart, and I believe you will be able to display it correctly.

Best regards.

Hello again sahinozyurek

Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.

Unfortunately, skipping NULL string values simply isn't included in the plugin's features. I tried a workaround like I suggested for 'int' and 'float' but it doesn't work like that.

Although, I believe this can be done with custom callbacks, but like I mentioned before - this isn't included in the support of the plugin and is considered custom solution.

I do hope our developers will be able to include the skip NULL values soon, though.

Best regards.

Hi again sahinozyurek

Just to let you know, the suggestion has been forwarded to one of our developers.

As soon as I hear back from him, I will let you know.

Best regards.

Hello again sahinozyurek.

I believe we got it sorted out.

Please open wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.googleCharts.js and after this:

this.detectDates();

around line 141 add this line of code:

if (this.type == 'google_pie_chart'){
   for( var j in this.rows ){
     if (this.rows[j][0] ==""){
         this.rows.splice(j,1);
     }
   }
}

So it looks like this:

Please note, though, that this is a quick-fix and you will need to save my reply and do this again when the plugin updates.

Best regards.

Sounds like a deal, sahinozyurek.

You're welcome. I hope the issue is resolved.

Best regards.

Hi again sahinozyurek.

Alright, then. I'll forward it to one of our developers, so he can take a look at it again.

Thank you for your patience.

Best regards.

Hello again sahinozyurek.

I forgot to mention that you should disable "Use minified wpDataTables Javascript" slider in main settings of wpDataTables/Custom JS and CSS:

And also clear your cookies.

Please try this and let me know if it works.

Best regards.

Hi again sahinozyurek.

It works on our end, so I'm not exactly sure what's going on, on your side.

Can you, please, either enable the Plugin Editor within WordPress, or provide me with FTP credentials, so we can take a look at our plugin's code?

Best regards.

Hi again sahinozyurek.

Thanks for the FTP, but it appears to be FTP to access logs:

I went into each of these folders, and couldn't find public_html, or anything similar where I'd be able to access wpDataTables code, through ../wp-content/plugins/wpdatatables.

Can you, please check that, and let me know?

Best regards.

Hello again sahinozyurek.

Thanks for that. I found it.

Now, I mentioned when I sent you the code, that it is a hot-fix, and that you would need to apply it again after the plugin is updated. When I opened ..wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.googleCharts.js I saw that the fix was not there:

So, I added it, and saved the file:

After that I opened the https://www.bayraklimemetkinlikleri.com/test2/ page in incognito mode, and saw that the empty value has been skipped:

However, when I open the same page while logged into WordPress, it is still displaying the empty value:

This indicates that there are probably some settings in your caching plugin other than what's displayed on the page. You need to delete all cache on your website, and you will see it like another customer does (for me - incognito mode).

Please let me know.

Best regards.

Hi again sahinozyurek.

You're welcome, glad I could help.

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.

Best regards.