Skip to end of banner
Go to start of banner

How to Create a Chart with SQL

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Summary

The chart macro combined with the sql macro provides powerful visual reporting capabilities. These macros were designed to work together. The sql macros produce standard Confluence tables. The chart macro produces charts from tables included in its macro body. Of course, the parameters of the chart macro must define a chart that can be produced from the format of the table (or tables) included in the chart macro body. So part of the challenge is to define the chart correctly to match with your table(s) produced by the sql macros and this depends on what you are trying to do and how you have constructed the sql. The chart macro has a number of parameters that can be adjusted to accommodate different table arrangements. We will show some simple examples here to get started. 

Steps

 

 

ProductsRevenue
A234,300
B346,212
C224,564
  • No labels