MySQL query data not populating into table/chart/etc

Thanks for the replies everyone!

I ended up rewriting the query in a different format, which caused virtually the same output and worked using the table and charts.

Not sure why the original query didn't work, but it's going now!