View Source

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

Chart Examples

Pie chart

Parameters in Macro Browser

Data Table in Macro Placeholder

Rendered Chart

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

Customer	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	Customer
Values column	Tickets per Hour
Type	Donut / 3D Donut
Decimal separator	Point (.)
Height	Default
Width	Default

Customer	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

Customer	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

Customer	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

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

Customer	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

Area 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

Customer	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 16:21:29.png