We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
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.