Scenario
| Div |
|---|
|
 Estimated Time: 13 min
|
In this scenario, we will create a Bar chart to display "Book Print Operational Costs".
Background
Our scenario will use a Data Source Profile called "BookWarehouse" to query a database table called "PRINTOPERATION". The table contains current min, max, and average operational costs associated with the printing and go-to-market costs for books. For this scenario, we will focus on charting the current average market costs for each type of print operation:
...
| Code Block |
|---|
|
SELECT printoperation as "Service"
,format(avgcost,0) AS "AvgCostCost"
FROM printoperation; |
Steps
...
| Table plus |
|---|
| border | 0 |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| enableHeadingAttributes | false |
|---|
| columnAttributes | style="border:0;width=5%;",style="border:0;width=65%;",style="border:0;width=30%;max-width=30% !important;" |
|---|
| id | steps_table |
|---|
| enableSorting | false |
|---|
| enableHighlighting | false |
|---|
|
| Create Confluence pageCreate a Confluence page that will eventually contain the macros needed to produce the chart. - Create a page named Print Operations in a space accessible to the desired audience.
- Click Save to close the Page Restrictions screen.
- Click Save to save to publish the new page.
|
|
| | Edit the Print Operations page and do the following: - Insert the Chart macro.
- Click the Chart macro container and click Edit so you can adjust its parameters as shown on the right.
- The Type parameter indicates to display a Pie chart.
- The Width parameter indicates the width of the chart in pixels.
- The Height parameter indicates the height of the chart in pixels.
- The Column parameter indicates the column name or order of mapping from the query result to the chart.
- The Chart Title parameter provides a title for the chart.
- The Show legend parameter will display the name associated with the colored bars rendered.
- Click Save to save your changes to the Chart macro's parameters.
| Chart macro parameters: | Type | pie | | Width (pixel value only) | 600 | | Height (pixel value only) | 400 | | Column | Service, Cost | | Chart Title | Average Print Operational Costs | | Show legend |  |
|
| | This step uses the SQL Macro, to retrieve the data that will be displayed in the bar chart. To configure the SQL Macro, do the following: - Edit your Print Operations page.
- Add a line below your Chart Macro.
- Using Markup, insert a new SQL Macro on the page (more on Markup here).
- Adjust its parameters as shown on the right.
- The Data source name parameter indicates to use the BooksWarehouse data source profile that you set up.
- The Use database column labels parameter indicates to use the column names defined within the SELECT statement (e.g., Publisher, M Rev.) rather than the columns names defined within the database table(s) themselves.
- The Show error if there are no rows parameter indicates to show an error if no rows are returned in the resultset of the SQL query.
- The Text to display when there are no rows parameter indicates the text of the error message to be displayed when no rows are returned in the resultset of the SQL query.
- Click Save to save your changes to the SQL Macro's parameters.
With the cursor positioned inside the SQL Macro container, paste in this SQL statement: | Code Block |
|---|
| language | sql |
|---|
| theme | DJango |
|---|
| linenumbers | true |
|---|
| SELECT printoperation as "Service"
,format(avgcost,0) AS "AvgCostCost"
FROM printoperation; |
Using your mouse, "drag" the SQL Macro container into your Chart Macro container (see right).
| SQL Macro parameters: | Data source name | BooksWarehouse | | Use database column labels | selected | | Show error if there are no rows | selected | | Text to display when there are no rows | No rows selected |
Moving the SQL Macro inside the Chart Macro  Image Added
|
| | Save and test the pageNow, go back to the Print Operations page and click Save to save it. You should now see a page that appears as shown on the right.
| Book Print Operational Costs:  Image Added
|
|
