Problem viewing Pie chart using MySQL as source

I’ve got a Pie Chart working with a spreadsheet as the source. When I switch and try to pull the same basic information from a MySQL database it will only displays the datatable. The data is correct. I just need it in a graph and I’m not sure what I’m doing wrong.

This is the shortcode used:

[gdoc
class=”no-responsive”
key=”wordpress”
title=”Summary”
query=”SELECT type AS Type, sum(total) AS Total FROM sample GROUP By Type”
chart=”Pie”
]

Please let me know if you need further information.