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!
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!