Page History

Panel

bgColor	white
titleBGColor	#f5f5f5
title	Managing Dynamic Charts from Table Data

Table Filter for Confluence add-on allows you to visualize your table data and create dynamic charts that you can configure and update on the fly while viewing Confluence pages. You can select the column containing labels and set one or multiple columns containing number values used for chart creation. Additionally, you can select the appropriate chart or graph type (pie, donut and 3D donut, column, bar, line, area, time line and time area). Optionally, you can set the decimal separator, specify the dimensions of the chart, and enable the hiding of the source table. You can modify settings of your charts and save modifications in the macro body while viewing the page.

Table of Contents

maxLevel	2

Widget Connector

width	432
url	https://www.youtube.com/watch?v=eiVywX8Hmp4
height	243

Starting from version 3.0.0 Table Filter add-on allows you to generate charts based on values from your data tables. The add-on supports the following types of charts:

Chart Parameters

These parameters determine the procedure of chart generation on Confluence page.

Expand

title	Click here to expand the available parameters of the Chart from Table macro...

Parameter	Default	Compatible with	Description
Labels Column	None	Pie Donut 3D Donut Column (Stacked) Bar (Stacked)	The column containing labels for data values.
Values column	None	Pie Donut 3D Donut Column (Stacked) Bar (Stacked) Time Line Time Area	The column containing numerical values for chart generation.
X-axis value column	None	Line Area	The column containing numerical values for chart generation.
Y-axis value column	None	Line Area	The column or columns containing numerical values for chart generation.
Dates column	None	Time Line Time Area	You can select the column with dates for chart generation.
Date Format	yy-mm-dd	Time Line Time Area	You can specify the date format used in the column with dates.
Type	Pie	Global	You can select the appropriate chart type.
Decimal Separator	Point	Global	You can select the decimal separator (either point or comma).
Height	None (dependable on screen area)	Global	You can define the height of the generated chart.
Width	None (dependable on screen area)	Global	You can define the width of the generated chart.
Hide the source table	Disabled	Global	You can hide the table with data and enable display of the chart only.
Hide chart controls	Disabled	Global	You can hide the chart controls when you need just to display the chart without a necessity to update its view.
Show legend	Disabled	Global	You can hide the legend for the generated chart.
Show grid	Enabled	Line Area Time Line Time Area	You can enabled display of the grid on the generated chart.
Chart Title	Disabled	Global	You can specify the title of the chart.
Align chart	Enabled	Center	You can define the appropriate alignment for the chart.
X-axis label	Disabled	Global	You can specify the label for X axis of the chart.
Y-axis label	Disabled	Global	You can specify the label for Y axis of the chart.
Minimal Value	Disabled	Column Bar Stacked Column Stacked Bar	You can specify the minimal value for showing only data values greater than the specified minimal value.
Maximal Value	Disabled	Column Bar Stacked Column Stacked Bar	You can specify the maximal value for showing only data values not greater than the specified maximal value.
Scale Step	Disabled	Column Bar Stacked Column Stacked Bar	You can specify the required scale step for showing the chart.
Minimal X Value		Line Area Time Line Time Area	You can specify the minimal value for X axis for showing only data values greater than the specified minimal value.
Maximal X Value		Line Area Time Line Time Area	You can specify the maximal value for X axis for showing only data values not greater than the specified maximal value.
Minimal Y Value		Line Area Time Line Time Area	You can specify the minimal value for Y axis for showing only data values greater than the specified minimal value.
Maximal Y Value		Line Area Time Line Time Area	You can specify the maximal value for Y axis for showing only data values not greater than the specified maximal value.
Scale X Step		Line Area Time Line Time Area	You can specify the required scale step of X axis for showing the chart. For Time Line and Time Area charts you can specify the appropriate number of days (Xd), months (Xm) or years (Xy) where the 'X' is the digit, as follows: 10d = 10 days as a scale step 1m = 1 month as a scale step 2y = 2 years as a scale step
Scale Y Step		Line Area Time Line Time Area	You can specify the required scale step of Y axis for showing the chart.
Logarithmic scale Y	Disabled	Line Area	You can enable this option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
Logarithmic scale X	Disabled	Line Area	You can enable this option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
Colors		Global	You can select the appropriate colors for charts and graphs instead of using the automatically assigned colors.
Logarithmic Scale		Pie Donut 3D DonutDisabled	Column (Stacked) Bar (Stacked) Time Line Time Area	You can enable this option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.

Inserting Chart from Table macro

There exist three ways to insert the Chart from Table macro on the page.

Macro Insertion

Instructions

Supported Data

Inserting the macro through the action icon on the editor pane

Switch Confluence page to the edit mode.
Position the mouse pointer within the table.
On the editor pane, click the Create a chart from table icon.

Info
This option is available in Confluence Server only.

Manually created and copied tables

Manual entry of the {Chart from Table} query on the page

Switch Confluence page to the edit mode.
Position the mouse pointer in the appropriate place on the page.
Start entering {Chart from Table}.
From the prompted list of macro choices, select Chart from Table.

Manually created and copied tables
Macros outputting table data

Selection of the Chart from Table macro in the Select Macro form

Switch Confluence page to the edit mode.
Position the mouse pointer in the appropriate place on the page.
On the editor pane, click Insert.
In the Select Macro form, locate the Chart from Table macro and insert it on the page.
Place the table within the macro.

Manually created and copied tables
Macros outputting table data

Configuring Table chart macro

On the Confluence page opened in the edit mode, click the Chart from Table macro.
Click Edit.
In the Edit Table chart Macro form, define parameters of the macro.
Click Save.

Managing Charts in the Page View Mode

Once you have defined settings of the Table chart macro and saved the page, you get a page with the generated chart.

To the right side of your chart, you can locate the chart management sidebar. It allows you to alternate the following parameters of Chart table macro:

Row Labels - change the column with labels for another one.
Values column - change the column with data values. The chart will be automatically re-generated. Depending on the used chart type you may select column with numerical through Values column X and Values column Y fields.
Dates column - change the column with dates. The chart will be automatically re-generated. This select box is shown for Time Line and Time Area charts only.
Type - change the chart type for another one. You may need to re-select the table columns when changing the chart type.
Height/Width - specify the required dimensions of the chart.

To save new parameters in the macro body:

Click the Cogwheel icon.
Select Save changes.

To export the chart:

Click the Cogwheel icon.
Select Export to PDF or Export to Word.

To save the chart as image:

Click the Cogwheel icon.
Select Chart as image.

To update the colors used for charts and graphs:

Click the Cogwheel icon.
Click Select colors.
Click the color picker and select the appropriate color on the palette.
Click Apply to use the selected colors and redraw your chart or graph.

Info
For the line and area charts, you will have to select the columns with numbers (Values Axis X and Values Axis Y)

Chart Examples

Pie chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Agent
Values column	Tickets per Hour
Type	Pie
Decimal separator	Point (.)
Height	Default
Width	Default

Agent	Tickets per Hour	Average Time per Ticket (min)	Calls per Hour
Remy Deomampo	4.6	5.1	4.2
Rahul Dickstein	4.8	1.6	1.3
Radu Donahue	6.4	5.6	1.5
Preston Doorey	4.7	1.3	1.6
Phill Doyle	2.0	3.4	2.7

Donut / 3D Donut chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Agent
Values column	Tickets per Hour
Type	Donut / 3D Donut
Decimal separator	Point (.)
Height	Default
Width	Default

Agent	Tickets per Hour	Average Time per Ticket (min)	Calls per Hour
Remy Deomampo	4.6	5.1	4.2
Rahul Dickstein	4.8	1.6	1.3
Radu Donahue	6.4	5.6	1.5
Preston Doorey	4.7	1.3	1.6
Phill Doyle	2.0	3.4	2.7

Line chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Tickets per Hour
Values column	Average Time per Ticket (min)
Type	Line
Decimal separator	Point (.)
Height	200
Width	400

Agent	Tickets per Hour	Average Time per Ticket (min)	Calls per Hour
Remy Deomampo	4.6	5.1	4.2
Rahul Dickstein	4.8	1.6	1.3
Radu Donahue	6.4	5.6	1.5
Preston Doorey	4.7	1.3	1.6
Phill Doyle	2.0	3.4	2.7

Column chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Column
Height	300
Width	600

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Stacked Column chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Stacked Column
Height	300
Width	600

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Bar chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Bar
Height	300
Width	400

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Stacked Bar chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets Total Tickets
Type	Stacked Bar
Height	300
Width	600

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2015	207	42	381	20	14	664
Q2 2015	278	31	247	58	39	653
Q3 2015	227	27	200	23	31	508
Q4 2015	257	20	237	58	40	612

Area chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Tickets per Hours
Values column	Calls per Hour
Type	Area
Decimal separator	Point (.)
Height	300
Width	400

Agent	Tickets per Hour	Average Time per Ticket (min)	Calls per Hour
Remy Deomampo	4.6	5.1	4.2
Rahul Dickstein	4.8	1.6	1.3
Radu Donahue	6.4	5.6	1.5
Preston Doorey	4.7	1.3	1.6
Phill Doyle	2.0	3.4	2.7

Time Line / Time Area chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Values Column	Average Time per Ticket (min)
Dates column	Date
Type	Bar
Decimal separator	Point (.)
Date format	dd.mm.yy
Height	300
Width	400

Date	Tickets per Hour	Average Time per Ticket (min)	Calls per Hour
25.06.2015	7.3	3.2	3.3
26.06.2015	8.5	3.1	1.8
27.06.2015	5.0	3.7	4.5
28.06.2015	2.2	5.8	2.7
29.06.2015	2.0	3.4	2.7

Line / Area chart (Logarithmic scale)

Info
Instead of using the default arithmetic scale, you can use the logarithmic scale that is convenient for too large or too small numbers.

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

X-axis value column	Temperature (Celcium degree)
Y-axis value column	Evaporation heat, Joule/kg
Type	Line
Logarithmic scale Y	Enabled

Temperature (Celcium degree)	Evaporation heat, Joule/kg
0.5	2.500E+6
75.4	2.322E+6
142.9	2.137E+6
200.4	1.930E+6
270.0	1.605E+6
350	0.893E+6
374.15	0.001E+6

Removing Chart from Table macro for Tables

Switch Confluence page to the edit mode.
Select the Chart from Table macro with the table or macro outputting the table.
Click Unwrap.

Space shortcuts

Page tree

Versions Compared

Old Version 28

New Version 29

Key

Chart Parameters

Inserting Chart from Table macro

Configuring Table chart macro

Managing Charts in the Page View Mode

Chart Examples

Pie chart

Donut / 3D Donut chart

Line chart

Column chart

Stacked Column chart

Bar chart

Stacked Bar chart

Area chart

Time Line / Time Area chart

Line / Area chart (Logarithmic scale)

Removing Chart from Table macro for Tables