chart not available

Resolved

(@cyclopdev)

Hi,

I have an issue with chart display.

I succeed to display Table with this shortcode :

[gdoc key="https://docs.google.com/spreadsheets/d/1GhYJgyB2q0xBn6CCibRs2m0hJZ3Jif_jchiJvykkhWE/edit#gid=0"  query="select E, sum(B) where E is not null group by E"]

but if I try to display any chart (for exemple “Pie”) :

[gdoc key="https://docs.google.com/spreadsheets/d/1GhYJgyB2q0xBn6CCibRs2m0hJZ3Jif_jchiJvykkhWE/edit#gid=0"  chart="Pie" query="select E, sum(B) where E is not null group by E"]

It doesn’t work.

I see this error message with inspector :

[Error] TypeError: undefined is not an object (evaluating 'jQuery.fn.dataTable.defaults')
	(fonction anonyme) (igsv-datatables.js, line 5)
	j (jquery.js, line 2)
	fireWith (jquery.js, line 2)
	ready (jquery.js, line 2)
	J (jquery.js, line 2)

And here is the source code of the page which seems to be regarding the chart display :

<div id="igsv-1-Piechart-1GhYJgyB2q0xBn6CCibRs2m0hJZ3Jif_jchiJvykkhWE" class="igsv-chart" title="" data-chart-type="Pie" data-datasource-href="https://docs.google.com/spreadsheets/d/1GhYJgyB2q0xBn6CCibRs2m0hJZ3Jif_jchiJvykkhWE/gviz/tq?tqx=out:csv&tq=select%20E%2C%20sum%28B%29%20where%20E%20is%20not%20null%20group%20by%20E&chart=true"></div>

Could it be a conflict with a Theme ?

Regards

https://ww.wp.xz.cn/plugins/inline-google-spreadsheet-viewer/

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author Meitar
(@meitar)

10 years, 8 months ago

When you go to the plugin’s Settings page (which should be at a page like [yourdomain.com]/wp-admin/options-general.php?page=gdoc_settings, what does it say in “DataTables defaults object”?

If there’s something there, try erasing what’s in that box and clicking “Save Changes” (with the “defaults object” text box blank). This will return the DataTables defaults object to the plugin default, which should fix your issue. I confirmed that with the default settings, the pie chart your sheets query produces works.
Thread Starter cyclopdev
(@cyclopdev)

10 years, 8 months ago
It says :
```
{"dom":"B<'clear'>lfrtip","buttons":["colvis","copy","csv","excel","pdf","print"]}
```
if I delete this text, it reappears after saving changes.
Pie chart still doesn’t work.
Plugin Author Meitar
(@meitar)

10 years, 8 months ago

if I delete this text, it reappears after saving changes.
Pie chart still doesn’t work.

Then I cannot reproduce your issue. It works for me on a default WordPress theme with these settings. Definitely consider looking into what other scripts are running on your site.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘chart not available’ is closed to new replies.