How to Create a Chart From SQL Data
- Betsy Walker
- Mat Gauvin (Inactive) (Deactivated)
On this page
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 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 macro.
It will take you approximately 8-10 minutes to complete this recipe. Jump to Step 5 to see a preview of the final result!
See our other related BI recipes:
- How to create a self-service report from SQL data (Intermediate)
- 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
More recipes
View all our Recipes for Business Intelligence & Automation. Here are some of our latest updates:
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.