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).
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.
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.
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:
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.
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.