How to create chart using sql query?

Hi, I have created charts in Report Studio using Insertable objects inside the package. But, when I try to do the same using my own sql query(Query1 inside Insertable object pane) the chart shows no data there.
Can we make charts based on the result produce by a custom sql query.
::slight_smile: Please help.