Recipe overview

This Business Intelligence (BI) recipe provides step-by-step instructions on building a pie chart based on a SQL data source – one of nearly limitless use cases for transforming raw data into meaningful and useful information for business analysis purposes. This recipe utilizes the following items:

• The Run Self-Service Reports for Confluence add-on to provide a form through which the user can choose selection criteria for the data to be presented in the chart.
• The Chart macro, which comes natively with Confluence, to produce the pie chart.
• The SQL for Confluence add-on, which comes in both Express and Pro editions, to query a SQL database to retrieve the data to be presented in the chart.
• The Macro Security for Confluence add-on to safeguard the page and the database it uses by ensuring that only Administrators can use the SQL Query macro.

It will take you approximately 13-16 minutes to complete this recipe. Jump to Step 6 to see a preview of the final result!

See our other related BI recipes:

• How to Create a Chart From SQL Data (Basic)
• How to Create a Business Intelligence (BI) Dashboard (Advanced)

Recipe level

Ingredients

Preparation

• Install MySQL and the sample Examplegear Database, including defining the "examplegeardb" data source profile.

Steps