Using Chart and SQL Query, table not found, No Data Available

I created a Chart macro within a page, I then added within the body of the macro, a SQL Query that does yield results in the preview :

I then went to the settings of the Chart macro and was unable to find the table, so I entered the propery value:

I have tried following the instructions @ https://bobswift.atlassian.net/wiki/spaces/SQL/pages/102466756/How+to+Create+a+Chart+with+SQL but not having any success, even if I replace the SQL Query with an embedded table.

What am I not doing correctly?

1 answer

0 votes

Answer accepted

Hi @[deleted]

Please, try to change the order of columns in the "Columns" field of the macro.

Also, you can try the Chart from Table macro (Table FiIter and Charts app), this macro should be more user-friendly.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Andrey, thanks for bread crumbs! I was able to get it working w/o trying another macro

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.