On https://covid19now.com/covid-19-canada/ you will see that COVID-19 by Province shows just 1 case (or 2 by the time you read this) for Quebec. Well, the actual number is 1629. This is not showing in the table because the only way I can get the table to render in a chart is to make the column called "Number of Confirmed Cases" an Integer which changes 1,629 to just a 1.
(UPDATE: you won't see this issue now because I changed it to a string for now so the data in the table would be accurate - unfortunately that means I had to remove the table. I have a programmer working on stripping the commas from the feed, but it would be nice to see another option available)
Is this because it doesn't pay attention to anything after the comma in the number I'm given by my API?
Since having commas in data this is a common issue among API data, how do I get around this?
I didn't understand your update comment. You couldn't have included two String columns in a chart (Province and Confirmed) simply because the chart engines wouldn't accept this.
Which API did you use, and why? You can take a look at our documentation about wpDataCharts callbacks if you need to change the number format. We also have some working examples in our FAQ section/examples.
Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API and Chart.js API.
Huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and google will search only that website). Also, a lot of examples of charts, chart settings and customization can be found 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 advice.
If I misunderstood anything, please let me know, and explain in a bit more detail, so I can help you out better.
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.
On https://covid19now.com/covid-19-canada/ you will see that COVID-19 by Province shows just 1 case (or 2 by the time you read this) for Quebec. Well, the actual number is 1629. This is not showing in the table because the only way I can get the table to render in a chart is to make the column called "Number of Confirmed Cases" an Integer which changes 1,629 to just a 1.
(UPDATE: you won't see this issue now because I changed it to a string for now so the data in the table would be accurate - unfortunately that means I had to remove the table. I have a programmer working on stripping the commas from the feed, but it would be nice to see another option available)
Is this because it doesn't pay attention to anything after the comma in the number I'm given by my API?
Since having commas in data this is a common issue among API data, how do I get around this?
It is compromising the quality of my website.
Thank you, Ross
Hi Ross
Thank you for your purchase.
I didn't understand your update comment. You couldn't have included two String columns in a chart (Province and Confirmed) simply because the chart engines wouldn't accept this.
Which API did you use, and why? You can take a look at our documentation about wpDataCharts callbacks if you need to change the number format. We also have some working examples in our FAQ section/examples.
Every chart exposes several options that customize its look and feel. Charts usually support custom options appropriate to that visualization. wpDataChart callbacks allow adding options that are available in Google Charts API, Highcharts API and Chart.js API.Huge number of examples for any area of programming can be found on stackoverflow.com (typing your problem in google and at the end add "site: stackoverflow.com" and google will search only that website). Also, a lot of examples of charts, chart settings and customization can be found on jsffidle.net (typing in google for example "line chart highcharts jsffidle")
If I misunderstood anything, please let me know, and explain in a bit more detail, so I can help you out better.
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,
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