I receive this error message: "Please do not add more then one string-type (date/time, image, email, URL) column since only one can be used as a label" when referencing a csv file with two columns: One is a list of business types, the second is a list of percentages which I wish to turn into a chart. I am required to have a title for each column (a string), but the percentages could be floats...However, when I assign "float" to that column, the numbers all turn to "0's". I've imported several columns before successfully without seeing this error. What am I doing wrong? Simple pie, bar, whatever chart with two info columns. I've watched the videos and the don't address this issue. This guy: https://codecanyon.net/user/boedakpinank asked the same question (see attachment).
If it doesn't contain any sensitive data - could you send us that CSV file, so we can take a look?
Usually, when it returns "0" instead of actual values, it means the float format is different in the source file and wpDataTables settings (original file has 1.23 and wpDataTables is set to 1,23).
Another thing about the charts - it simply can't handle more than one "String" type columns (date/time, image, string, URL, e-mail), so you got it right - changing to "Float" will resolve the issue.
I'll provide better feedback once I see the file. If possible, of course.
Thank you, Aleksandar. I did eventually find documentation that addressed my issue. It involved removing the percentage sign on my .csv table then adding it back in via the table display settings as a suffix. Everything worked just fine from there. Please mark this issue as resolved.
I do have another question. Let me know if you'd prefer that I open up a new support ticket:
I'm not fluent in js, so css would be my preferred way to style individual columns in a bar chart in the absence of a color-picker in the admin area. Say, for example, I was charting the percentage of money spent on grocery store purchases during a single visit. My Y axis might be the percentage and X axis the various grocery items. How would I color each column of data (on a bar chart) individually - as opposed to the whole series? Can you point me to documentation describing how best to add/discover classes that target the individual columns, or am I just better off learning to use the script method?
All functionalities of wpDataCharts present in the built-in versions are the ones you can find in the settings of each chart, but if you need some custom solution you can check in our documentation about wpDataCharts callbacks. There are some examples there of changing the color.
Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpdatachart callbacks allows adding options that are available in Google Charts API, Highcharts API and Chart.js API.
All necessary resource are available in charts engines API (depends on which one you use). Every engine has different approach of charts settings. In wpdatachart callbacks you have to adopt those settings to wpdatachart object(you can take a look an example for each engine in our documentation and also in Support help center). Huge number of examples for any area of programming you can find on stackoverflow.com(typing your problem in google and of the end add site:stackoverflow.com and google will search only on that website) and also a lot of resource of examples of chart, chart settings and customization you can find on jsffidle. net(typing in google for example line chart highcharts jsffidle)
Please note that using hooks or wpdatatable and wpdatachart callbacks requires certain level of programming skills and included support refers only to advises.
I receive this error message: "Please do not add more then one string-type (date/time, image, email, URL) column since only one can be used as a label" when referencing a csv file with two columns: One is a list of business types, the second is a list of percentages which I wish to turn into a chart. I am required to have a title for each column (a string), but the percentages could be floats...However, when I assign "float" to that column, the numbers all turn to "0's". I've imported several columns before successfully without seeing this error. What am I doing wrong? Simple pie, bar, whatever chart with two info columns. I've watched the videos and the don't address this issue. This guy: https://codecanyon.net/user/boedakpinank asked the same question (see attachment).
I've tried Excel, Numbers and Google Sheets.
Thanks
Hi Daniel.
Thank you for your purchase.
If it doesn't contain any sensitive data - could you send us that CSV file, so we can take a look?
Usually, when it returns "0" instead of actual values, it means the float format is different in the source file and wpDataTables settings (original file has 1.23 and wpDataTables is set to 1,23).
Another thing about the charts - it simply can't handle more than one "String" type columns (date/time, image, string, URL, e-mail), so you got it right - changing to "Float" will resolve the issue.
I'll provide better feedback once I see the file. If possible, of course.
Best regards
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you, Aleksandar. I did eventually find documentation that addressed my issue. It involved removing the percentage sign on my .csv table then adding it back in via the table display settings as a suffix. Everything worked just fine from there. Please mark this issue as resolved.
I do have another question. Let me know if you'd prefer that I open up a new support ticket:
I'm not fluent in js, so css would be my preferred way to style individual columns in a bar chart in the absence of a color-picker in the admin area. Say, for example, I was charting the percentage of money spent on grocery store purchases during a single visit. My Y axis might be the percentage and X axis the various grocery items. How would I color each column of data (on a bar chart) individually - as opposed to the whole series? Can you point me to documentation describing how best to add/discover classes that target the individual columns, or am I just better off learning to use the script method?
Thanks for your timely help.
Daniel
Hi Daniel.
Glad to hear you got it to work!
All functionalities of wpDataCharts present in the built-in versions are the ones you can find in the settings of each chart, but if you need some custom solution you can check in our documentation about wpDataCharts callbacks. There are some examples there of changing the color.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables