1. I created a table with 2 columns: one for year, one for retail sales; tried chart.js to render but it does not display either axis label (whether I set it or not) or the year.
2. I tried to render with Google Charts. The problem is, it shows the year with thousand separator like 2,018 even though I set it in the table column (and in the table display, it's working and not showing the thousand separator.)
3. I found that if I try to update the column type (e.g. from integer to float), it always see "internal server error" message. In cases I need to change it, I have to re-create the table.
4. How do i display the chart values? Or any way to do so?
5. When i insert the embed code to a custom post type, only table can display and chart does not display; when I do so on a Page, both can display.
Yes charts depends of the column type in the table. So if you set for years column type on integer or float it will be render like that without escaping thousand separator or decimal. You can overwrite options from charts with wpDataCharts callbacks . Every chart exposes a number of options that customize its look and feel. Charts usually support custom options appropriate to that visualization. This callbacks allows adding options that are available in Google Charts API, Highcharts API and Chart.js API
But easy way is it set column year to sting column type(I suppose that other columns are integers or floats, because you can use only one string column in chart wizard)
Can you please send me link of the page where charts are not shown properly so I can take a look?
We visit page that you provide and we see that wpdatachart object is undefined. That is probably related with functionality of that custom post type with which we are not familiar. You can try with do_shortcode function.
If you already using some column in chart that have column type string then changing year to string will not help because in charts you can use only one column that have column type string. In that case you willl have to set it to column type integer and use wpdatachart callback to format labels of axis without thousand separator.
I suppose that there is some custom script that that plugin use and make conflict with our plugin.
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.
I'm not sure why you asked for admin access and just told us there's google ads code (which can be found out in the source) after we created one and gave it to you.
However, we tested it for you and no matter which engine we used, highcharts or chart.js, they don't display at all if inserting the shortcode in a custom post type page like here:
If inserting the shortcode on a Page, the chart always shows.
We'll give it last try before sharing giving up on this plugin. Unfortunately, the experience so far is really not good. Thanks for the help.
We apologize for that, but you said in previous post :
Please diagnose only and let me know what to change or update.
just to diagnose so we didn't want to change or test anything. We have customers with similar issue so because of that we suggest to make another chart type to see is related only for google charts.
After a detailed review of our code and scripts that are rendered on pages we found that some of the fields are changed.(attachment)
After that we check your plugins and we found that you are using some plugin SEO Smart Links that replace engine name in our script from google to some custom link.
When we deactivate him our charts are rendered fine and we check our scripts after that and you can see that is properly rendered.(attachment)
Can you please deactivate this plugin and you will see that charts are showing without any problems?
1. I created a table with 2 columns: one for year, one for retail sales; tried chart.js to render but it does not display either axis label (whether I set it or not) or the year.
2. I tried to render with Google Charts. The problem is, it shows the year with thousand separator like 2,018 even though I set it in the table column (and in the table display, it's working and not showing the thousand separator.)
3. I found that if I try to update the column type (e.g. from integer to float), it always see "internal server error" message. In cases I need to change it, I have to re-create the table.
4. How do i display the chart values? Or any way to do so?
5. When i insert the embed code to a custom post type, only table can display and chart does not display; when I do so on a Page, both can display.
Hi rockyfp,
Thank you for your purchase.
Yes charts depends of the column type in the table. So if you set for years column type on integer or float it will be render like that without escaping thousand separator or decimal. You can overwrite options from charts with wpDataCharts callbacks . Every chart exposes a number of options that customize its look and feel. Charts usually support custom options appropriate to that visualization. This callbacks allows adding options that are available in Google Charts API, Highcharts API and Chart.js API
But easy way is it set column year to sting column type(I suppose that other columns are integers or floats, because you can use only one string column in chart wizard)
Can you please send me link of the page where charts are not shown properly so I can take a look?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi rockyfp,
We visit page that you provide and we see that wpdatachart object is undefined. That is probably related with functionality of that custom post type with which we are not familiar. You can try with do_shortcode function.
If you already using some column in chart that have column type string then changing year to string will not help because in charts you can use only one column that have column type string. In that case you willl have to set it to column type integer and use wpdatachart callback to format labels of axis without thousand separator.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
sorry I’m not that technical? Do u mean I can’t use ur plugin for custom post type? What do I do “try do shortcode”? Thanks a lot
Hi rockyfp,
I suppose that there is some custom script that that plugin use and make conflict with our plugin.
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.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
I'm not sure why you asked for admin access and just told us there's google ads code (which can be found out in the source) after we created one and gave it to you.
However, we tested it for you and no matter which engine we used, highcharts or chart.js, they don't display at all if inserting the shortcode in a custom post type page like here:
If inserting the shortcode on a Page, the chart always shows.
We'll give it last try before sharing giving up on this plugin. Unfortunately, the experience so far is really not good. Thanks for the help.
Hi rockyfp,
We apologize for that, but you said in previous post :
Please diagnose only and let me know what to change or update.
just to diagnose so we didn't want to change or test anything. We have customers with similar issue so because of that we suggest to make another chart type to see is related only for google charts.
After a detailed review of our code and scripts that are rendered on pages we found that some of the fields are changed.(attachment)
After that we check your plugins and we found that you are using some plugin SEO Smart Links that replace engine name in our script from google to some custom link.
When we deactivate him our charts are rendered fine and we check our scripts after that and you can see that is properly rendered.(attachment)
Can you please deactivate this plugin and you will see that charts are showing without any problems?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Great! That's what I need to know. Fixed. Thanks.
Hi rockyfp,
You are welcome.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a Review on CodeCanyon on this link. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables