Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Hi,
I'm trying to create a Pie Chart. It tells me that it needs 1 of the columns to be a "string". One column is 'id' and the other is value (int), both numbers.
In the MySQL query, I've used CAST(id as char(5)) to convert INT to CHAR. The table renders without a problem, but the Chart Wizard freezes while creating the preview.
What would be the correct way of creating a Pie Chart? (either with two numbers or converting to string).
Thank you
Hi darimany,
Thank you for your purchase.
When you are are creating Pie or Doughnut chart one column should be String or Date column type and that column will be used for Pie Chart slices. Other column that you add should be Integer or Float column type and that column will be used for slice value.
You can define Column Type for each column in table settings.
You can take a look at chart examples on this pages - Google Charts - Highcharts
Hi Milos,
I tried with strings and intergers - pie, bar or any other chart.
The tables aren't too large, 10 rows.
I tried to disable/enable the plugin but didn't work.
Should I send you a temporary admin?
Hi darimany,
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. You can write credentials here just check PRIVATE so nobody can see it except us.
Hi darimany,
What is the table ID that you are using for creating chart?
Using Table 9 (only has 10 rows), tried with other tables also.
Google charts
Tried with: Pie chart or Bar chart
Columns: NAICS (string), Loans 2015 (int)
The column NAICS is int and formated to string on wpDataTables.
NOTE: I had the free version installed so I could test and then got the paid version. Does it matter?
Hi darimany,
The problem is causing NAICS column. It is set to String but actual in this column all values are numbers and Google Chart library doesn't allow that. You can create Highchart Pie chart from these two columns or you have to Change NAICS Column so that contains some letters and not just numbers. Maybe you can add apostrophes in NAICS column before and after number and it should work. E.g:
Instead:
11432
You can try with:
"11432"
I'll try it. Will let you know.
Looks like the problem is with Google charts. I tried with HighCharts and it worked... at least for our test case.
I quoted the field (NAICS) for table id 9 and tried with Google charts and did NOT work. It DID work with HighCharts.
Hi darimany,
Yes problem is with Google Charts. String column that you are adding to chart has to contains letters, not just numbers. If you change NAICS column to letters or add any other String column that contain letters chart will work.