View Source

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 the column 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.

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:

Pie
Donut and 3D Donut
Column
Bar
Line
Area
Time Line / Time Area

Chart Parameters

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

Parameter

Default

Compatible with

Description

Row Labels

None

Pie
Donut
3D Donut
Column
Bar
Line
Area

The column containing labels for data values.

For the line chart, you should select the column containing numbers.

For the Time Line and Time Area charts, you should select the column with dates.

Values column

None

Pie
Donut
3D Donut
Column
Bar
Line
Area
Time Line
Time Area

The column 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.

Inserting Table chart macro

Switch the Confluence page to the edit mode.
Start entering {Table chart} and select the Table chart macro from the prompted context menu.
Click Insert.
The macro will be added to your page.
Insert your table into the Table chart macro.

Configuring Table chart macro

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

Using the Table charts

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 19:28:32.png

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.
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.
Chart Type - change the chart type for another one.
Height/Width - specify the required dimensions of the chart.

To save new parameters in the macro body, click Save settings. To download the chart image, click (OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 19:49:23.png .

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 15:25:19.png

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 15:27:44.png

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 15:47:24.png

Column chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Agent
Values column	Average Time per Ticket (min)
Type	Column
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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 15:48:22.png

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-10-28 12:45:9.png

Bar chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

Row Labels	Agent
Values column	Calls per Hour
Type	Bar
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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 15:51:56.png

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-10-28 12:50:2.png

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-2 12:44:51.png

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

(OUTDATED) Table Filter and Charts for Confluence > How to use Chart from Table macro > image2015-7-1 19:39:17.png