Create a Bar chart using SQL macro

Owned by Smita Nair
Last updated: Feb 25, 2020

Scenario

Estimated Time: 11 min

As an example, let's create a 3-D bar chart to display the top publishers by revenue (in $M). 

Background

Our scenario uses a data source profile, BookWarehouse, to query a database table, 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 |
+----+------+-------------------+-----------------+---------+

For more information about data source profiles, click the appropriate version:

Our 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: