How to create a chart with SQL - 8.x

Create a new page.

Add a Chart macro.

• Set the chart type; this example uses a pie chart.

• Edit other parameters as needed.

• For this example:

  • Set Content orientation to vertical - this is required because we want to use table rows for the values.

  • Optional: Set Display rendered data as 'after'.

  • Optional: Set Pie section label to '%0% (%2%)'.

Create a small example table in the Chart macro body.

• This is just a quick way to get the chart defined and working.

• Use INSERT table with a few rows and columns.

• The test data must match the requirements of the chart type you have selected.

Verify the chart displays correctly.

Add a SQL Query macro outside the Chart macro body.

This is to ensure that the SQL Query macro is going to produce the correct format of the table.

Add your query to the SQL Query macro body.

For example:

select product as "Product", revenue as "Revenue" from revenue

Verify it produces the same table structure as the test table.

Now, you should have both macros configured correctly.

Combine the macros - this is the critical step!

Drag and drop the SQL macro into the body of the Chart macro (discard or save the test data somewhere else).