.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
Scenario
Estimated Time: 11 min
In this scenario, we will create a 3-D bar chart to display "Top Publishers by Revenue (in $M).
Background
Our scenario uses a data source profile called "BookWarehouse" to query a database table called "PUBLISHERS". The table contains the following columns and rows:
SQL > select * from publishers; +----+------+-------------------+-----------------+---------+ | id | rank | parent_company | company_name | revenue | +----+------+-------------------+-----------------+---------+ | 10 | 1 | Pearson | Pearson | 5000.00 | | 11 | 2 | Reed | RELXGroup | 4900.00 | | 12 | 3 | WoodbridgeCompany | ThompsonReuters | 4700.00 | | 13 | 4 | BertelsmannAG-NV | Bertelsmann | 4500.00 | | 14 | 5 | WoltersKluwer | WoltersKluwer | 4100.00 | +----+------+-------------------+-----------------+---------+
Our example query against the PUBLISHERS table looks like:
SELECT company_name as "Publisher", CONCAT('$',format(revenue,0)) as "M Rev" FROM publishers ORDER BY rank asc;
Steps
The following steps demonstrate how to use Markup to insert Confluence's native Chart Macro and our SQL macro on a Confluence page.
