Content Comparison

...

Table plus

autoNumber	true

Step

Description

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 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 (see example below)
The test data needs to match the requirements of the chart type you have selected!

Verify the chart display correctly

Add a sql-query macro outside the chart macro body

We are going to test to ensure that the sql-query macro is going to produce the correct format of table

Add you query to the sql-query macro body

Code Block

	sql
	sql

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

Verify it produces the same table structure as the test table

Combine the macros - this is the critical step!

Cut and paste the sql-macro into the body of the chart macro (discard or save the test data somewhere else)

...

Chart

Versions Compared