/
How to Create a Chart From SQL Data

How to Create a Chart From SQL Data

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.

(info) 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:

Recipe level

Ingredients

Preparation

Steps

More recipes

View all our Recipes for Business Intelligence & Automation. Here are some of our latest updates:

Find more recipes ...


Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Related content

How to Create a Chart From SQL Data
How to Create a Chart From SQL Data
More like this
How to Create a Self-Service Report From SQL Data
How to Create a Self-Service Report From SQL Data
More like this
How to Create a Self-Service Report From SQL Data
How to Create a Self-Service Report From SQL Data
More like this
How to Create a Business Intelligence (BI) Dashboard
How to Create a Business Intelligence (BI) Dashboard
More like this
How to Create a Business Intelligence (BI) Dashboard
How to Create a Business Intelligence (BI) Dashboard
More like this
How to create a chart with SQL - 8.x
How to create a chart with SQL - 8.x
More like this

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.